Name: Works_Register
Display Field: Project
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
Description:
Copyright Text:
Max Record Count: 1000
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Project (type: esriFieldTypeString, alias: Project, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- WorksRequired (type: esriFieldTypeString, alias: Maintenance, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [Cut - ride on mower: Cut - ride on mower], [Cut - whipper snipper: Cut - whipper snipper], [Remove fallen tree: Remove fallen tree], ... 7 more ...)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- DateCompleted (type: esriFieldTypeDate, alias: DateCompleted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- CompletedBy (type: esriFieldTypeString, alias: Who completed the maintenance?, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- TimeSpent (type: esriFieldTypeSingle, alias: How many person-hours did the job take?, SQL Type: sqlTypeOther, nullable: true, editable: true)
- GlobalIDFromAsset (type: esriFieldTypeGUID, alias: GlobalIDFromAsset, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- DatePlanned (type: esriFieldTypeDate, alias: DatePlanned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, 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: 50, nullable: true, editable: false)
- AssetID (type: esriFieldTypeInteger, alias: AssetID, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Works_Register
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 10/20/2025 7:27:51 AM
Schema Last Edit Date: 5/21/2026 6:40:01 AM
Data Last Edit Date: 5/21/2026 6:40:01 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat