Name: ECOMP_ATTACHED_WORKORDERS
Display Field: WORKORDERID
Type: Table
Description:
Copyright Text:
Max Record Count: 10000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- WORKORDERID (type: esriFieldTypeString, alias: WORKORDERID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- COMPANY_NAME (type: esriFieldTypeString, alias: COMPANY_NAME, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- SERVICE_ADDRESS (type: esriFieldTypeString, alias: SERVICE_ADDRESS, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
- DESCRIPTION (type: esriFieldTypeString, alias: DESCRIPTION, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
- INITIATEDBY (type: esriFieldTypeString, alias: INITIATEDBY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- INITIATEDATE (type: esriFieldTypeDate, alias: INITIATEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- SUBMITTO (type: esriFieldTypeString, alias: SUBMITTO, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
- EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
Templates:
Name: ECOMP_ATTACHED_WORKORDERS
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/11/2026 6:13:42 PM
Schema Last Edit Date: 3/11/2026 6:13:42 PM
Data Last Edit Date: 3/11/2026 6:13:42 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat