Name: Tasks Table

Display Field: ITEM_NAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 54b97d4fad474d5fa1c15def3ef9fc6f

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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: false
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:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, editable: true, nullable: true, length: 150, defaultValue: null, modelName: CATEGORY )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID, editable: true, nullable: true, defaultValue: null, modelName: INCIDENT_ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: INCIDENT_NUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: INCIDENT_NUMBER )
• INCIDENT_TYPE_ID ( type: esriFieldTypeInteger, alias: INCIDENT_TYPE_ID, editable: true, nullable: true, defaultValue: null, modelName: 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, editable: true, nullable: true, defaultValue: null, modelName: DEBRIEF_HEADER_ID )
• DEBRIEF_NUMBER ( type: esriFieldTypeInteger, alias: DEBRIEF_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: DEBRIEF_NUMBER )
• TASK_ID ( type: esriFieldTypeInteger, alias: TASK_ID, editable: true, nullable: true, defaultValue: null, modelName: TASK_ID )
• TASK_ASSIGNMENT_ID ( type: esriFieldTypeString, alias: TASK_ASSIGNMENT_ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TASK_ASSIGNMENT_ID )
• CREATION_DATE ( type: esriFieldTypeDate, alias: CREATION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATION_DATE )
• CREATED_BY ( type: esriFieldTypeInteger, alias: CREATED_BY, editable: true, nullable: true, defaultValue: null, modelName: CREATED_BY )
• LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: LAST_UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATE_DATE )
• LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: LAST_UPDATED_BY, editable: true, nullable: true, defaultValue: null, modelName: LAST_UPDATED_BY )
• LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: LAST_UPDATE_LOGIN, editable: true, nullable: true, defaultValue: null, modelName: LAST_UPDATE_LOGIN )
• LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_MODIFIED_DATE )
• TASK_NUMBER ( type: esriFieldTypeString, alias: TASK_NUMBER, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TASK_NUMBER )
• TASK_TYPE ( type: esriFieldTypeString, alias: TASK_TYPE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: TASK_TYPE , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TASK_STATUS , Coded Values: [Open: Open] , [In Progress: In Progress] , [Close: Close] , ...3 more... )
• TASK_PRIORITY ( type: esriFieldTypeString, alias: TASK_PRIORITY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TASK_PRIORITY , Coded Values: [High: High] , [Medium: Medium] , [Low: Low] )
• TASK_OWNER ( type: esriFieldTypeString, alias: TASK_OWNER, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TASK_OWNER )
• TASK_ASSIGNEE ( type: esriFieldTypeString, alias: TASK_ASSIGNEE, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TASK_ASSIGNEE )
• ASSIGNEE_STATUS ( type: esriFieldTypeString, alias: ASSIGNEE_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSIGNEE_STATUS , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [On Hold: On Hold] , ...1 more... )
• TASK_SUBJECT ( type: esriFieldTypeString, alias: TASK_SUBJECT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TASK_SUBJECT )
• TASK_NOTES ( type: esriFieldTypeString, alias: TASK_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TASK_NOTES )
• PLANNED_START_DATE ( type: esriFieldTypeDate, alias: PLANNED_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANNED_START_DATE )
• PLANNED_END_DATE ( type: esriFieldTypeDate, alias: PLANNED_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLANNED_END_DATE )
• SCHEDULED_START_DATE ( type: esriFieldTypeDate, alias: SCHEDULED_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SCHEDULED_START_DATE )
• SCHEDULED_END_DATE ( type: esriFieldTypeDate, alias: SCHEDULED_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SCHEDULED_END_DATE )
• ACTUAL_START_DATE ( type: esriFieldTypeDate, alias: ACTUAL_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUAL_START_DATE )
• ACTUAL_END_DATE ( type: esriFieldTypeDate, alias: ACTUAL_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTUAL_END_DATE )
• PLANNED_EFFORT ( type: esriFieldTypeDouble, alias: PLANNED_EFFORT, editable: true, nullable: true, defaultValue: null, modelName: PLANNED_EFFORT )
• PLANNED_EFFORT_UOM ( type: esriFieldTypeString, alias: PLANNED_EFFORT_UOM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PLANNED_EFFORT_UOM )
• ACTUAL_EFFORT ( type: esriFieldTypeDouble, alias: ACTUAL_EFFORT, editable: true, nullable: true, defaultValue: null, modelName: ACTUAL_EFFORT )
• ACTUAL_EFFORT_UOM ( type: esriFieldTypeString, alias: ACTUAL_EFFORT_UOM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ACTUAL_EFFORT_UOM )
• DURATION ( type: esriFieldTypeDouble, alias: DURATION, editable: true, nullable: true, defaultValue: null, modelName: DURATION )
• DEBRIEF_CREATION_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_CREATION_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEBRIEF_CREATION_DATE )
• DEBRIEF_CREATED_BY ( type: esriFieldTypeInteger, alias: DEBRIEF_CREATED_BY, editable: true, nullable: true, defaultValue: null, modelName: DEBRIEF_CREATED_BY )
• DEBRIEF_LAST_UPDATE_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_LAST_UPDATE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEBRIEF_LAST_UPDATE_DATE )
• DEBRIEF_LAST_UPDATED_BY ( type: esriFieldTypeInteger, alias: DEBRIEF_LAST_UPDATED_BY, editable: true, nullable: true, defaultValue: null, modelName: DEBRIEF_LAST_UPDATED_BY )
• DEBRIEF_LAST_UPDATE_LOGIN ( type: esriFieldTypeInteger, alias: DEBRIEF_LAST_UPDATE_LOGIN, editable: true, nullable: true, defaultValue: null, modelName: DEBRIEF_LAST_UPDATE_LOGIN )
• DEBRIEF_LAST_MODIFIED_DATE ( type: esriFieldTypeDate, alias: DEBRIEF_LAST_MODIFIED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEBRIEF_LAST_MODIFIED_DATE )
• OTHERS ( type: esriFieldTypeString, alias: OTHERS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHERS )
• DURATION_UOM ( type: esriFieldTypeString, alias: DURATION_UOM, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DURATION_UOM )
• INSTANCE_ID ( type: esriFieldTypeInteger, alias: INSTANCE_ID, editable: true, nullable: true, defaultValue: null, modelName: INSTANCE_ID )
• INSTANCE_NUMBER ( type: esriFieldTypeInteger, alias: INSTANCE_NUMBER, editable: true, nullable: true, defaultValue: null, modelName: INSTANCE_NUMBER )
• INVENTORY_ITEM_ID ( type: esriFieldTypeInteger, alias: INVENTORY_ITEM_ID, editable: true, nullable: true, defaultValue: null, modelName: 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, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ITEM_NAME , Coded Values: [Ameri-Kart: Ameri-Kart] , [BOSS: BOSS] , [CASCADE: CASCADE] , ...9 more... )
• ITEM_SERIAL_NUMBER ( type: esriFieldTypeString, alias: ITEM_SERIAL_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ITEM_SERIAL_NUMBER )
• NEW_CART ( type: esriFieldTypeString, alias: NEW_CART, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NEW_CART , Coded Values: [Yes: Yes] , [No: No] )
• CART_PICKUP ( type: esriFieldTypeString, alias: CART_PICKUP, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CART_PICKUP , Coded Values: [Yes: Yes] , [No: No] )
• CART_REPLACE ( type: esriFieldTypeString, alias: CART_REPLACE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CART_REPLACE , Coded Values: [Yes: Yes] , [No: No] )
• ACTIVE_START_DATE ( type: esriFieldTypeDate, alias: ACTIVE_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTIVE_START_DATE )
• SERVICE_DATE ( type: esriFieldTypeDate, alias: SERVICE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SERVICE_DATE )
• INSTANCE_USUAGE_CODE ( type: esriFieldTypeString, alias: INSTANCE_USUAGE_CODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: INSTANCE_USUAGE_CODE )
• BURNT_CART ( type: esriFieldTypeString, alias: BURNT_CART, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BURNT_CART , Coded Values: [Yes: Yes] , [No: No] )
• OWNER_DAMAGE ( type: esriFieldTypeString, alias: OWNER_DAMAGE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: OWNER_DAMAGE , Coded Values: [Yes: Yes] , [No: No] )
• NO_DAMAGE ( type: esriFieldTypeString, alias: NO_DAMAGE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NO_DAMAGE , Coded Values: [Yes: Yes] , [No: No] )
• AXLE ( type: esriFieldTypeSmallInteger, alias: AXLE, editable: true, nullable: true, defaultValue: null, modelName: AXLE )
• BOTTOM_PLATES ( type: esriFieldTypeSmallInteger, alias: BOTTOM_PLATES, editable: true, nullable: true, defaultValue: null, modelName: BOTTOM_PLATES )
• CATCH_BAR ( type: esriFieldTypeSmallInteger, alias: CATCH_BAR, editable: true, nullable: true, defaultValue: null, modelName: CATCH_BAR )
• FRONT_FRAMES ( type: esriFieldTypeSmallInteger, alias: FRONT_FRAMES, editable: true, nullable: true, defaultValue: null, modelName: FRONT_FRAMES )
• HANDLE ( type: esriFieldTypeSmallInteger, alias: HANDLE, editable: true, nullable: true, defaultValue: null, modelName: HANDLE )
• HINGE ( type: esriFieldTypeSmallInteger, alias: HINGE, editable: true, nullable: true, defaultValue: null, modelName: HINGE )
• LID ( type: esriFieldTypeSmallInteger, alias: LID, editable: true, nullable: true, defaultValue: null, modelName: LID )
• LID_PIN ( type: esriFieldTypeSmallInteger, alias: LID_PIN, editable: true, nullable: true, defaultValue: null, modelName: LID_PIN )
• SPACER ( type: esriFieldTypeSmallInteger, alias: SPACER, editable: true, nullable: true, defaultValue: null, modelName: SPACER )
• WEAR_PADS ( type: esriFieldTypeSmallInteger, alias: WEAR_PADS, editable: true, nullable: true, defaultValue: null, modelName: WEAR_PADS )
• WHEEL ( type: esriFieldTypeSmallInteger, alias: WHEEL, editable: true, nullable: true, defaultValue: null, modelName: WHEEL )
• WHEEL_CAP ( type: esriFieldTypeSmallInteger, alias: WHEEL_CAP, editable: true, nullable: true, defaultValue: null, modelName: WHEEL_CAP )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ADDRESS )
• INCIDENT_AREA ( type: esriFieldTypeString, alias: AREA, editable: true, nullable: true, length: 25, defaultValue: null, modelName: AREA , Coded Values: [A: A] , [B: B] , [C: C] , ...9 more... )
• ZONE ( type: esriFieldTypeString, alias: ZONE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ZONE , Coded Values: [A1: A1] , [A2: A2] , [A3: A3] , ...15 more... )
• ROUTE ( type: esriFieldTypeString, alias: ROUTE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ROUTE )
• COLLECTION_DAY ( type: esriFieldTypeString, alias: COLLECTION_DAY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: COLLECTION_DAY , Coded Values: [1: Monday] , [2: Tuesday] , [3: Wednesday] , ...2 more... )
• PREM_CODE ( type: esriFieldTypeInteger, alias: PREM_CODE, editable: true, nullable: true, defaultValue: null, modelName: PREM_CODE )
• MAP_PAGE ( type: esriFieldTypeString, alias: MAP_PAGE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MAP_PAGE )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: REC_EDIT_MODE, editable: true, nullable: true, length: 255, defaultValue: MANUAL, modelName: REC_EDIT_MODE , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...1 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REC_EDIT_MODE_COMMENTS )
• TASK_NAME ( type: esriFieldTypeString, alias: TASK_NAME, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TASK_NAME )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Tasks Table
  Description:
  Prototype:
  REC_EDIT_MODE_COMMENTS: null
  TASK_NAME: null
  CATEGORY: null
  INCIDENT_ID: null
  INCIDENT_NUMBER: null
  INCIDENT_TYPE_ID: null
  DEBRIEF_HEADER_ID: null
  DEBRIEF_NUMBER: null
  TASK_ID: null
  TASK_ASSIGNMENT_ID: null
  CREATION_DATE: null
  CREATED_BY: null
  LAST_UPDATE_DATE: null
  LAST_UPDATED_BY: null
  LAST_UPDATE_LOGIN: null
  LAST_MODIFIED_DATE: null
  TASK_NUMBER: null
  TASK_TYPE: null
  TASK_STATUS: null
  TASK_PRIORITY: null
  TASK_OWNER: null
  TASK_ASSIGNEE: null
  ASSIGNEE_STATUS: null
  TASK_SUBJECT: null
  TASK_NOTES: null
  PLANNED_START_DATE: null
  PLANNED_END_DATE: null
  SCHEDULED_START_DATE: null
  SCHEDULED_END_DATE: null
  ACTUAL_START_DATE: null
  ACTUAL_END_DATE: null
  PLANNED_EFFORT: null
  PLANNED_EFFORT_UOM: null
  ACTUAL_EFFORT: null
  ACTUAL_EFFORT_UOM: null
  DURATION: null
  DEBRIEF_CREATION_DATE: null
  DEBRIEF_CREATED_BY: null
  DEBRIEF_LAST_UPDATE_DATE: null
  DEBRIEF_LAST_UPDATED_BY: null
  DEBRIEF_LAST_UPDATE_LOGIN: null
  DEBRIEF_LAST_MODIFIED_DATE: null
  OTHERS: null
  DURATION_UOM: null
  INSTANCE_ID: null
  INSTANCE_NUMBER: null
  INVENTORY_ITEM_ID: null
  ITEM_NAME: null
  ITEM_SERIAL_NUMBER: null
  NEW_CART: null
  CART_PICKUP: null
  CART_REPLACE: null
  ACTIVE_START_DATE: null
  SERVICE_DATE: null
  INSTANCE_USUAGE_CODE: null
  BURNT_CART: null
  OWNER_DAMAGE: null
  NO_DAMAGE: null
  AXLE: null
  BOTTOM_PLATES: null
  CATCH_BAR: null
  FRONT_FRAMES: null
  HANDLE: null
  HINGE: null
  LID: null
  LID_PIN: null
  SPACER: null
  WEAR_PADS: null
  WHEEL: null
  WHEEL_CAP: null
  ADDRESS: null
  INCIDENT_AREA: null
  ZONE: null
  ROUTE: null
  COLLECTION_DAY: null
  PREM_CODE: null
  MAP_PAGE: null
  REC_EDIT_MODE: MANUAL
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• SWM_Tasks_SR (0) -- Related To: All Service Requests (0)
• SWM_Tasks_SR (1) -- Related To: Open Cart Central (1)
• SWM_Tasks_SR (2) -- Related To: Open Fee Inspector Service Requests (2)
• SWM_Tasks_SR (3) -- Related To: Open Cart Maint Service Requests (3)
• SWM_Tasks_SR (4) -- Related To: Open Recycle Crews Service Requests (4)
• SWM_Tasks_SR (5) -- Related To: Open Illegal Dumping Service Requests (5)
• SWM_Tasks_SR (6) -- Related To: Over Carts SLA (6)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata