Layers:

Layer: GIS_Activities (0)


Name: GIS_Activities

Display Field: pocname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -11886895.9727835
YMin: -1E-08
XMax: 1E-08
YMax: 4383073.53151101
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: globalid

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• actid (type: esriFieldTypeString, alias: Activity ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• actcategory (type: esriFieldTypeString, alias: Request Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acttype (type: esriFieldTypeString, alias: Request Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• details (type: esriFieldTypeString, alias: Request Details, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• urgent (type: esriFieldTypeString, alias: Is this an urgent request?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• businessunit (type: esriFieldTypeString, alias: Business Unit, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pocname (type: esriFieldTypeString, alias: First and Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestdt (type: esriFieldTypeDate, alias: When do you need this done by?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• assignedto (type: esriFieldTypeString, alias: Assigned To, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• plannedstartdt (type: esriFieldTypeDate, alias: Planned Start Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• plannedenddt (type: esriFieldTypeDate, alias: Planned End Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• plannedeffort (type: esriFieldTypeDouble, alias: Planned Effort, SQL Type: sqlTypeOther, nullable: true, editable: true)
• actualenddt (type: esriFieldTypeDate, alias: Resolution Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• orggoal (type: esriFieldTypeString, alias: Organizational Goal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• prggoal (type: esriFieldTypeString, alias: GIS Program Goal, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• capabilities (type: esriFieldTypeString, alias: ArcGIS Capabilities, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Submitted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Submitted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• recurring (type: esriFieldTypeString, alias: Is this a recurring activity?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• frequency (type: esriFieldTypeString, alias: Frequency, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Daily: Daily], [Weekly: Weekly], [Biweekly: Biweekly], ... 6 more ...)
• confidential (type: esriFieldTypeString, alias: Will any data contain Protected Health Information (PHI) or Personally Identifiable Information (PII)?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• externalsharing (type: esriFieldTypeString, alias: Will this project be shared with people outside of DSHS employees?, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes, I will need to share with external stakeholders (i.e., LHDs, county judges, etc.)], [No: No, this will only be shared with DSHS employees.], [Unsure: I am unsure.])
• fiscalyear (type: esriFieldTypeInteger, alias: Fiscal Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• projectpath (type: esriFieldTypeString, alias: Project Pathway, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)

Templates:

Name: GIS_Activities
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Relationships:
• Effort (0) -- Related To: Effort (2)
• Comments (1) -- Related To: Comments (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/1/2025 8:02:53 PM

Schema Last Edit Date: 8/1/2025 8:02:53 PM

Data Last Edit Date: 8/1/2025 8:02:53 PM

Tables:

Comments (1)


Name: Comments

Display Field: comments

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: globalid

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• activityglobalid (type: esriFieldTypeGUID, alias: Activity GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• visible (type: esriFieldTypeString, alias: Visible to Customer, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Submitted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Submitted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Comments
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• GIS_Activities (1) -- Related To: GIS_Activities (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/1/2025 7:14:34 PM

Schema Last Edit Date: 8/1/2025 7:14:34 PM

Data Last Edit Date: 8/1/2025 8:02:53 PM

Effort (2)


Name: Effort

Display Field: created_user

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: globalid

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• activityglobalid (type: esriFieldTypeGUID, alias: Activity GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• actualeffort (type: esriFieldTypeDouble, alias: Actual Effort (in hours), SQL Type: sqlTypeOther, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Submitted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Submitted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Effort
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• GIS_Activities (0) -- Related To: GIS_Activities (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/1/2025 8:01:55 PM

Schema Last Edit Date: 8/1/2025 8:01:55 PM

Data Last Edit Date: 8/1/2025 8:02:53 PM