{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 1, "name": "IT_HelpDesk_Ticket", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "TECH_USER_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "JOB_TICKET_ID", "type": "esriFieldTypeInteger", "alias": "JOB_TICKET_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JOB_TICKET_ID" }, { "name": "ASSIGNED_TECH_ID", "type": "esriFieldTypeDouble", "alias": "ASSIGNED_TECH_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ASSIGNED_TECH_ID" }, { "name": "TECH_CLIENT_ID", "type": "esriFieldTypeDouble", "alias": "TECH_CLIENT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TECH_CLIENT_ID" }, { "name": "TECH_DELETED", "type": "esriFieldTypeDouble", "alias": "TECH_DELETED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TECH_DELETED" }, { "name": "TECH_EMAIL", "type": "esriFieldTypeString", "alias": "TECH_EMAIL", "domain": null, "editable": true, "nullable": true, "length": 86, "defaultValue": null, "modelName": "TECH_EMAIL" }, { "name": "TECH_EMPLOYMENT_STATUS", "type": "esriFieldTypeString", "alias": "TECH_EMPLOYMENT_STATUS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TECH_EMPLOYMENT_STATUS" }, { "name": "TECH_FIRST", "type": "esriFieldTypeString", "alias": "TECH_FIRST", "domain": null, "editable": true, "nullable": true, "length": 59, "defaultValue": null, "modelName": "TECH_FIRST" }, { "name": "TECH_LAST", "type": "esriFieldTypeString", "alias": "TECH_LAST", "domain": null, "editable": true, "nullable": true, "length": 59, "defaultValue": null, "modelName": "TECH_LAST" }, { "name": "TECH_INACTIVE", "type": "esriFieldTypeDouble", "alias": "TECH_INACTIVE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TECH_INACTIVE" }, { "name": "TECH_LOCKED", "type": "esriFieldTypeDouble", "alias": "TECH_LOCKED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TECH_LOCKED" }, { "name": "TECH_USER_NAME", "type": "esriFieldTypeString", "alias": "TECH_USER_NAME", "domain": null, "editable": true, "nullable": true, "length": 65, "defaultValue": null, "modelName": "TECH_USER_NAME" }, { "name": "GroupsAssigned", "type": "esriFieldTypeString", "alias": "GroupsAssigned", "domain": null, "editable": true, "nullable": true, "length": 210, "defaultValue": null, "modelName": "GroupsAssigned" }, { "name": "IT_Team", "type": "esriFieldTypeInteger", "alias": "IT_Team", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "IT_Team" }, { "name": "CLIENT_ID", "type": "esriFieldTypeDouble", "alias": "CLIENT_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CLIENT_ID" }, { "name": "CLIENT_FIRST", "type": "esriFieldTypeString", "alias": "CLIENT_FIRST", "domain": null, "editable": true, "nullable": true, "length": 86, "defaultValue": null, "modelName": "CLIENT_FIRST" }, { "name": "CLIENT_LAST", "type": "esriFieldTypeString", "alias": "CLIENT_LAST", "domain": null, "editable": true, "nullable": true, "length": 70, "defaultValue": null, "modelName": "CLIENT_LAST" }, { "name": "CLIENT_DEPARTMENT", "type": "esriFieldTypeString", "alias": "CLIENT_DEPARTMENT", "domain": null, "editable": true, "nullable": true, "length": 94, "defaultValue": null, "modelName": "CLIENT_DEPARTMENT" }, { "name": "LOCATION_NAME", "type": "esriFieldTypeString", "alias": "LOCATION_NAME", "domain": null, "editable": true, "nullable": true, "length": 102, "defaultValue": null, "modelName": "LOCATION_NAME" }, { "name": "PRIORITY_TYPE_NAME", "type": "esriFieldTypeString", "alias": "PRIORITY_TYPE_NAME", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "PRIORITY_TYPE_NAME" }, { "name": "DEPARTMENT_NAME", "type": "esriFieldTypeString", "alias": "DEPARTMENT_NAME", "domain": null, "editable": true, "nullable": true, "length": 94, "defaultValue": null, "modelName": "DEPARTMENT_NAME" }, { "name": "STATUS_TYPE_NAME", "type": "esriFieldTypeString", "alias": "STATUS_TYPE_NAME", "domain": null, "editable": true, "nullable": true, "length": 81, "defaultValue": null, "modelName": "STATUS_TYPE_NAME" }, { "name": "REPORT_DATE", "type": "esriFieldTypeDate", "alias": "REPORT_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "REPORT_DATE" }, { "name": "TicketAgeDays", "type": "esriFieldTypeDouble", "alias": "TicketAgeDays", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TicketAgeDays" }, { "name": "JOB_TIME", "type": "esriFieldTypeDouble", "alias": "JOB_TIME", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JOB_TIME" }, { "name": "LAST_CLIENT_REMINDER_DATE", "type": "esriFieldTypeDate", "alias": "LAST_CLIENT_REMINDER_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_CLIENT_REMINDER_DATE" }, { "name": "LAST_CLIENT_UPDATE", "type": "esriFieldTypeDate", "alias": "LAST_CLIENT_UPDATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_CLIENT_UPDATE" }, { "name": "LAST_EMAIL_SEND_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EMAIL_SEND_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EMAIL_SEND_DATE" }, { "name": "LAST_REMINDER_DATE", "type": "esriFieldTypeDate", "alias": "LAST_REMINDER_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_REMINDER_DATE" }, { "name": "LAST_STATUS_UPDATE_TIME", "type": "esriFieldTypeDate", "alias": "LAST_STATUS_UPDATE_TIME", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_STATUS_UPDATE_TIME" }, { "name": "LAST_UPDATED", "type": "esriFieldTypeDate", "alias": "LAST_UPDATED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_UPDATED" }, { "name": "WORK_START_DATE", "type": "esriFieldTypeDate", "alias": "WORK_START_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WORK_START_DATE" }, { "name": "WORK_END_DATE", "type": "esriFieldTypeDate", "alias": "WORK_END_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "WORK_END_DATE" }, { "name": "SUBJECT", "type": "esriFieldTypeString", "alias": "SUBJECT", "domain": null, "editable": true, "nullable": true, "length": 304, "defaultValue": null, "modelName": "SUBJECT" }, { "name": "PROBLEM_TYPE_NAME", "type": "esriFieldTypeString", "alias": "PROBLEM_TYPE_NAME", "domain": null, "editable": true, "nullable": true, "length": 84, "defaultValue": null, "modelName": "PROBLEM_TYPE_NAME" }, { "name": "QUESTION_TEXT", "type": "esriFieldTypeString", "alias": "QUESTION_TEXT", "domain": null, "editable": true, "nullable": true, "length": 4000, "defaultValue": null, "modelName": "QUESTION_TEXT" }, { "name": "FIRST_RESPONSE_DATE", "type": "esriFieldTypeDate", "alias": "FIRST_RESPONSE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FIRST_RESPONSE_DATE" }, { "name": "CLOSE_DATE", "type": "esriFieldTypeDate", "alias": "CLOSE_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CLOSE_DATE" }, { "name": "Days_Till_Closed", "type": "esriFieldTypeDouble", "alias": "Days_Till_Closed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Days_Till_Closed" }, { "name": "Closed_Year", "type": "esriFieldTypeDouble", "alias": "Closed_Year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Closed_Year" }, { "name": "JOB_TICKET_DELETED", "type": "esriFieldTypeInteger", "alias": "JOB_TICKET_DELETED", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "JOB_TICKET_DELETED" }, { "name": "TECH_NAME", "type": "esriFieldTypeString", "alias": "TECH_NAME", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "TECH_NAME" } ], "indexes": [ { "name": "R335_SDE_ROWID_UK", "isAscending": true, "isUnique": true, "description": "", "fields": "OBJECTID" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Pacific Standard Time", "timeZoneIANA": "America/Los_Angeles", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "IT_HelpDesk_Ticket", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "7dbb2fb1b5164fb29bfae138078b4652" }