Name: SR_and_WO
Display Field: Project_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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: null
Fields:
-
Reqest_ID
(
type: esriFieldTypeDouble, alias: Reqest_ID
)
-
OBJECTID
(
type: esriFieldTypeInteger, alias: OBJECTID
)
-
Workorder_ID
(
type: esriFieldTypeString, alias: Workorder_ID, length: 60
)
-
SR_Initiated
(
type: esriFieldTypeDate, alias: SR_Initiated, length: 8
)
-
SR_Closed
(
type: esriFieldTypeDate, alias: SR_Closed, length: 8
)
-
WO_Initiated
(
type: esriFieldTypeDate, alias: WO_Initiated, length: 8
)
-
WO_Closed
(
type: esriFieldTypeDate, alias: WO_Closed, length: 8
)
-
WO_Description
(
type: esriFieldTypeString, alias: WO_Description, length: 60
)
-
Problem_Code
(
type: esriFieldTypeString, alias: Problem_Code, length: 20
)
-
SR_Description
(
type: esriFieldTypeString, alias: SR_Description, length: 50
)
-
SR_Details
(
type: esriFieldTypeString, alias: SR_Details, length: 500
)
-
Problem_Address
(
type: esriFieldTypeString, alias: Problem_Address, length: 100
)
-
PROBADDTYPE
(
type: esriFieldTypeString, alias: PROBADDTYPE, length: 30
)
-
Initiated_By
(
type: esriFieldTypeString, alias: Initiated_By, length: 50
)
-
Submit_To
(
type: esriFieldTypeString, alias: Submit_To, length: 50
)
-
Submit_To_Phone
(
type: esriFieldTypeString, alias: Submit_To_Phone, length: 24
)
-
Submit_To_Email
(
type: esriFieldTypeString, alias: Submit_To_Email, length: 256
)
-
Closed_By
(
type: esriFieldTypeString, alias: Closed_By, length: 50
)
-
WO_ID_from_SR
(
type: esriFieldTypeString, alias: WO_ID_from_SR, length: 60
)
-
Project_Name
(
type: esriFieldTypeString, alias: Project_Name, length: 130
)
-
SRX
(
type: esriFieldTypeDouble, alias: SRX
)
-
SRY
(
type: esriFieldTypeDouble, alias: SRY
)
-
Date_Submit_To
(
type: esriFieldTypeDate, alias: Date_Submit_To, length: 8
)
-
Submit_To_Opened
(
type: esriFieldTypeString, alias: Submit_To_Opened, length: 50
)
-
DATESUBMITTOOPEN
(
type: esriFieldTypeDate, alias: DATESUBMITTOOPEN, length: 8
)
-
Dispatch_To
(
type: esriFieldTypeString, alias: Dispatch_To, length: 50
)
-
Status
(
type: esriFieldTypeString, alias: Status, length: 50
)
-
Request_Category
(
type: esriFieldTypeString, alias: Request_Category, length: 50
)
-
Problem_SID
(
type: esriFieldTypeDouble, alias: Problem_SID
)
-
REQCUSTFIELDCATID
(
type: esriFieldTypeDouble, alias: REQCUSTFIELDCATID
)
-
Project_Complete_Date
(
type: esriFieldTypeDate, alias: Project_Complete_Date, length: 8
)
-
Projects_ID
(
type: esriFieldTypeDouble, alias: Projects_ID
)
-
INITIATEDBYAPP
(
type: esriFieldTypeString, alias: INITIATEDBYAPP, length: 50
)
-
Street_Name
(
type: esriFieldTypeString, alias: Street_Name, length: 50
)
-
Problem_Location
(
type: esriFieldTypeString, alias: Problem_Location, length: 256
)
-
Text_9
(
type: esriFieldTypeString, alias: Text_9, length: 100
)
-
INITIATEDBYSID
(
type: esriFieldTypeInteger, alias: INITIATEDBYSID
)
-
SUBMITTOSID
(
type: esriFieldTypeInteger, alias: SUBMITTOSID
)
-
SUBMITTOOPENBYSID
(
type: esriFieldTypeInteger, alias: SUBMITTOOPENBYSID
)
-
CANCELLEDBYSID
(
type: esriFieldTypeInteger, alias: CANCELLEDBYSID
)
-
CLOSEDBYSID
(
type: esriFieldTypeInteger, alias: CLOSEDBYSID
)
-
DISPATCHTOSID
(
type: esriFieldTypeInteger, alias: DISPATCHTOSID
)
-
DISPATCHOPENBYSID
(
type: esriFieldTypeInteger, alias: DISPATCHOPENBYSID
)
-
ESRI_OID
(
type: esriFieldTypeOID, alias: ESRI_OID
)
Supported Operations:
Query
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata