{ "currentVersion": 10.91, "id": 0, "name": "GISDept.dbo.tblWorkOrder", "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": "WorkOrderID", "globalIdField": "", "displayField": "ReqTypeDesc", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "WorkOrderNo", "type": "esriFieldTypeInteger", "alias": "WorkOrderNo", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "WorkOrderNo" }, { "name": "ReqTypeID", "type": "esriFieldTypeInteger", "alias": "ReqTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReqTypeID" }, { "name": "ReqTypeDesc", "type": "esriFieldTypeString", "alias": "ReqTypeDesc", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ReqTypeDesc" }, { "name": "ReqUserID", "type": "esriFieldTypeInteger", "alias": "ReqUserID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReqUserID" }, { "name": "ReqUser", "type": "esriFieldTypeString", "alias": "ReqUser", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ReqUser" }, { "name": "ReqUserDept", "type": "esriFieldTypeString", "alias": "ReqUserDept", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ReqUserDept" }, { "name": "ReqUserDeptID", "type": "esriFieldTypeInteger", "alias": "ReqUserDeptID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ReqUserDeptID" }, { "name": "OtherRequestor", "type": "esriFieldTypeString", "alias": "OtherRequestor", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "OtherRequestor" }, { "name": "MapAreaInterest", "type": "esriFieldTypeString", "alias": "MapAreaInterest", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MapAreaInterest" }, { "name": "ReqComment", "type": "esriFieldTypeString", "alias": "ReqComment", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "ReqComment" }, { "name": "UrgencyTypeID", "type": "esriFieldTypeInteger", "alias": "UrgencyTypeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "UrgencyTypeID" }, { "name": "DateNeed", "type": "esriFieldTypeDate", "alias": "DateNeed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DateNeed" }, { "name": "DateTime", "type": "esriFieldTypeString", "alias": "DateTime", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "DateTime" }, { "name": "DateTimeID", "type": "esriFieldTypeInteger", "alias": "DateTimeID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "DateTimeID" }, { "name": "TimeUsed", "type": "esriFieldTypeDouble", "alias": "TimeUsed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeUsed" }, { "name": "Completed", "type": "esriFieldTypeSmallInteger", "alias": "Completed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Completed" }, { "name": "CompleteDate", "type": "esriFieldTypeDate", "alias": "CompleteDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CompleteDate" }, { "name": "CompleteNotes", "type": "esriFieldTypeString", "alias": "CompleteNotes", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "CompleteNotes" }, { "name": "MgrComment", "type": "esriFieldTypeString", "alias": "MgrComment", "domain": null, "editable": true, "nullable": true, "length": 1073741822, "defaultValue": null, "modelName": "MgrComment" }, { "name": "AssignToID", "type": "esriFieldTypeInteger", "alias": "AssignToID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssignToID" }, { "name": "AssignToUser", "type": "esriFieldTypeString", "alias": "AssignToUser", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "AssignToUser" }, { "name": "AssignDate", "type": "esriFieldTypeDate", "alias": "AssignDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AssignDate" }, { "name": "CDate", "type": "esriFieldTypeDate", "alias": "CDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CDate" }, { "name": "MDate", "type": "esriFieldTypeDate", "alias": "MDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MDate" }, { "name": "MUser", "type": "esriFieldTypeInteger", "alias": "MUser", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MUser" }, { "name": "MgrUserID", "type": "esriFieldTypeInteger", "alias": "MgrUserID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "MgrUserID" }, { "name": "MgrDateTime", "type": "esriFieldTypeDate", "alias": "MgrDateTime", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "MgrDateTime" }, { "name": "POINT_X", "type": "esriFieldTypeDouble", "alias": "POINT_X", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_X" }, { "name": "POINT_Y", "type": "esriFieldTypeDouble", "alias": "POINT_Y", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "POINT_Y" }, { "name": "WorkOrderID", "type": "esriFieldTypeOID", "alias": "WorkOrderID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "WorkOrderID" }, { "name": "AssignToID2", "type": "esriFieldTypeInteger", "alias": "AssignToID2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssignToID2" }, { "name": "AssignToID3", "type": "esriFieldTypeInteger", "alias": "AssignToID3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AssignToID3" }, { "name": "TimeAssign1", "type": "esriFieldTypeDouble", "alias": "TimeAssign1", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeAssign1" }, { "name": "TimeAssign2", "type": "esriFieldTypeDouble", "alias": "TimeAssign2", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeAssign2" }, { "name": "TimeAssign3", "type": "esriFieldTypeDouble", "alias": "TimeAssign3", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TimeAssign3" } ], "indexes": [ { "name": "PK_tblWorkOrder", "fields": "WorkOrderID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "GISDept.dbo.tblWorkOrder", "description": "", "prototype": { "attributes": { "TimeAssign2": null, "WorkOrderNo": null, "ReqTypeID": null, "ReqTypeDesc": null, "ReqUserID": null, "ReqUser": null, "ReqUserDept": null, "ReqUserDeptID": null, "OtherRequestor": null, "MapAreaInterest": null, "ReqComment": null, "UrgencyTypeID": null, "DateNeed": null, "DateTime": null, "DateTimeID": null, "TimeUsed": null, "Completed": null, "CompleteDate": null, "CompleteNotes": null, "MgrComment": null, "AssignToID": null, "AssignToUser": null, "AssignDate": null, "CDate": null, "MDate": null, "MUser": null, "MgrUserID": null, "MgrDateTime": null, "POINT_X": null, "POINT_Y": null, "TimeAssign3": null, "AssignToID2": null, "AssignToID3": null, "TimeAssign1": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1, "serviceItemId": "cda6be5bb90c4eee80aefb6d0e59c7ee" }