Name: All EE Tasks

Display Field: CATEGORY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1e8ab59911a64c4f847ab1fef2796ce6

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, length: 150 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: INCIDENT_NUMBER, length: 100 )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: INCIDENT_TYPE_ID )
• TASK_TYPE_ID ( type: esriFieldTypeInteger, alias: Task Type ID )
• TASK_ID ( type: esriFieldTypeInteger, alias: Task ID )
• TASK_NUMBER ( type: esriFieldTypeString, alias: Task Number, length: 30 )
• CREATION_DATE ( type: esriFieldTypeDate, alias: Creation Date, length: 8 )
• CREATED_BY ( type: esriFieldTypeInteger, alias: Created By )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, length: 8 )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, length: 8 )
• TASK_TYPE ( type: esriFieldTypeString, alias: Task Type, length: 100 , Coded Values: [EE - Inspection: EE - Inspection] , [EE - Followup Inspection: EE - Followup Inspection] , [EE - Mailer: EE - Mailer] , ...2 more... )
• TASK_STATUS ( type: esriFieldTypeString, alias: Task Status, length: 50 , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [OnHold: On Hold] , ...1 more... )
• TASK_PRIORITY ( type: esriFieldTypeString, alias: Task Priority, length: 25 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...1 more... )
• TASK_OWNER ( type: esriFieldTypeString, alias: Task Owner, length: 255 )
• TASK_ASSIGNEE ( type: esriFieldTypeString, alias: Task Assignee, length: 255 )
• TASK_ASSIGNMENT_ID ( type: esriFieldTypeString, alias: TASK_ASSIGNMENT_ID, length: 50 )
• ASSIGNEE_STATUS ( type: esriFieldTypeString, alias: Assignee Status, length: 50 )
• TASK_SUBJECT ( type: esriFieldTypeString, alias: Task Subject, length: 255 )
• TASK_NOTES ( type: esriFieldTypeString, alias: Task Notes, length: 255 )
• PLANNED_START_DATE ( type: esriFieldTypeDate, alias: Planned Start Date, length: 8 )
• PLANNED_END_DATE ( type: esriFieldTypeDate, alias: Planned End Date, length: 8 )
• SCHEDULED_START_DATE ( type: esriFieldTypeDate, alias: Scheduled Start Date, length: 8 )
• SCHEDULED_END_DATE ( type: esriFieldTypeDate, alias: Scheduled End Date, length: 8 )
• ACTUAL_START_DATE ( type: esriFieldTypeDate, alias: Actual Start Date, length: 8 )
• ACTUAL_END_DATE ( type: esriFieldTypeDate, alias: Actual End Date, length: 8 )
• PLANNED_EFFORT ( type: esriFieldTypeDouble, alias: PLANNED_EFFORT )
• PLANNED_EFFORT_UOM ( type: esriFieldTypeString, alias: PLANNED_EFFORT_UOM, length: 10 )
• ACTUAL_EFFORT ( type: esriFieldTypeDouble, alias: ACTUAL_EFFORT )
• ACTUAL_EFFORT_UOM ( type: esriFieldTypeString, alias: ACTUAL_EFFORT_UOM, length: 10 )
• DURATION ( type: esriFieldTypeDouble, alias: Days Old )
• DURATION_UOM ( type: esriFieldTypeString, alias: DURATION_UOM, length: 10 )
• ADDRESS ( type: esriFieldTypeString, alias: Address, length: 255 )
• PARCEL_ID ( type: esriFieldTypeString, alias: Parcel ID, length: 100 )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Send to Oracle: Change to Manual, length: 50 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 50 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata