{ "currentVersion": 10.71, "id": 173, "name": "DigTicketHistory", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "contactname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "ticketid", "type": "esriFieldTypeString", "alias": "TicketID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TicketID" }, { "name": "revision", "type": "esriFieldTypeString", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Revision" }, { "name": "accountid", "type": "esriFieldTypeString", "alias": "AccountID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AccountID" }, { "name": "startdate", "type": "esriFieldTypeDate", "alias": "StartDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "StartDate" }, { "name": "hoursnotice", "type": "esriFieldTypeSmallInteger", "alias": "HoursNotice", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "HoursNotice" }, { "name": "responserequired", "type": "esriFieldTypeString", "alias": "ResponseRequired", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ResponseRequired" }, { "name": "responseduedate", "type": "esriFieldTypeDate", "alias": "ResponseDueDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ResponseDueDate" }, { "name": "priority", "type": "esriFieldTypeString", "alias": "Priority", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Priority" }, { "name": "prioritytype", "type": "esriFieldTypeString", "alias": "Type", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Type" }, { "name": "fromaddress", "type": "esriFieldTypeString", "alias": "FromAddress", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FromAddress" }, { "name": "toaddress", "type": "esriFieldTypeString", "alias": "ToAddress", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ToAddress" }, { "name": "street", "type": "esriFieldTypeString", "alias": "Street", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Street" }, { "name": "crossstreet", "type": "esriFieldTypeString", "alias": "CrossStreet", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CrossStreet" }, { "name": "delineated", "type": "esriFieldTypeString", "alias": "Delineated", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Delineated" }, { "name": "delineationtype", "type": "esriFieldTypeString", "alias": "DelineationType", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "DelineationType" }, { "name": "instructions", "type": "esriFieldTypeString", "alias": "Instructions", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Instructions" }, { "name": "constructiontype", "type": "esriFieldTypeString", "alias": "WorkorderKey", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "WorkorderKey" }, { "name": "contactname", "type": "esriFieldTypeString", "alias": "ContactName", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ContactName" }, { "name": "address1", "type": "esriFieldTypeString", "alias": "Address1", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Address1" }, { "name": "address2", "type": "esriFieldTypeString", "alias": "Address2", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "Address2" }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "City" }, { "name": "state", "type": "esriFieldTypeString", "alias": "State", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "State" }, { "name": "zip", "type": "esriFieldTypeString", "alias": "Zip", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Zip" }, { "name": "phone", "type": "esriFieldTypeString", "alias": "Phone", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Phone" }, { "name": "email", "type": "esriFieldTypeString", "alias": "Email", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Email" }, { "name": "location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Location" }, { "name": "comments", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "Comments" }, { "name": "tickettext", "type": "esriFieldTypeString", "alias": "TicketText", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "TicketText" }, { "name": "assetkey", "type": "esriFieldTypeString", "alias": "assetkey", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "assetkey" }, { "name": "workorderkey", "type": "esriFieldTypeString", "alias": "workorderkey", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workorderkey" }, { "name": "workdate", "type": "esriFieldTypeDate", "alias": "workdate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "workdate" }, { "name": "workby", "type": "esriFieldTypeString", "alias": "workby", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "workby" }, { "name": "worktype", "type": "esriFieldTypeString", "alias": "worktype", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "worktype" }, { "name": "assetsin", "type": "esriFieldTypeString", "alias": "assetsin", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "assetsin" }, { "name": "needfieldverification", "type": "esriFieldTypeString", "alias": "needfieldverification", "domain": { "type": "codedValue", "name": "sedaYesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "needfieldverification" }, { "name": "attachmentid", "type": "esriFieldTypeInteger", "alias": "attachmentid", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid" }, { "name": "status", "type": "esriFieldTypeString", "alias": "status", "domain": { "type": "codedValue", "name": "DigStatus", "description": "", "codedValues": [ { "name": "Marked", "code": "Marked" }, { "name": "Work Already Completed", "code": "Work Already Completed" }, { "name": "No Conflict", "code": "No Conflict" }, { "name": "Update Work Only", "code": "Update Work Only" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "status" }, { "name": "attachmentid2", "type": "esriFieldTypeInteger", "alias": "attachmentid2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid2" }, { "name": "attachmentid3", "type": "esriFieldTypeInteger", "alias": "attachmentid3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "attachmentid3" } ], "indexes": [ { "name": "R117_SDE_ROWID_UK", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "DigTicketHistory", "description": "", "prototype": { "attributes": { "attachmentid2": null, "attachmentid3": null, "ticketid": null, "revision": null, "accountid": null, "startdate": null, "hoursnotice": null, "responserequired": null, "responseduedate": null, "priority": null, "prioritytype": null, "fromaddress": null, "toaddress": null, "street": null, "crossstreet": null, "delineated": null, "delineationtype": null, "instructions": null, "constructiontype": null, "contactname": null, "address1": null, "address2": null, "city": null, "state": null, "zip": null, "phone": null, "email": null, "location": null, "comments": null, "tickettext": null, "assetkey": null, "workorderkey": null, "workdate": null, "workby": null, "worktype": null, "assetsin": null, "needfieldverification": null, "attachmentid": null, "status": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 3000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1 }