Name: AsssetMaintenance

Display Field: Inspector

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

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

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• FeatureID (type: esriFieldTypeGUID, alias: Feature ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• MaintenanceRecordType (type: esriFieldTypeSmallInteger, alias: Maintenance Record Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AssetCondition (type: esriFieldTypeString, alias: Asset Condition, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Excellent: Excellent], [Good: Good], [Fair: Fair], ... 2 more ...)
• WorkOrderedDate (type: esriFieldTypeDate, alias: Work Order Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WorkOrderedBy (type: esriFieldTypeString, alias: Work Ordered By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WorkOrderStatus (type: esriFieldTypeString, alias: Work Order Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Unassigned: Unassigned], [Assigned: Assigned], [In Progress: In Progress], ... 3 more ...)
• WorkAssignedTo (type: esriFieldTypeString, alias: Work Assigned To, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• WorkEquipmentRequired (type: esriFieldTypeString, alias: Work Equipment Required, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• WorkOrderDescription (type: esriFieldTypeString, alias: Work Order Description, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• AssetMaintenanceType (type: esriFieldTypeString, alias: Asset Maintenance Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Clean: Clean], [Modify: Modify], [Refinish: Refinish], ... 4 more ...)
• MaintenancePriority (type: esriFieldTypeString, alias: Maintenance Priority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [None: None], [Low: Low], [Medium: Medium], ... 2 more ...)
• MaintainanceDueDate (type: esriFieldTypeDate, alias: Maintenance Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintainanceDate (type: esriFieldTypeDate, alias: Maintenance Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• MaintainedBy (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MaintenanceCrewDescription (type: esriFieldTypeString, alias: Maintenance Crew Description, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• MaintenanceDescription (type: esriFieldTypeString, alias: Maintenance Description, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 1024, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Types:

ID: 1
Name: Inspection
Domains:

• Field Name: AssetCondition
  Inherited
  
• Field Name: WorkOrderStatus
  Inherited
  
• Field Name: AssetMaintenanceType
  Inherited
  
Templates:

Name: Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceRecordType: 1

---

ID: 2
Name: Work Order
Domains:

• Field Name: AssetCondition
  Inherited
  
• Field Name: WorkOrderStatus
  Inherited
  
• Field Name: AssetMaintenanceType
  Inherited
  
Templates:

Name: Work Order
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceRecordType: 2

---

ID: 3
Name: Maintenance History
Domains:

• Field Name: AssetCondition
  Inherited
  
• Field Name: WorkOrderStatus
  Inherited
  
• Field Name: AssetMaintenanceType
  Inherited
  
Templates:

Name: Maintenance History
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• MaintenanceRecordType: 3

---

Relationships:

• Landscape Structure (4) -- Related To: Landscape Structure (1)
• Structure (2) -- Related To: Structure (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/18/2022 1:20:13 PM

Schema Last Edit Date: 2/18/2022 1:20:13 PM

Data Last Edit Date: 2/18/2022 1:20:13 PM

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