{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "LOCATE_RESUBMIT_HISTORY", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [ { "id": 0, "name": "LocateRequestForm", "relatedTableId": 0, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 1, "name": "LocateRequestForm", "relatedTableId": 1, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 2, "name": "LocateRequestForm", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 3, "name": "LocateRequestForm", "relatedTableId": 3, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 4, "name": "LocateRequestForm", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 5, "name": "LocateRequestForm", "relatedTableId": 5, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false }, { "id": 6, "name": "LocateRequestForm", "relatedTableId": 6, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "composite": false } ], "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, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "EMPLOYEENAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "EMPLOYEENAME", "type": "esriFieldTypeString", "alias": "Employee Name", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "EMPLOYEENAME" }, { "name": "PREVIOUSTICKETNUMBER", "type": "esriFieldTypeString", "alias": "Previous Ticket Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PREVIOUSTICKETNUMBER" }, { "name": "WORKTYPE", "type": "esriFieldTypeString", "alias": "Work Type", "domain": { "type": "codedValue", "name": "LRFormTypeofWork", "description": "LRFormTypeofWork", "codedValues": [ { "name": "Groundwork", "code": "Groundwork" }, { "name": "Landscaping", "code": "Landscaping" }, { "name": "Poles/Holes", "code": "Poles/Holes" }, { "name": "Road Work", "code": "Road Work" }, { "name": "Sewer", "code": "Sewer" }, { "name": "Water", "code": "Water" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "WORKTYPE" }, { "name": "DIG_ALLEY", "type": "esriFieldTypeString", "alias": "Dig in Alley", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_ALLEY" }, { "name": "DIG_SIDE", "type": "esriFieldTypeString", "alias": "Dig in Side Yard", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_SIDE" }, { "name": "DIG_STREET", "type": "esriFieldTypeString", "alias": "Dig in Street", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_STREET" }, { "name": "DIG_SIDEWALK", "type": "esriFieldTypeString", "alias": "Dig in Sidewalk", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_SIDEWALK" }, { "name": "DIG_SITEMARKED", "type": "esriFieldTypeString", "alias": "Dig in Site marked/staked", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_SITEMARKED" }, { "name": "DIG_FRONTLOT", "type": "esriFieldTypeString", "alias": "Dig in Front Lot", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_FRONTLOT" }, { "name": "DIG_BACKLOT", "type": "esriFieldTypeString", "alias": "Dig in Back Lot", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_BACKLOT" }, { "name": "DIG_CONTRACTTOMEET", "type": "esriFieldTypeString", "alias": "Dig Contract to Meet", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_CONTRACTTOMEET" }, { "name": "DIG_CALLWHENCOMPLETE", "type": "esriFieldTypeString", "alias": "Call When Dig Complete", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "DIG_CALLWHENCOMPLETE" }, { "name": "EXP_START_DATE", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "EXP_START_DATE" }, { "name": "ADDITIONALINFO", "type": "esriFieldTypeString", "alias": "Additional Information", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "ADDITIONALINFO" }, { "name": "SR_FOR_FACILITIES", "type": "esriFieldTypeString", "alias": "Service Request required for Facilities", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SR_FOR_FACILITIES" }, { "name": "SR_FOR_IRRIGATION", "type": "esriFieldTypeString", "alias": "Service Request required for Irrigation (Parks)", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SR_FOR_IRRIGATION" }, { "name": "EMPLOYEEPHONENUMBER", "type": "esriFieldTypeString", "alias": "Employee Phone Number", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "EMPLOYEEPHONENUMBER" }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "ADDRESS" }, { "name": "SASK_1ST_CALL", "type": "esriFieldTypeString", "alias": "Sask 1st Confirmation Number", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SASK_1ST_CALL" }, { "name": "SASKPOWER_STATUS", "type": "esriFieldTypeString", "alias": "SaskPower Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "SASKPOWER_STATUS" }, { "name": "SASKPOWER_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskPower Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SASKPOWER_COMPLETEDATE" }, { "name": "SASKENERGY_STATUS", "type": "esriFieldTypeString", "alias": "SaskEnergy Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "SASKENERGY_STATUS" }, { "name": "SASKENERGY_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskEnergy Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SASKENERGY_COMPLETEDATE" }, { "name": "SASKTEL_STATUS", "type": "esriFieldTypeString", "alias": "SaskTel Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "SASKTEL_STATUS" }, { "name": "SASKTEL_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskTel Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SASKTEL_COMPLETEDATE" }, { "name": "ACCESS_STATUS", "type": "esriFieldTypeString", "alias": "Access Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "ACCESS_STATUS" }, { "name": "ACCESS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Access Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ACCESS_COMPLETEDATE" }, { "name": "BHTEL_STATUS", "type": "esriFieldTypeString", "alias": "BHTel Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "BHTEL_STATUS" }, { "name": "BHTEL_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "BHTel Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "BHTEL_COMPLETEDATE" }, { "name": "FACILITIES_STATUS", "type": "esriFieldTypeString", "alias": "Facilities Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "FACILITIES_STATUS" }, { "name": "FACILITIES_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Facilities Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "FACILITIES_COMPLETEDATE" }, { "name": "TRAFFIC_STATUS", "type": "esriFieldTypeString", "alias": "Traffic Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "TRAFFIC_STATUS" }, { "name": "TRAFFIC_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Traffic Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TRAFFIC_COMPLETEDATE" }, { "name": "PARKS_STATUS", "type": "esriFieldTypeString", "alias": "Parks Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PARKS_STATUS" }, { "name": "PARKS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Parks Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PARKS_COMPLETEDATE" }, { "name": "DEVSERV_STATUS", "type": "esriFieldTypeString", "alias": "Dev Services Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "DEVSERV_STATUS" }, { "name": "DEVSERV_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Dev Services Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DEVSERV_COMPLETEDATE" }, { "name": "ENBRIDGE_STATUS", "type": "esriFieldTypeString", "alias": "Enbridge Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ENBRIDGE_STATUS" }, { "name": "ENBRIDGE_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Enbridge Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ENBRIDGE_COMPLETEDATE" }, { "name": "PLAINSMID_STATUS", "type": "esriFieldTypeString", "alias": "Plains Midstream Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "PLAINSMID_STATUS" }, { "name": "PLAINSMID_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Plains Midstream Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PLAINSMID_COMPLETEDATE" }, { "name": "ROGERS_STATUS", "type": "esriFieldTypeString", "alias": "Rogers Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "ROGERS_STATUS" }, { "name": "ROGERS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Rogers Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ROGERS_COMPLETEDATE" }, { "name": "TELUS_STATUS", "type": "esriFieldTypeString", "alias": "Telus Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TELUS_STATUS" }, { "name": "TELUS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Telus Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TELUS_COMPLETEDATE" }, { "name": "UOFR_STATUS", "type": "esriFieldTypeString", "alias": "U of R Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "UOFR_STATUS" }, { "name": "UOFR_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "U of R Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "UOFR_COMPLETEDATE" }, { "name": "ZAYO_STATUS", "type": "esriFieldTypeString", "alias": "Zayo Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": "Required", "modelName": "ZAYO_STATUS" }, { "name": "ZAYO_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Zayo Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ZAYO_COMPLETEDATE" }, { "name": "ALL_LOCATES_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Locate Request Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "ALL_LOCATES_COMPLETEDATE" }, { "name": "FIRST_INT_STREET", "type": "esriFieldTypeString", "alias": "First Intersecting Street", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "FIRST_INT_STREET" }, { "name": "SECOND_INT_STREET", "type": "esriFieldTypeString", "alias": "Second Intersecting Street", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "SECOND_INT_STREET" }, { "name": "EMPLOYEE_EMAIL", "type": "esriFieldTypeString", "alias": "Employee Email", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "EMPLOYEE_EMAIL" }, { "name": "EMPLOYEE_BRANCH", "type": "esriFieldTypeString", "alias": "Employee Branch", "domain": { "type": "codedValue", "name": "LRFormBranch", "description": "", "codedValues": [ { "name": "Engineering Design Solutions", "code": "Engineering Design Solutions" }, { "name": "Environmental Services", "code": "Environmental Services" }, { "name": "Facilities Management Services", "code": "Facilities Management Services" }, { "name": "Infrastructure Delivery", "code": "Infrastructure Delivery" }, { "name": "Landfill", "code": "Landfill" }, { "name": "Parks & Open Space Services", "code": "Parks & Open Space Services" }, { "name": "Parks Maintenance", "code": "Parks Maintenance" }, { "name": "Roadways Capital Operations", "code": "Roadways Capital Operations" }, { "name": "Roadways Maintenance Operations", "code": "Roadways Maintenance Operations" }, { "name": "Roadways Preservation", "code": "Roadways Preservation" }, { "name": "Roadways Seasonal Operations", "code": "Roadways Seasonal Operations" }, { "name": "Sewer & Drainage Operations", "code": "Sewer & Drainage Operations" }, { "name": "Sports Facilities & Special Events", "code": "Sports Facilities & Special Events" }, { "name": "Traffic Engineering", "code": "Traffic Engineering" }, { "name": "Transportation Operations", "code": "Transportation Operations" }, { "name": "Water & Sewer Engineering", "code": "Water & Sewer Engineering" }, { "name": "Water Operations", "code": "Water Operations" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EMPLOYEE_BRANCH" }, { "name": "UTILITY_HIT", "type": "esriFieldTypeString", "alias": "Utility Hit", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "UTILITY_HIT" }, { "name": "LOCATE_EXPIREDATE", "type": "esriFieldTypeDate", "alias": "Locate Expires On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LOCATE_EXPIREDATE" }, { "name": "HIGH_VOLTAGE_PRESSURE", "type": "esriFieldTypeString", "alias": "High Voltage/High Pressure", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "HIGH_VOLTAGE_PRESSURE" }, { "name": "SR_EMAIL_SENT_CLIENT", "type": "esriFieldTypeString", "alias": "OSR Email sent to Client", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SR_EMAIL_SENT_CLIENT" }, { "name": "SR_INITIALS", "type": "esriFieldTypeString", "alias": "OSR Initials", "domain": null, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SR_INITIALS" }, { "name": "LOCATE_PROGRESS_STATUS", "type": "esriFieldTypeString", "alias": "Locate Progress Status", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "LOCATE_PROGRESS_STATUS" }, { "name": "SASKENERGY_PERMIT_REQ", "type": "esriFieldTypeString", "alias": "SaskEnergy Permit Required", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 1, "defaultValue": "N", "modelName": "SASKENERGY_PERMIT_REQ" }, { "name": "SASKENERGY_PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "SaskEnergy Permit Number", "domain": null, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "SASKENERGY_PERMIT_NUMBER" }, { "name": "WORKORDER", "type": "esriFieldTypeString", "alias": "Workorder Number", "domain": null, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "WORKORDER" }, { "name": "TRANSCANPIPE_STATUS", "type": "esriFieldTypeString", "alias": "TransCanada Pipeline Status", "domain": { "type": "codedValue", "name": "LRFormCompleteStatus", "description": "Locate Request Form Completion Status", "codedValues": [ { "name": "Not Required", "code": "Not Required" }, { "name": "Required", "code": "Required" }, { "name": "Located", "code": "Located" }, { "name": "Cleared", "code": "Cleared" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 25, "defaultValue": null, "modelName": "TRANSCANPIPE_STATUS" }, { "name": "TRANSCANPIPE_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "TransCanada Pipeline Completed On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "TRANSCANPIPE_COMPLETEDATE" }, { "name": "CUTSIDNUM", "type": "esriFieldTypeDouble", "alias": "CUTSIDNUM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "CUTSIDNUM" }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Created On", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATE_DATE" }, { "name": "DISPATCH_COMMENTS", "type": "esriFieldTypeString", "alias": "Dispatch Comments", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Dispatch_Comments" }, { "name": "ORIGINATING_WO", "type": "esriFieldTypeString", "alias": "ORIGINATING_WO", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ORIGINATING_WO" }, { "name": "REPAIR_WO_NO_1", "type": "esriFieldTypeString", "alias": "REPAIR_WO_NO_1", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "REPAIR_WO_NO_1" }, { "name": "EXCAVATION_METHOD", "type": "esriFieldTypeString", "alias": "Excavation Method", "domain": { "type": "codedValue", "name": "LRFormExcavationMethod ", "description": "LRFormExcavationMethod ", "codedValues": [ { "name": "Hydro Vacuum", "code": "Hydro Vacuum" }, { "name": "None", "code": "None" }, { "name": "Saw Cut", "code": "Saw Cut" }, { "name": "Trenching", "code": "Trenching" }, { "name": "Machine Digging", "code": "Machine Digging" }, { "name": "Hand digging", "code": "Hand digging" }, { "name": "Coring", "code": "Coring" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Excavation_Method" }, { "name": "DEPTH_SIZE", "type": "esriFieldTypeString", "alias": "Depth Size", "domain": { "type": "codedValue", "name": "LRFormDepthSize", "description": "LRFormDepthSize", "codedValues": [ { "name": "Less than 1 m", "code": "Less than 1 m" }, { "name": "1 m to 3 m", "code": "1 m to 3 m" }, { "name": "Greater than 3 m", "code": "Greater than 3 m" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Depth_Size" }, { "name": "ACTIVITY", "type": "esriFieldTypeString", "alias": "ACTIVITY", "domain": { "type": "codedValue", "name": "LRFormActivity", "description": "LRFormActivity", "codedValues": [ { "name": "Catch Basin", "code": "Catch Basin" }, { "name": "Hydrant", "code": "Hydrant" }, { "name": "Irrigation", "code": "Irrigation" }, { "name": "Lighting", "code": "Lighting" }, { "name": "Maintenance Hole", "code": "Maintenance Hole" }, { "name": "Pole Install", "code": "Pole Install" }, { "name": "Resurface Road", "code": "Resurface Road" }, { "name": "Road Install", "code": "Road Install" }, { "name": "Road Paving", "code": "Road Paving" }, { "name": "Sewer Main Repair", "code": "Sewer Main Repair" }, { "name": "Sewer Service Repair", "code": "Sewer Service Repair" }, { "name": "Sidewalks", "code": "Sidewalks" }, { "name": "Signage", "code": "Signage" }, { "name": "Stumping", "code": "Stumping" }, { "name": "Traffic Signals", "code": "Traffic Signals" }, { "name": "Trenching", "code": "Trenching" }, { "name": "Water Main Repair", "code": "Water Main Repair" }, { "name": "Water Service Repair", "code": "Water Service Repair" }, { "name": "Other", "code": "Other" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ACTIVITY" }, { "name": "WORKING_ON", "type": "esriFieldTypeString", "alias": "Working On", "domain": { "type": "codedValue", "name": "LRFormWorkingOn", "description": "LRFormWorkingOn", "codedValues": [ { "name": "Public Property Only", "code": "Public Property Only" }, { "name": "Public and Private Property", "code": "Public and Private Property" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "Working_On" }, { "name": "SR_PARKS", "type": "esriFieldTypeString", "alias": "Service Request required for Parks", "domain": { "type": "codedValue", "name": "YesNo", "description": "", "codedValues": [ { "name": "Yes", "code": "Y" }, { "name": "No", "code": "N" }, { "name": "N/A", "code": "N/A" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDuplicate" }, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SR_PARKS" }, { "name": "WORKDETAILS", "type": "esriFieldTypeString", "alias": "WORKDETAILS", "domain": { "type": "codedValue", "name": "LRFormWorkDetails", "description": "Locate Request Form Work Details", "codedValues": [ { "name": "Regular Ticket (up to 1000 sq meters)", "code": "Regular Ticket (up to 1000 sq meters)" }, { "name": "Project (1000 sq meters to 60, 000 sq meters)", "code": "Project (1000 sq meters to 60, 000 sq meters)" }, { "name": "Large Project (60,000 sq meters to 800,000 sq meters)", "code": "Large Project (60,000 sq meters to 800,000 sq meters)" }, { "name": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)", "code": "Planning (Preparation only, no lines will be marked, not valid for digging purposes)" }, { "name": "Short Notice", "code": "Short Notice" }, { "name": "Emergency Locate - call Infrastructure Delivery at 306-777-7558", "code": "Emergency Locate - call Infrastructure Delivery at 306-777-7558" }, { "name": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558", "code": "Priority Locate \u2013 submit form and call Infrastructure Delivery at 306-777-7558" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 200, "defaultValue": null, "modelName": "WORKDETAILS" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" } ], "indexes": [ { "name": "R2021505_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2021505", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "LOCATE_RESUBMIT_HISTORY", "description": "", "prototype": { "attributes": { "WORKDETAILS": null, "SR_PARKS": null, "EMPLOYEENAME": null, "PREVIOUSTICKETNUMBER": null, "WORKTYPE": null, "DIG_ALLEY": "N", "DIG_SIDE": "N", "DIG_STREET": "N", "DIG_SIDEWALK": "N", "DIG_SITEMARKED": "N", "DIG_FRONTLOT": "N", "DIG_BACKLOT": "N", "DIG_CONTRACTTOMEET": "N", "DIG_CALLWHENCOMPLETE": "N", "EXP_START_DATE": null, "ADDITIONALINFO": null, "SR_FOR_FACILITIES": "N", "SR_FOR_IRRIGATION": "N", "EMPLOYEEPHONENUMBER": null, "ADDRESS": null, "SASK_1ST_CALL": null, "SASKPOWER_STATUS": "Required", "SASKPOWER_COMPLETEDATE": null, "SASKENERGY_STATUS": "Required", "SASKENERGY_COMPLETEDATE": null, "SASKTEL_STATUS": "Required", "SASKTEL_COMPLETEDATE": null, "ACCESS_STATUS": "Required", "ACCESS_COMPLETEDATE": null, "BHTEL_STATUS": null, "BHTEL_COMPLETEDATE": null, "FACILITIES_STATUS": null, "FACILITIES_COMPLETEDATE": null, "TRAFFIC_STATUS": "Required", "TRAFFIC_COMPLETEDATE": null, "PARKS_STATUS": null, "PARKS_COMPLETEDATE": null, "DEVSERV_STATUS": null, "DEVSERV_COMPLETEDATE": null, "ENBRIDGE_STATUS": null, "ENBRIDGE_COMPLETEDATE": null, "PLAINSMID_STATUS": null, "PLAINSMID_COMPLETEDATE": null, "ROGERS_STATUS": null, "ROGERS_COMPLETEDATE": null, "TELUS_STATUS": null, "TELUS_COMPLETEDATE": null, "UOFR_STATUS": null, "UOFR_COMPLETEDATE": null, "ZAYO_STATUS": "Required", "ZAYO_COMPLETEDATE": null, "ALL_LOCATES_COMPLETEDATE": null, "FIRST_INT_STREET": null, "SECOND_INT_STREET": null, "EMPLOYEE_EMAIL": null, "EMPLOYEE_BRANCH": null, "UTILITY_HIT": "N", "LOCATE_EXPIREDATE": null, "HIGH_VOLTAGE_PRESSURE": "N", "SR_EMAIL_SENT_CLIENT": "N", "SR_INITIALS": null, "LOCATE_PROGRESS_STATUS": null, "SASKENERGY_PERMIT_REQ": "N", "SASKENERGY_PERMIT_NUMBER": null, "WORKORDER": null, "TRANSCANPIPE_STATUS": null, "TRANSCANPIPE_COMPLETEDATE": null, "CUTSIDNUM": null, "CREATE_DATE": null, "DISPATCH_COMMENTS": null, "ORIGINATING_WO": null, "REPAIR_WO_NO_1": null, "EXCAVATION_METHOD": null, "DEPTH_SIZE": null, "ACTIVITY": null, "WORKING_ON": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1 }