{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 8, "name": "LOCATE_RESUBMIT_HISTORY", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "EMPLOYEENAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "EMPLOYEENAME", "type": "esriFieldTypeString", "alias": "Employee Name", "length": 100, "domain": null }, { "name": "PREVIOUSTICKETNUMBER", "type": "esriFieldTypeString", "alias": "Previous Ticket Number", "length": 25, "domain": null }, { "name": "WORKTYPE", "type": "esriFieldTypeString", "alias": "Work Type", "length": 25, "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" } }, { "name": "DIG_ALLEY", "type": "esriFieldTypeString", "alias": "Dig in Alley", "length": 1, "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" } }, { "name": "DIG_SIDE", "type": "esriFieldTypeString", "alias": "Dig in Side Yard", "length": 1, "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" } }, { "name": "DIG_STREET", "type": "esriFieldTypeString", "alias": "Dig in Street", "length": 1, "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" } }, { "name": "DIG_SIDEWALK", "type": "esriFieldTypeString", "alias": "Dig in Sidewalk", "length": 1, "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" } }, { "name": "DIG_SITEMARKED", "type": "esriFieldTypeString", "alias": "Dig in Site marked/staked", "length": 1, "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" } }, { "name": "DIG_FRONTLOT", "type": "esriFieldTypeString", "alias": "Dig in Front Lot", "length": 1, "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" } }, { "name": "DIG_BACKLOT", "type": "esriFieldTypeString", "alias": "Dig in Back Lot", "length": 1, "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" } }, { "name": "DIG_CONTRACTTOMEET", "type": "esriFieldTypeString", "alias": "Dig Contract to Meet", "length": 1, "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" } }, { "name": "DIG_CALLWHENCOMPLETE", "type": "esriFieldTypeString", "alias": "Call When Dig Complete", "length": 1, "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" } }, { "name": "EXP_START_DATE", "type": "esriFieldTypeDate", "alias": "Expected Start Date", "length": 8, "domain": null }, { "name": "ADDITIONALINFO", "type": "esriFieldTypeString", "alias": "Additional Information", "length": 500, "domain": null }, { "name": "SR_FOR_FACILITIES", "type": "esriFieldTypeString", "alias": "Service Request required for Facilities", "length": 1, "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" } }, { "name": "SR_FOR_IRRIGATION", "type": "esriFieldTypeString", "alias": "Service Request required for Irrigation (Parks)", "length": 1, "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" } }, { "name": "EMPLOYEEPHONENUMBER", "type": "esriFieldTypeString", "alias": "Employee Phone Number", "length": 20, "domain": null }, { "name": "ADDRESS", "type": "esriFieldTypeString", "alias": "Address", "length": 100, "domain": null }, { "name": "SASK_1ST_CALL", "type": "esriFieldTypeString", "alias": "Sask 1st Confirmation Number", "length": 50, "domain": null }, { "name": "SASKPOWER_STATUS", "type": "esriFieldTypeString", "alias": "SaskPower Status", "length": 25, "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" } }, { "name": "SASKPOWER_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskPower Completed On", "length": 8, "domain": null }, { "name": "SASKENERGY_STATUS", "type": "esriFieldTypeString", "alias": "SaskEnergy Status", "length": 25, "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" } }, { "name": "SASKENERGY_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskEnergy Completed On", "length": 8, "domain": null }, { "name": "SASKTEL_STATUS", "type": "esriFieldTypeString", "alias": "SaskTel Status", "length": 25, "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" } }, { "name": "SASKTEL_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "SaskTel Completed On", "length": 8, "domain": null }, { "name": "ACCESS_STATUS", "type": "esriFieldTypeString", "alias": "Access Status", "length": 25, "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" } }, { "name": "ACCESS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Access Completed On", "length": 8, "domain": null }, { "name": "BHTEL_STATUS", "type": "esriFieldTypeString", "alias": "BHTel Status", "length": 25, "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" } }, { "name": "BHTEL_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "BHTel Completed On", "length": 8, "domain": null }, { "name": "FACILITIES_STATUS", "type": "esriFieldTypeString", "alias": "Facilities Status", "length": 25, "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" } }, { "name": "FACILITIES_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Facilities Completed On", "length": 8, "domain": null }, { "name": "TRAFFIC_STATUS", "type": "esriFieldTypeString", "alias": "Traffic Status", "length": 25, "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" } }, { "name": "TRAFFIC_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Traffic Completed On", "length": 8, "domain": null }, { "name": "PARKS_STATUS", "type": "esriFieldTypeString", "alias": "Parks Status", "length": 25, "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" } }, { "name": "PARKS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Parks Completed On", "length": 8, "domain": null }, { "name": "DEVSERV_STATUS", "type": "esriFieldTypeString", "alias": "Dev Services Status", "length": 25, "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" } }, { "name": "DEVSERV_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Dev Services Completed On", "length": 8, "domain": null }, { "name": "ENBRIDGE_STATUS", "type": "esriFieldTypeString", "alias": "Enbridge Status", "length": 25, "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" } }, { "name": "ENBRIDGE_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Enbridge Completed On", "length": 8, "domain": null }, { "name": "PLAINSMID_STATUS", "type": "esriFieldTypeString", "alias": "Plains Midstream Status", "length": 25, "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" } }, { "name": "PLAINSMID_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Plains Midstream Completed On", "length": 8, "domain": null }, { "name": "ROGERS_STATUS", "type": "esriFieldTypeString", "alias": "Rogers Status", "length": 25, "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" } }, { "name": "ROGERS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Rogers Completed On", "length": 8, "domain": null }, { "name": "TELUS_STATUS", "type": "esriFieldTypeString", "alias": "Telus Status", "length": 25, "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" } }, { "name": "TELUS_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Telus Completed On", "length": 8, "domain": null }, { "name": "UOFR_STATUS", "type": "esriFieldTypeString", "alias": "U of R Status", "length": 25, "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" } }, { "name": "UOFR_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "U of R Completed On", "length": 8, "domain": null }, { "name": "ZAYO_STATUS", "type": "esriFieldTypeString", "alias": "Zayo Status", "length": 25, "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" } }, { "name": "ZAYO_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Zayo Completed On", "length": 8, "domain": null }, { "name": "ALL_LOCATES_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "Locate Request Completed On", "length": 8, "domain": null }, { "name": "FIRST_INT_STREET", "type": "esriFieldTypeString", "alias": "First Intersecting Street", "length": 100, "domain": null }, { "name": "SECOND_INT_STREET", "type": "esriFieldTypeString", "alias": "Second Intersecting Street", "length": 100, "domain": null }, { "name": "EMPLOYEE_EMAIL", "type": "esriFieldTypeString", "alias": "Employee Email", "length": 25, "domain": null }, { "name": "EMPLOYEE_BRANCH", "type": "esriFieldTypeString", "alias": "Employee Branch", "length": 255, "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" } }, { "name": "UTILITY_HIT", "type": "esriFieldTypeString", "alias": "Utility Hit", "length": 1, "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" } }, { "name": "LOCATE_EXPIREDATE", "type": "esriFieldTypeDate", "alias": "Locate Expires On", "length": 8, "domain": null }, { "name": "HIGH_VOLTAGE_PRESSURE", "type": "esriFieldTypeString", "alias": "High Voltage/High Pressure", "length": 1, "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" } }, { "name": "SR_EMAIL_SENT_CLIENT", "type": "esriFieldTypeString", "alias": "OSR Email sent to Client", "length": 1, "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" } }, { "name": "SR_INITIALS", "type": "esriFieldTypeString", "alias": "OSR Initials", "length": 3, "domain": null }, { "name": "LOCATE_PROGRESS_STATUS", "type": "esriFieldTypeString", "alias": "Locate Progress Status", "length": 500, "domain": null }, { "name": "SASKENERGY_PERMIT_REQ", "type": "esriFieldTypeString", "alias": "SaskEnergy Permit Required", "length": 1, "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" } }, { "name": "SASKENERGY_PERMIT_NUMBER", "type": "esriFieldTypeString", "alias": "SaskEnergy Permit Number", "length": 25, "domain": null }, { "name": "WORKORDER", "type": "esriFieldTypeString", "alias": "Workorder Number", "length": 7, "domain": null }, { "name": "TRANSCANPIPE_STATUS", "type": "esriFieldTypeString", "alias": "TransCanada Pipeline Status", "length": 25, "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" } }, { "name": "TRANSCANPIPE_COMPLETEDATE", "type": "esriFieldTypeDate", "alias": "TransCanada Pipeline Completed On", "length": 8, "domain": null }, { "name": "CUTSIDNUM", "type": "esriFieldTypeDouble", "alias": "CUTSIDNUM", "domain": null }, { "name": "CREATE_DATE", "type": "esriFieldTypeDate", "alias": "Created On", "length": 8, "domain": null }, { "name": "DISPATCH_COMMENTS", "type": "esriFieldTypeString", "alias": "Dispatch Comments", "length": 50, "domain": null }, { "name": "ORIGINATING_WO", "type": "esriFieldTypeString", "alias": "ORIGINATING_WO", "length": 50, "domain": null }, { "name": "REPAIR_WO_NO_1", "type": "esriFieldTypeString", "alias": "REPAIR_WO_NO_1", "length": 50, "domain": null }, { "name": "EXCAVATION_METHOD", "type": "esriFieldTypeString", "alias": "Excavation Method", "length": 50, "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" } }, { "name": "DEPTH_SIZE", "type": "esriFieldTypeString", "alias": "Depth Size", "length": 50, "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" } }, { "name": "ACTIVITY", "type": "esriFieldTypeString", "alias": "ACTIVITY", "length": 50, "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" } }, { "name": "WORKING_ON", "type": "esriFieldTypeString", "alias": "Working On", "length": 50, "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" } }, { "name": "SR_PARKS", "type": "esriFieldTypeString", "alias": "Service Request required for Parks", "length": 50, "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" } }, { "name": "WORKDETAILS", "type": "esriFieldTypeString", "alias": "WORKDETAILS", "length": 200, "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" } }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R2021505_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_2021505", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "LocateRequestForm", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "LocateRequestForm", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "LocateRequestForm", "relatedTableId": 2, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 3, "name": "LocateRequestForm", "relatedTableId": 3, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 4, "name": "LocateRequestForm", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 5, "name": "LocateRequestForm", "relatedTableId": 5, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 6, "name": "LocateRequestForm", "relatedTableId": 6, "role": "esriRelRoleDestination", "keyField": "CUTSIDNUM", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 3000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": false, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": { "timeZone": "Canada Central Standard Time", "respectsDaylightSaving": false }, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 } }