Name: Heavy Equip Maint Table

Display Field: CATEGORY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: b1ad771fd7ed42b3a64870262052e295

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: false

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 )
• FOLLOWUP_DATE ( type: esriFieldTypeDate, alias: FOLLOWUP_DATE, length: 8 )
• TASK_TYPE ( type: esriFieldTypeString, alias: Task Type, length: 100 )
• TASK_STATUS ( type: esriFieldTypeString, alias: Task Status, length: 50 , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [On Hold: On Hold] , ...1 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 )
• 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 )
• LOADS_HAULED ( type: esriFieldTypeDouble, alias: Loads Hauled )
• TOTAL_FEET ( type: esriFieldTypeDouble, alias: Total Feet )
• TOTAL_HOURS ( type: esriFieldTypeDouble, alias: Total Hours )
• EQUIPMENT ( type: esriFieldTypeString, alias: Equipment, length: 100 )
• START_MILES ( type: esriFieldTypeDouble, alias: Start Miles )
• END_MILES ( type: esriFieldTypeDouble, alias: End Miles )
• TOTAL_MILES ( type: esriFieldTypeDouble, alias: Total Miles )
• ASSET_ID ( type: esriFieldTypeInteger, alias: ASSET_ID )
• ASSET_GUID ( type: esriFieldTypeGUID, alias: ASSET_GUID, length: 38 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• 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 )
• CREW_NUMBER ( type: esriFieldTypeString, alias: Crew Number, length: 50 )

Relationships:

• Maint to Groups (0) -- Related To: Heavy Equipment Street Groups (3)

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

  Iteminfo   Thumbnail   Metadata