Layers:

Layer: IT_HelpdeskTickets (0)

Name: IT_HelpdeskTickets

Display Field: LOCATION_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 3bb630549a1e404bb5ffe111c85e9085

Copyright Text:

Default Visibility: true

MaxRecordCount: 200000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:
XMin: 1.0000000000000568
YMin: 1.0000000000000568
XMax: 1.0000000000000568
YMax: 1.0000000000000568
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)



Drawing Info:
Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [31, 110, 135, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Field1 ( type: esriFieldTypeInteger, alias: Field1, editable: true, nullable: true, defaultValue: null, modelName: Field1 )
• 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_FIRST ( type: esriFieldTypeString, alias: TECH FIRST, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TECH_FIRST )
• TECH_LAST ( type: esriFieldTypeString, alias: TECH LAST, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: TECH_LAST )
• 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: 1073741822, defaultValue: null, modelName: CLIENT_FIRST )
• CLIENT_LAST ( type: esriFieldTypeString, alias: CLIENT LAST, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CLIENT_LAST )
• CLIENT_DEPARTMENT ( type: esriFieldTypeString, alias: CLIENT DEPARTMENT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: CLIENT_DEPARTMENT )
• LOCATION_NAME ( type: esriFieldTypeString, alias: LOCATION_NAME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: LOCATION_NAME )
• PRIORITY_TYPE_NAME ( type: esriFieldTypeString, alias: PRIORITY_TYPE_NAME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PRIORITY_TYPE_NAME )
• DEPARTMENT_NAME ( type: esriFieldTypeString, alias: DEPARTMENT NAME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: DEPARTMENT_NAME )
• STATUS_TYPE_NAME ( type: esriFieldTypeString, alias: STATUS_TYPE_NAME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: STATUS_TYPE_NAME )
• REPORT_DATE ( type: esriFieldTypeDate, alias: REPORT_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPORT_DATE )
• 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: esriFieldTypeString, alias: LAST_CLIENT_UPDATE, editable: true, nullable: true, length: 1073741822, 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: esriFieldTypeString, alias: WORK_START_DATE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WORK_START_DATE )
• WORK_END_DATE ( type: esriFieldTypeString, alias: WORK_END_DATE, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: WORK_END_DATE )
• SUBJECT ( type: esriFieldTypeString, alias: SUBJECT, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: SUBJECT )
• PROBLEM_TYPE_NAME ( type: esriFieldTypeString, alias: PROBLEM_TYPE_NAME, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: PROBLEM_TYPE_NAME )
• QUESTION_TEXT ( type: esriFieldTypeString, alias: QUESTION_TEXT, editable: true, nullable: true, length: 1073741822, 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 )
• xy ( type: esriFieldTypeInteger, alias: xy, editable: true, nullable: true, defaultValue: null, modelName: xy )
• CLOSE_DATE ( type: esriFieldTypeDate, alias: CLOSE_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSE_DATE )
• DELETED ( type: esriFieldTypeSmallInteger, alias: DELETED, editable: true, nullable: true, defaultValue: null, modelName: DELETED )
Templates:
• Name: IT_HelpdeskTickets
  Description:
  Prototype:
  CLOSE_DATE: null
  DELETED: null
  Field1: null
  JOB_TICKET_ID: null
  ASSIGNED_TECH_ID: null
  TECH_FIRST: null
  TECH_LAST: 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
  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
  xy: null
  
  Drawing Tool: esriFeatureEditToolPoint

Tables:

Table: IT_Helpdesk_TicketHistory (1)

Name: IT_Helpdesk_TicketHistory

Display Field: TotalCount

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 3bb630549a1e404bb5ffe111c85e9085

Copyright Text:

Default Visibility: false

MaxRecordCount: 200000

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 )
• TotalCount ( type: esriFieldTypeInteger, alias: TotalCount, editable: true, nullable: true, defaultValue: null, modelName: TotalCount )
• closedCount ( type: esriFieldTypeInteger, alias: closedCount, editable: true, nullable: true, defaultValue: null, modelName: closedCount )
• openedCount ( type: esriFieldTypeInteger, alias: openedCount, editable: true, nullable: true, defaultValue: null, modelName: openedCount )
• Ticket_date ( type: esriFieldTypeDate, alias: Ticket_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Ticket_date )
• TicketDt_txt ( type: esriFieldTypeString, alias: TicketDt_txt, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TicketDt_txt )
Templates:
• Name: IT_Helpdesk_TicketHistory
  Description:
  Prototype:
  Ticket_date: null
  TicketDt_txt: null
  TotalCount: null
  closedCount: null
  openedCount: null
  
  Drawing Tool: esriFeatureEditToolNone