Name: Tasks Table

Display Field: ITEM_NAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: ba5fcfa6ece0439bbabeefb170ab9712

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 , Coded Values: [10448: SWM-Code Violation] , [10442: SWM-New Start Garbage Request] , [10431: SWM-Missed Bulk Trash] , ...37 more... )
• DEBRIEF_HEADER_ID ( type: esriFieldTypeInteger, alias: DEBRIEF_HEADER_ID )
• DEBRIEF_NUMBER ( type: esriFieldTypeInteger, alias: DEBRIEF_NUMBER )
• TASK_ID ( type: esriFieldTypeInteger, alias: TASK_ID )
• TASK_ASSIGNMENT_ID ( type: esriFieldTypeString, alias: TASK_ASSIGNMENT_ID, length: 50 )
• 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_NUMBER ( type: esriFieldTypeString, alias: TASK_NUMBER, length: 100 )
• TASK_TYPE ( type: esriFieldTypeString, alias: TASK_TYPE, length: 100 , Coded Values: [SWM-Alley Cutting: Alley Cutting] , [SWM-Bin on Wheels: Bin on Wheels] , [SWM-Burn Cart Issues: Burn Cart Issues] , ...54 more... )
• TASK_STATUS ( type: esriFieldTypeString, alias: TASK_STATUS, length: 50 , Coded Values: [Open: Open] , [In Progress: In Progress] , [Close: Close] , ...3 more... )
• TASK_PRIORITY ( type: esriFieldTypeString, alias: TASK_PRIORITY, length: 25 , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• TASK_OWNER ( type: esriFieldTypeString, alias: TASK_OWNER, length: 255 )
• TASK_ASSIGNEE ( type: esriFieldTypeString, alias: TASK_ASSIGNEE, length: 255 )
• ASSIGNEE_STATUS ( type: esriFieldTypeString, alias: ASSIGNEE_STATUS, length: 50 , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [On Hold: On Hold] , ...1 more... )
• 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: DURATION )
• DEBRIEF_CREATION_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_CREATION_DATE, length: 8 )
• DEBRIEF_CREATED_BY ( type: esriFieldTypeInteger, alias: DEBRIEF_CREATED_BY )
• DEBRIEF_LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_LAST_UPDATE_DATE, length: 8 )
• DEBRIEF_LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: DEBRIEF_LAST_UPDATED_BY )
• DEBRIEF_LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: DEBRIEF_LAST_UPDATE_LOGIN )
• DEBRIEF_LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_LAST_MODIFIED_DATE, length: 8 )
• OTHERS ( type: esriFieldTypeString, alias: OTHERS, length: 255 )
• DURATION_UOM ( type: esriFieldTypeString, alias: DURATION_UOM, length: 10 )
• INSTANCE_ID ( type: esriFieldTypeInteger, alias: INSTANCE_ID )
• INSTANCE_NUMBER ( type: esriFieldTypeInteger, alias: INSTANCE_NUMBER )
• INVENTORY_ITEM_ID ( type: esriFieldTypeInteger, alias: INVENTORY_ITEM_ID , Coded Values: [1: VK - Ameri-Kart (VERSA)] , [3: BK - BOSS, AMERI_KART] , [5: CS/ RC - CASCADE and RECYCLE CASCADE] , ...9 more... )
• ITEM_NAME ( type: esriFieldTypeString, alias: ITEM_NAME, length: 255 , Coded Values: [Ameri-Kart: Ameri-Kart] , [BOSS: BOSS] , [CASCADE: CASCADE] , ...9 more... )
• ITEM_SERIAL_NUMBER ( type: esriFieldTypeString, alias: ITEM_SERIAL_NUMBER, length: 50 )
• NEW_CART ( type: esriFieldTypeString, alias: NEW_CART, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CART_PICKUP ( type: esriFieldTypeString, alias: CART_PICKUP, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• CART_REPLACE ( type: esriFieldTypeString, alias: CART_REPLACE, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ACTIVE_START_DATE ( type: esriFieldTypeDate, alias: ACTIVE_START_DATE, length: 8 )
• SERVICE_DATE ( type: esriFieldTypeDate, alias: SERVICE_DATE, length: 8 )
• INSTANCE_USUAGE_CODE ( type: esriFieldTypeString, alias: INSTANCE_USUAGE_CODE, length: 50 )
• BURNT_CART ( type: esriFieldTypeString, alias: BURNT_CART, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• OWNER_DAMAGE ( type: esriFieldTypeString, alias: OWNER_DAMAGE, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• NO_DAMAGE ( type: esriFieldTypeString, alias: NO_DAMAGE, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• AXLE ( type: esriFieldTypeSmallInteger, alias: AXLE )
• BOTTOM_PLATES ( type: esriFieldTypeSmallInteger, alias: BOTTOM_PLATES )
• CATCH_BAR ( type: esriFieldTypeSmallInteger, alias: CATCH_BAR )
• FRONT_FRAMES ( type: esriFieldTypeSmallInteger, alias: FRONT_FRAMES )
• HANDLE ( type: esriFieldTypeSmallInteger, alias: HANDLE )
• HINGE ( type: esriFieldTypeSmallInteger, alias: HINGE )
• LID ( type: esriFieldTypeSmallInteger, alias: LID )
• LID_PIN ( type: esriFieldTypeSmallInteger, alias: LID_PIN )
• SPACER ( type: esriFieldTypeSmallInteger, alias: SPACER )
• WEAR_PADS ( type: esriFieldTypeSmallInteger, alias: WEAR_PADS )
• WHEEL ( type: esriFieldTypeSmallInteger, alias: WHEEL )
• WHEEL_CAP ( type: esriFieldTypeSmallInteger, alias: WHEEL_CAP )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 255 )
• INCIDENT_AREA ( type: esriFieldTypeString, alias: AREA, length: 25 , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
• ZONE ( type: esriFieldTypeString, alias: ZONE, length: 25 , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
• ROUTE ( type: esriFieldTypeString, alias: ROUTE, length: 25 )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: COLLECTION_DAY, length: 25 , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
• PREM_CODE ( type: esriFieldTypeInteger, alias: PREM_CODE )
• MAP_PAGE ( type: esriFieldTypeString, alias: MAP_PAGE, length: 25 )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: REC_EDIT_MODE, length: 255 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 255 )
• TASK_NAME ( type: esriFieldTypeString, alias: TASK_NAME, 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