Layers:

Tables:

Effort_Activities (0)


Name: Effort_Activities

Display Field: created_user

Type: Table

Is View: true

Is Updatable View: false

Source Schema Changes Allowed: false

Description: AttributeJoin

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:
• 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)
• ActivityID (type: esriFieldTypeString, alias: ActivityID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ActStatus (type: esriFieldTypeString, alias: ActStatus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ActDetails2 (type: esriFieldTypeString, alias: ActDetails2, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• actid (type: esriFieldTypeString, alias: Activity ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• actcategory (type: esriFieldTypeString, alias: Activity Category, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• acttype (type: esriFieldTypeString, alias: Activity Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• details (type: esriFieldTypeString, alias: Activity 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 activity?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• pocname (type: esriFieldTypeString, alias: 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 (in hours), 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 Capability, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid_1784841059005 (type: esriFieldTypeGUID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user_1784841059005 (type: esriFieldTypeString, alias: Submitted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date_1784841059005 (type: esriFieldTypeDate, alias: Submitted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user_1784841059005 (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date_1784841059005 (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• title (type: esriFieldTypeString, alias: Activity Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [EntireOrganization: Entire Organization], [GIS: GIS], [TransportationandEngineering: Transportation and Engineering], ... 9 more ...)
• GlobalID1 (type: esriFieldTypeString, alias: GlobalID1, SQL Type: sqlTypeOther, length: 512, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/28/2026 9:13:46 PM

Schema Last Edit Date: 7/23/2026 5:13:20 PM

Data Last Edit Date: 7/23/2026 5:13:20 PM