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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata