Name: FACILITY_MAINTENANCE_TRADES
Display Field: NAME
Type: Table
Geometry Type: N/A
Description: null
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
ID
(
type: esriFieldTypeOID, alias: ID
)
-
WORK_ORDER_ID
(
type: esriFieldTypeString, alias: WORK_ORDER_ID, length: 30
)
-
WORK_ORDER_DESCRIPTION
(
type: esriFieldTypeString, alias: WORK_ORDER_DESCRIPTION, length: 80
)
-
WORK_ORDER_TYPE
(
type: esriFieldTypeString, alias: WORK_ORDER_TYPE, length: 255
)
-
DEPARTMENT
(
type: esriFieldTypeString, alias: DEPARTMENT, length: 15
)
-
DEPARTMENT_NAME
(
type: esriFieldTypeString, alias: DEPARTMENT_NAME, length: 80
)
-
SYSTEM
(
type: esriFieldTypeString, alias: SYSTEM, length: 255
)
-
PROBLEM_CODE
(
type: esriFieldTypeString, alias: PROBLEM_CODE, length: 8
)
-
PROBLEM_CODE_DESC
(
type: esriFieldTypeString, alias: PROBLEM_CODE_DESC, length: 255
)
-
Work_Order_Priority
(
type: esriFieldTypeString, alias: Work_Order_Priority, length: 255
)
-
DATE_WORKED
(
type: esriFieldTypeDate, alias: DATE_WORKED, length: 8
)
-
LABOR_DIVISION
(
type: esriFieldTypeString, alias: LABOR_DIVISION, length: 15
)
-
LABOR_EMPLOYEE
(
type: esriFieldTypeString, alias: LABOR_EMPLOYEE, length: 15
)
-
NAME
(
type: esriFieldTypeString, alias: NAME, length: 80
)
-
HOURS_WORKED
(
type: esriFieldTypeDouble, alias: HOURS_WORKED
)
-
LABOR_COST
(
type: esriFieldTypeDouble, alias: LABOR_COST
)
-
PM
(
type: esriFieldTypeString, alias: PM, length: 20
)
-
PM_DESCRIPTION
(
type: esriFieldTypeString, alias: PM_DESCRIPTION, length: 255
)
-
TASK
(
type: esriFieldTypeString, alias: TASK, length: 20
)
-
RAW_TRADE
(
type: esriFieldTypeString, alias: RAW_TRADE, length: 15
)
-
LABOR_TRADE_OR_TASK
(
type: esriFieldTypeString, alias: LABOR_TRADE_OR_TASK, length: 20
)
-
LABOR_TRADE_DESC
(
type: esriFieldTypeString, alias: LABOR_TRADE_DESC, length: 255
)
-
PARENT_SYSTEM
(
type: esriFieldTypeString, alias: PARENT_SYSTEM, length: 30
)
-
SYSTEM_PARENT_NAME
(
type: esriFieldTypeString, alias: SYSTEM_PARENT_NAME, length: 255
)
-
EQUIPMENT_CLASS
(
type: esriFieldTypeString, alias: EQUIPMENT_CLASS, length: 255
)
-
X_LOCATION
(
type: esriFieldTypeDouble, alias: X_LOCATION
)
-
Y_LOCATION
(
type: esriFieldTypeDouble, alias: Y_LOCATION
)
-
TotalDays
(
type: esriFieldTypeInteger, alias: TotalDays
)
-
TotalHours
(
type: esriFieldTypeInteger, alias: TotalHours
)
-
Weekdays
(
type: esriFieldTypeInteger, alias: Weekdays
)
-
WorkDays
(
type: esriFieldTypeInteger, alias: WorkDays
)
-
WeekdayHours
(
type: esriFieldTypeInteger, alias: WeekdayHours
)
-
WeekdayHoursminusHolidays
(
type: esriFieldTypeInteger, alias: WeekdayHoursminusHolidays
)
-
CREATED_DATE
(
type: esriFieldTypeDate, alias: CREATED_DATE, length: 8
)
-
REPORTED_DATE
(
type: esriFieldTypeDate, alias: REPORTED_DATE, length: 8
)
-
PM_DUE_DATE
(
type: esriFieldTypeDate, alias: PM_DUE_DATE, length: 8
)
-
REQUEST_COMPLETED
(
type: esriFieldTypeDate, alias: REQUEST_COMPLETED, length: 8
)
Supported Operations:
Query
Query Attachments
Query Analytic
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata