Name: Plant Maintenance
Display Field: MaintenanceDate
Type: Table
Description: The Plant Maintenance table is used to track work orders, which once completed can be coverted into a maintenance history record. It is related to the Plant Center point feature class so that each plant may have many work orders or maintenance history records associated with it.
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: GlobalID
Type ID Field: MaintenanceRecordType
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FeatureID (type: esriFieldTypeInteger, alias: FeatureID, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MaintenanceRecordType (type: esriFieldTypeSmallInteger, alias: Maintenance Record Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
- MaintenanceType (type: esriFieldTypeString, alias: Maintenance Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [UNKNOWN: UNKNOWN], [Prune: Prune], [Fertilize: Fertilize], ... 4 more ...)
- MaintenancePriority (type: esriFieldTypeString, alias: Maintenance Priority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- MaintenanceDate (type: esriFieldTypeDate, alias: Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- MaintenanceUserName (type: esriFieldTypeString, alias: Maintenance User Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- MaintenanceDescription (type: esriFieldTypeString, alias: Maintenance Description, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
- Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
- PlantCenterID (type: esriFieldTypeString, alias: Plant Center ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- Guid (type: esriFieldTypeGUID, alias: Guid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Types:
ID: 1
Name: Work Order
Domains:
- Field Name: MaintenancePriority
Coded Values:[Very High: Very High], [High: High], [Moderate: Moderate], More
- Field Name: MaintenanceType
Inherited
Templates:
Name: Work Order
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
ID: 2
Name: Maintenance History
Domains:
- Field Name: MaintenancePriority
Coded Values:[Very High: Very High], [High: High], [Moderate: Moderate], More
- Field Name: MaintenanceType
Inherited
Templates:
Name: Maintenance History
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 11/7/2022 7:38:52 PM
Schema Last Edit Date: 11/7/2022 7:38:52 PM
Data Last Edit Date: 11/7/2022 7:38:52 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat