ArcGIS REST Services Directory
Login
Home
>
services
>
OpenData_IT_Tickets (FeatureServer)
>
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:
Service Item Id:
7dbb2fb1b5164fb29bfae138078b4652
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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: true
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: false
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:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
CLIENT_ID
( type: esriFieldTypeInteger, alias: CLIENT_ID, editable: true, nullable: true, defaultValue: null, modelName: CLIENT_ID )
DELETED
( type: esriFieldTypeInteger, alias: DELETED, editable: true, nullable: true, defaultValue: null, modelName: DELETED )
EMAIL
( type: esriFieldTypeString, alias: EMAIL, editable: true, nullable: true, length: 86, defaultValue: null, modelName: EMAIL )
EMPLOYMENT_STATUS
( type: esriFieldTypeString, alias: EMPLOYMENT_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: EMPLOYMENT_STATUS )
FIRST_NAME
( type: esriFieldTypeString, alias: FIRST_NAME, editable: true, nullable: true, length: 61, defaultValue: null, modelName: FIRST_NAME )
INACTIVE
( type: esriFieldTypeDouble, alias: INACTIVE, editable: true, nullable: true, defaultValue: null, modelName: INACTIVE )
LAST_NAME
( type: esriFieldTypeString, alias: LAST_NAME, editable: true, nullable: true, length: 59, defaultValue: null, modelName: LAST_NAME )
LOCKED
( type: esriFieldTypeInteger, alias: LOCKED, editable: true, nullable: true, defaultValue: null, modelName: LOCKED )
USER_NAME
( type: esriFieldTypeString, alias: USER_NAME, editable: true, nullable: true, length: 65, defaultValue: null, modelName: USER_NAME )
GroupsAssigned
( type: esriFieldTypeString, alias: GroupsAssigned, editable: true, nullable: true, length: 210, defaultValue: null, modelName: GroupsAssigned )
IT_Team
( type: esriFieldTypeInteger, alias: IT_Team, editable: true, nullable: true, defaultValue: null, modelName: IT_Team )
Templates:
Name: IT_HelpDesk_CurrentStaff
Description:
Prototype:
GroupsAssigned:
null
IT_Team:
null
CLIENT_ID:
null
DELETED:
null
EMAIL:
null
EMPLOYMENT_STATUS:
null
FIRST_NAME:
null
INACTIVE:
null
LAST_NAME:
null
LOCKED:
null
USER_NAME:
null
Drawing Tool: esriFeatureEditToolNone
Table:
IT_HelpDesk_YearlyAve
(2)
Name:
IT_HelpDesk_YearlyAve
Display Field:
Closed_Year
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
7dbb2fb1b5164fb29bfae138078b4652
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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: true
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: false
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:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
Closed_Year
( type: esriFieldTypeInteger, alias: Closed_Year, editable: true, nullable: true, defaultValue: null, modelName: Closed_Year )
Ticket_Count
( type: esriFieldTypeInteger, alias: Ticket_Count, editable: true, nullable: true, defaultValue: null, modelName: Ticket_Count )
Avg_Days_Till_Closed
( type: esriFieldTypeDouble, alias: Avg_Days_Till_Closed, editable: true, nullable: true, defaultValue: null, modelName: Avg_Days_Till_Closed )
Templates:
Name: IT_HelpDesk_YearlyAve
Description:
Prototype:
Ticket_Count:
null
Avg_Days_Till_Closed:
null
Closed_Year:
null
Drawing Tool: esriFeatureEditToolNone
Table:
IT_HelpDesk_Ticket
(1)
Name:
IT_HelpDesk_Ticket
Display Field:
TECH_USER_NAME
Type:
Table
Geometry Type:
N/A
Description:
Service Item Id:
7dbb2fb1b5164fb29bfae138078b4652
Copyright Text:
Default Visibility: false
MaxRecordCount:
2000
MaxSelectionCount:
0
Supported Query Formats:
JSON, geoJSON, PBF
Supports Advanced Queries:
true
Supports Statistics:
true
Use Standardized Queries:
true
Supports ValidateSQL:
true
Supports Calculate:
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: true
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: false
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:
Fields:
OBJECTID
( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
JOB_TICKET_ID
( type: esriFieldTypeInteger, alias: JOB_TICKET_ID, editable: true, nullable: true, defaultValue: null, modelName: JOB_TICKET_ID )
ASSIGNED_TECH_ID
( type: esriFieldTypeDouble, alias: ASSIGNED_TECH_ID, editable: true, nullable: true, defaultValue: null, modelName: ASSIGNED_TECH_ID )
TECH_CLIENT_ID
( type: esriFieldTypeDouble, alias: TECH_CLIENT_ID, editable: true, nullable: true, defaultValue: null, modelName: TECH_CLIENT_ID )
TECH_DELETED
( type: esriFieldTypeDouble, alias: TECH_DELETED, editable: true, nullable: true, defaultValue: null, modelName: TECH_DELETED )
TECH_EMAIL
( type: esriFieldTypeString, alias: TECH_EMAIL, editable: true, nullable: true, length: 86, defaultValue: null, modelName: TECH_EMAIL )
TECH_EMPLOYMENT_STATUS
( type: esriFieldTypeString, alias: TECH_EMPLOYMENT_STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TECH_EMPLOYMENT_STATUS )
TECH_FIRST
( type: esriFieldTypeString, alias: TECH_FIRST, editable: true, nullable: true, length: 59, defaultValue: null, modelName: TECH_FIRST )
TECH_LAST
( type: esriFieldTypeString, alias: TECH_LAST, editable: true, nullable: true, length: 59, defaultValue: null, modelName: TECH_LAST )
TECH_INACTIVE
( type: esriFieldTypeDouble, alias: TECH_INACTIVE, editable: true, nullable: true, defaultValue: null, modelName: TECH_INACTIVE )
TECH_LOCKED
( type: esriFieldTypeDouble, alias: TECH_LOCKED, editable: true, nullable: true, defaultValue: null, modelName: TECH_LOCKED )
TECH_USER_NAME
( type: esriFieldTypeString, alias: TECH_USER_NAME, editable: true, nullable: true, length: 65, defaultValue: null, modelName: TECH_USER_NAME )
GroupsAssigned
( type: esriFieldTypeString, alias: GroupsAssigned, editable: true, nullable: true, length: 210, defaultValue: null, modelName: GroupsAssigned )
IT_Team
( type: esriFieldTypeInteger, alias: IT_Team, editable: true, nullable: true, defaultValue: null, modelName: IT_Team )
CLIENT_ID
( type: esriFieldTypeDouble, alias: CLIENT_ID, editable: true, nullable: true, defaultValue: null, modelName: CLIENT_ID )
CLIENT_FIRST
( type: esriFieldTypeString, alias: CLIENT_FIRST, editable: true, nullable: true, length: 86, defaultValue: null, modelName: CLIENT_FIRST )
CLIENT_LAST
( type: esriFieldTypeString, alias: CLIENT_LAST, editable: true, nullable: true, length: 70, defaultValue: null, modelName: CLIENT_LAST )
CLIENT_DEPARTMENT
( type: esriFieldTypeString, alias: CLIENT_DEPARTMENT, editable: true, nullable: true, length: 94, defaultValue: null, modelName: CLIENT_DEPARTMENT )
LOCATION_NAME
( type: esriFieldTypeString, alias: LOCATION_NAME, editable: true, nullable: true, length: 102, defaultValue: null, modelName: LOCATION_NAME )
PRIORITY_TYPE_NAME
( type: esriFieldTypeString, alias: PRIORITY_TYPE_NAME, editable: true, nullable: true, length: 60, defaultValue: null, modelName: PRIORITY_TYPE_NAME )
DEPARTMENT_NAME
( type: esriFieldTypeString, alias: DEPARTMENT_NAME, editable: true, nullable: true, length: 94, defaultValue: null, modelName: DEPARTMENT_NAME )
STATUS_TYPE_NAME
( type: esriFieldTypeString, alias: STATUS_TYPE_NAME, editable: true, nullable: true, length: 81, defaultValue: null, modelName: STATUS_TYPE_NAME )
REPORT_DATE
( type: esriFieldTypeDate, alias: REPORT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORT_DATE )
TicketAgeDays
( type: esriFieldTypeDouble, alias: TicketAgeDays, editable: true, nullable: true, defaultValue: null, modelName: TicketAgeDays )
JOB_TIME
( type: esriFieldTypeDouble, alias: JOB_TIME, editable: true, nullable: true, defaultValue: null, modelName: JOB_TIME )
LAST_CLIENT_REMINDER_DATE
( type: esriFieldTypeDate, alias: LAST_CLIENT_REMINDER_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_CLIENT_REMINDER_DATE )
LAST_CLIENT_UPDATE
( type: esriFieldTypeDate, alias: LAST_CLIENT_UPDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_CLIENT_UPDATE )
LAST_EMAIL_SEND_DATE
( type: esriFieldTypeDate, alias: LAST_EMAIL_SEND_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_EMAIL_SEND_DATE )
LAST_REMINDER_DATE
( type: esriFieldTypeDate, alias: LAST_REMINDER_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_REMINDER_DATE )
LAST_STATUS_UPDATE_TIME
( type: esriFieldTypeDate, alias: LAST_STATUS_UPDATE_TIME, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_STATUS_UPDATE_TIME )
LAST_UPDATED
( type: esriFieldTypeDate, alias: LAST_UPDATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_UPDATED )
WORK_START_DATE
( type: esriFieldTypeDate, alias: WORK_START_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WORK_START_DATE )
WORK_END_DATE
( type: esriFieldTypeDate, alias: WORK_END_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WORK_END_DATE )
SUBJECT
( type: esriFieldTypeString, alias: SUBJECT, editable: true, nullable: true, length: 304, defaultValue: null, modelName: SUBJECT )
PROBLEM_TYPE_NAME
( type: esriFieldTypeString, alias: PROBLEM_TYPE_NAME, editable: true, nullable: true, length: 84, defaultValue: null, modelName: PROBLEM_TYPE_NAME )
QUESTION_TEXT
( type: esriFieldTypeString, alias: QUESTION_TEXT, editable: true, nullable: true, length: 4000, defaultValue: null, modelName: QUESTION_TEXT )
FIRST_RESPONSE_DATE
( type: esriFieldTypeDate, alias: FIRST_RESPONSE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FIRST_RESPONSE_DATE )
CLOSE_DATE
( type: esriFieldTypeDate, alias: CLOSE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSE_DATE )
Days_Till_Closed
( type: esriFieldTypeDouble, alias: Days_Till_Closed, editable: true, nullable: true, defaultValue: null, modelName: Days_Till_Closed )
Closed_Year
( type: esriFieldTypeDouble, alias: Closed_Year, editable: true, nullable: true, defaultValue: null, modelName: Closed_Year )
JOB_TICKET_DELETED
( type: esriFieldTypeInteger, alias: JOB_TICKET_DELETED, editable: true, nullable: true, defaultValue: null, modelName: JOB_TICKET_DELETED )
TECH_NAME
( type: esriFieldTypeString, alias: TECH_NAME, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TECH_NAME )
Templates:
Name: IT_HelpDesk_Ticket
Description:
Prototype:
JOB_TICKET_DELETED:
null
TECH_NAME:
null
JOB_TICKET_ID:
null
ASSIGNED_TECH_ID:
null
TECH_CLIENT_ID:
null
TECH_DELETED:
null
TECH_EMAIL:
null
TECH_EMPLOYMENT_STATUS:
null
TECH_FIRST:
null
TECH_LAST:
null
TECH_INACTIVE:
null
TECH_LOCKED:
null
TECH_USER_NAME:
null
GroupsAssigned:
null
IT_Team:
null
CLIENT_ID:
null
CLIENT_FIRST:
null
CLIENT_LAST:
null
CLIENT_DEPARTMENT:
null
LOCATION_NAME:
null
PRIORITY_TYPE_NAME:
null
DEPARTMENT_NAME:
null
STATUS_TYPE_NAME:
null
REPORT_DATE:
null
TicketAgeDays:
null
JOB_TIME:
null
LAST_CLIENT_REMINDER_DATE:
null
LAST_CLIENT_UPDATE:
null
LAST_EMAIL_SEND_DATE:
null
LAST_REMINDER_DATE:
null
LAST_STATUS_UPDATE_TIME:
null
LAST_UPDATED:
null
WORK_START_DATE:
null
WORK_END_DATE:
null
SUBJECT:
null
PROBLEM_TYPE_NAME:
null
QUESTION_TEXT:
null
FIRST_RESPONSE_DATE:
null
CLOSE_DATE:
null
Days_Till_Closed:
null
Closed_Year:
null
Drawing Tool: esriFeatureEditToolNone