Name: WorkOrder_Pipe

Display Field: IssuedBy

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• AssetGUID (type: esriFieldTypeGUID, alias: AssetGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Date (type: esriFieldTypeDate, alias: Date Submitted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• IDDE_Detected (type: esriFieldTypeInteger, alias: IDDE_Detected, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Yes], [2: No])
• IssuedBy (type: esriFieldTypeString, alias: IssuedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Maintenance_Work (type: esriFieldTypeInteger, alias: Maintenance_Work, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cleaned Asset], [2: Replaced Broken Part], [3: Repaired Broken Part], ... 11 more ...)
• Maintenance_Work_2 (type: esriFieldTypeInteger, alias: Maintenance_Work_2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cleaned Asset], [2: Replaced Broken Part], [3: Repaired Broken Part], ... 11 more ...)
• Maintenance_Work_3 (type: esriFieldTypeInteger, alias: Maintenance_Work_3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cleaned Asset], [2: Replaced Broken Part], [3: Repaired Broken Part], ... 11 more ...)
• Maintenance_Work_4 (type: esriFieldTypeInteger, alias: Maintenance_Work_4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Cleaned Asset], [2: Replaced Broken Part], [3: Repaired Broken Part], ... 11 more ...)
• Start_Date (type: esriFieldTypeDate, alias: Start_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• End_Date (type: esriFieldTypeDate, alias: End_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CompletedBy (type: esriFieldTypeString, alias: CompletedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• HoursToComplete (type: esriFieldTypeInteger, alias: HoursToComplete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NumberStaff (type: esriFieldTypeInteger, alias: Number Of Staff, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• TruckID (type: esriFieldTypeString, alias: Truck Unique ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NumberOfTrucks (type: esriFieldTypeInteger, alias: Number Of Trucks Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EquipmentUsed11 (type: esriFieldTypeString, alias: EquipmentUsed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cam: Camera], [Tool: Tools], [GNSS: GNSS Receiver], ... 12 more ...)
• EquipmentUsed12 (type: esriFieldTypeString, alias: EquipmentUsed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cam: Camera], [Tool: Tools], [GNSS: GNSS Receiver], ... 12 more ...)
• EquipmentUsed13 (type: esriFieldTypeString, alias: EquipmentUsed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cam: Camera], [Tool: Tools], [GNSS: GNSS Receiver], ... 12 more ...)
• EquipmentUsed14 (type: esriFieldTypeString, alias: EquipmentUsed, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Cam: Camera], [Tool: Tools], [GNSS: GNSS Receiver], ... 12 more ...)
• WorkNeeded (type: esriFieldTypeString, alias: WorkNeeded, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: WorkOrder_Pipe
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (23) -- Related To: Pipe (10)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/6/2026 6:55:37 PM

Schema Last Edit Date: 8/6/2026 6:55:37 PM

Data Last Edit Date: 8/6/2026 6:55:37 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat