ArcGIS REST Services Directory
Login
Home
>
services
>
OpenData_IT_Tickets (MapServer)
>
All Layers and Tables
API Reference
JSON
All Layers and Tables (OpenData_IT_Tickets)
Tables:
Table:
IT_HelpDesk_CurrentStaff
(3)
Name:
IT_HelpDesk_CurrentStaff
Display Field:
FIRST_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
bd0a965c45c143198f9c11d09d69cee1
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
CLIENT_ID
( type: esriFieldTypeInteger, alias: CLIENT_ID )
DELETED
( type: esriFieldTypeInteger, alias: DELETED )
EMAIL
( type: esriFieldTypeString, alias: EMAIL, length: 86 )
EMPLOYMENT_STATUS
( type: esriFieldTypeString, alias: EMPLOYMENT_STATUS, length: 50 )
FIRST_NAME
( type: esriFieldTypeString, alias: FIRST_NAME, length: 61 )
INACTIVE
( type: esriFieldTypeDouble, alias: INACTIVE )
LAST_NAME
( type: esriFieldTypeString, alias: LAST_NAME, length: 59 )
LOCKED
( type: esriFieldTypeInteger, alias: LOCKED )
USER_NAME
( type: esriFieldTypeString, alias: USER_NAME, length: 65 )
GroupsAssigned
( type: esriFieldTypeString, alias: GroupsAssigned, length: 210 )
IT_Team
( type: esriFieldTypeInteger, alias: IT_Team )
Table:
IT_HelpDesk_YearlyAve
(2)
Name:
IT_HelpDesk_YearlyAve
Display Field:
Closed_Year
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
bd0a965c45c143198f9c11d09d69cee1
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
Closed_Year
( type: esriFieldTypeInteger, alias: Closed_Year )
Ticket_Count
( type: esriFieldTypeInteger, alias: Ticket_Count )
Avg_Days_Till_Closed
( type: esriFieldTypeDouble, alias: Avg_Days_Till_Closed )
Table:
IT_HelpDesk_Ticket
(1)
Name:
IT_HelpDesk_Ticket
Display Field:
TECH_USER_NAME
Type:
Table
Geometry Type:
N/A
Description:
null
Service Item Id:
bd0a965c45c143198f9c11d09d69cee1
Copyright Text:
null
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments:
false
HTML Popup Type:
esriServerHTMLPopupTypeNone
Type ID Field:
null
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID )
JOB_TICKET_ID
( type: esriFieldTypeInteger, alias: JOB_TICKET_ID )
ASSIGNED_TECH_ID
( type: esriFieldTypeDouble, alias: ASSIGNED_TECH_ID )
TECH_CLIENT_ID
( type: esriFieldTypeDouble, alias: TECH_CLIENT_ID )
TECH_DELETED
( type: esriFieldTypeDouble, alias: TECH_DELETED )
TECH_EMAIL
( type: esriFieldTypeString, alias: TECH_EMAIL, length: 86 )
TECH_EMPLOYMENT_STATUS
( type: esriFieldTypeString, alias: TECH_EMPLOYMENT_STATUS, length: 50 )
TECH_FIRST
( type: esriFieldTypeString, alias: TECH_FIRST, length: 59 )
TECH_LAST
( type: esriFieldTypeString, alias: TECH_LAST, length: 59 )
TECH_INACTIVE
( type: esriFieldTypeDouble, alias: TECH_INACTIVE )
TECH_LOCKED
( type: esriFieldTypeDouble, alias: TECH_LOCKED )
TECH_USER_NAME
( type: esriFieldTypeString, alias: TECH_USER_NAME, length: 65 )
GroupsAssigned
( type: esriFieldTypeString, alias: GroupsAssigned, length: 210 )
IT_Team
( type: esriFieldTypeInteger, alias: IT_Team )
CLIENT_ID
( type: esriFieldTypeDouble, alias: CLIENT_ID )
CLIENT_FIRST
( type: esriFieldTypeString, alias: CLIENT_FIRST, length: 86 )
CLIENT_LAST
( type: esriFieldTypeString, alias: CLIENT_LAST, length: 70 )
CLIENT_DEPARTMENT
( type: esriFieldTypeString, alias: CLIENT_DEPARTMENT, length: 94 )
LOCATION_NAME
( type: esriFieldTypeString, alias: LOCATION_NAME, length: 102 )
PRIORITY_TYPE_NAME
( type: esriFieldTypeString, alias: PRIORITY_TYPE_NAME, length: 60 )
DEPARTMENT_NAME
( type: esriFieldTypeString, alias: DEPARTMENT_NAME, length: 94 )
STATUS_TYPE_NAME
( type: esriFieldTypeString, alias: STATUS_TYPE_NAME, length: 81 )
REPORT_DATE
( type: esriFieldTypeDate, alias: REPORT_DATE, length: 8 )
TicketAgeDays
( type: esriFieldTypeDouble, alias: TicketAgeDays )
JOB_TIME
( type: esriFieldTypeDouble, alias: JOB_TIME )
LAST_CLIENT_REMINDER_DATE
( type: esriFieldTypeDate, alias: LAST_CLIENT_REMINDER_DATE, length: 8 )
LAST_CLIENT_UPDATE
( type: esriFieldTypeDate, alias: LAST_CLIENT_UPDATE, length: 8 )
LAST_EMAIL_SEND_DATE
( type: esriFieldTypeDate, alias: LAST_EMAIL_SEND_DATE, length: 8 )
LAST_REMINDER_DATE
( type: esriFieldTypeDate, alias: LAST_REMINDER_DATE, length: 8 )
LAST_STATUS_UPDATE_TIME
( type: esriFieldTypeDate, alias: LAST_STATUS_UPDATE_TIME, length: 8 )
LAST_UPDATED
( type: esriFieldTypeDate, alias: LAST_UPDATED, length: 8 )
WORK_START_DATE
( type: esriFieldTypeDate, alias: WORK_START_DATE, length: 8 )
WORK_END_DATE
( type: esriFieldTypeDate, alias: WORK_END_DATE, length: 8 )
SUBJECT
( type: esriFieldTypeString, alias: SUBJECT, length: 304 )
PROBLEM_TYPE_NAME
( type: esriFieldTypeString, alias: PROBLEM_TYPE_NAME, length: 84 )
QUESTION_TEXT
( type: esriFieldTypeString, alias: QUESTION_TEXT, length: 4000 )
FIRST_RESPONSE_DATE
( type: esriFieldTypeDate, alias: FIRST_RESPONSE_DATE, length: 8 )
CLOSE_DATE
( type: esriFieldTypeDate, alias: CLOSE_DATE, length: 8 )
Days_Till_Closed
( type: esriFieldTypeDouble, alias: Days_Till_Closed )
Closed_Year
( type: esriFieldTypeDouble, alias: Closed_Year )
JOB_TICKET_DELETED
( type: esriFieldTypeInteger, alias: JOB_TICKET_DELETED )
TECH_NAME
( type: esriFieldTypeString, alias: TECH_NAME, length: 255 )