Name: LOCATE_RESUBMIT_HISTORY

Display Field: EMPLOYEENAME

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• EMPLOYEENAME ( type: esriFieldTypeString, alias: Employee Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: EMPLOYEENAME )
• PREVIOUSTICKETNUMBER ( type: esriFieldTypeString, alias: Previous Ticket Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PREVIOUSTICKETNUMBER )
• WORKTYPE ( type: esriFieldTypeString, alias: Work Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: WORKTYPE , Coded Values: [Groundwork: Groundwork] , [Landscaping: Landscaping] , [Poles/Holes: Poles/Holes] , ...3 more... )
• DIG_ALLEY ( type: esriFieldTypeString, alias: Dig in Alley, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_ALLEY , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SIDE ( type: esriFieldTypeString, alias: Dig in Side Yard, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_SIDE , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_STREET ( type: esriFieldTypeString, alias: Dig in Street, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_STREET , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SIDEWALK ( type: esriFieldTypeString, alias: Dig in Sidewalk, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_SIDEWALK , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_SITEMARKED ( type: esriFieldTypeString, alias: Dig in Site marked/staked, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_SITEMARKED , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_FRONTLOT ( type: esriFieldTypeString, alias: Dig in Front Lot, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_FRONTLOT , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_BACKLOT ( type: esriFieldTypeString, alias: Dig in Back Lot, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_BACKLOT , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_CONTRACTTOMEET ( type: esriFieldTypeString, alias: Dig Contract to Meet, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_CONTRACTTOMEET , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• DIG_CALLWHENCOMPLETE ( type: esriFieldTypeString, alias: Call When Dig Complete, editable: true, nullable: true, length: 1, defaultValue: N, modelName: DIG_CALLWHENCOMPLETE , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• EXP_START_DATE ( type: esriFieldTypeDate, alias: Expected Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EXP_START_DATE )
• ADDITIONALINFO ( type: esriFieldTypeString, alias: Additional Information, editable: true, nullable: true, length: 500, defaultValue: null, modelName: ADDITIONALINFO )
• SR_FOR_FACILITIES ( type: esriFieldTypeString, alias: Service Request required for Facilities, editable: true, nullable: true, length: 1, defaultValue: N, modelName: SR_FOR_FACILITIES , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_FOR_IRRIGATION ( type: esriFieldTypeString, alias: Service Request required for Irrigation (Parks), editable: true, nullable: true, length: 1, defaultValue: N, modelName: SR_FOR_IRRIGATION , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• EMPLOYEEPHONENUMBER ( type: esriFieldTypeString, alias: Employee Phone Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EMPLOYEEPHONENUMBER )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• SASK_1ST_CALL ( type: esriFieldTypeString, alias: Sask 1st Confirmation Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SASK_1ST_CALL )
• SASKPOWER_STATUS ( type: esriFieldTypeString, alias: SaskPower Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: SASKPOWER_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKPOWER_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskPower Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SASKPOWER_COMPLETEDATE )
• SASKENERGY_STATUS ( type: esriFieldTypeString, alias: SaskEnergy Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: SASKENERGY_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKENERGY_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskEnergy Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SASKENERGY_COMPLETEDATE )
• SASKTEL_STATUS ( type: esriFieldTypeString, alias: SaskTel Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: SASKTEL_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• SASKTEL_COMPLETEDATE ( type: esriFieldTypeDate, alias: SaskTel Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SASKTEL_COMPLETEDATE )
• ACCESS_STATUS ( type: esriFieldTypeString, alias: Access Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: ACCESS_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ACCESS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Access Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACCESS_COMPLETEDATE )
• BHTEL_STATUS ( type: esriFieldTypeString, alias: BHTel Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: BHTEL_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• BHTEL_COMPLETEDATE ( type: esriFieldTypeDate, alias: BHTel Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: BHTEL_COMPLETEDATE )
• FACILITIES_STATUS ( type: esriFieldTypeString, alias: Facilities Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: FACILITIES_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• FACILITIES_COMPLETEDATE ( type: esriFieldTypeDate, alias: Facilities Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FACILITIES_COMPLETEDATE )
• TRAFFIC_STATUS ( type: esriFieldTypeString, alias: Traffic Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: TRAFFIC_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRAFFIC_COMPLETEDATE ( type: esriFieldTypeDate, alias: Traffic Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TRAFFIC_COMPLETEDATE )
• PARKS_STATUS ( type: esriFieldTypeString, alias: Parks Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PARKS_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PARKS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Parks Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PARKS_COMPLETEDATE )
• DEVSERV_STATUS ( type: esriFieldTypeString, alias: Dev Services Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: DEVSERV_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• DEVSERV_COMPLETEDATE ( type: esriFieldTypeDate, alias: Dev Services Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DEVSERV_COMPLETEDATE )
• ENBRIDGE_STATUS ( type: esriFieldTypeString, alias: Enbridge Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ENBRIDGE_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ENBRIDGE_COMPLETEDATE ( type: esriFieldTypeDate, alias: Enbridge Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ENBRIDGE_COMPLETEDATE )
• PLAINSMID_STATUS ( type: esriFieldTypeString, alias: Plains Midstream Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PLAINSMID_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• PLAINSMID_COMPLETEDATE ( type: esriFieldTypeDate, alias: Plains Midstream Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: PLAINSMID_COMPLETEDATE )
• ROGERS_STATUS ( type: esriFieldTypeString, alias: Rogers Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ROGERS_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ROGERS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Rogers Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ROGERS_COMPLETEDATE )
• TELUS_STATUS ( type: esriFieldTypeString, alias: Telus Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TELUS_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TELUS_COMPLETEDATE ( type: esriFieldTypeDate, alias: Telus Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TELUS_COMPLETEDATE )
• UOFR_STATUS ( type: esriFieldTypeString, alias: U of R Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: UOFR_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• UOFR_COMPLETEDATE ( type: esriFieldTypeDate, alias: U of R Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: UOFR_COMPLETEDATE )
• ZAYO_STATUS ( type: esriFieldTypeString, alias: Zayo Status, editable: true, nullable: true, length: 25, defaultValue: Required, modelName: ZAYO_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• ZAYO_COMPLETEDATE ( type: esriFieldTypeDate, alias: Zayo Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ZAYO_COMPLETEDATE )
• ALL_LOCATES_COMPLETEDATE ( type: esriFieldTypeDate, alias: Locate Request Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ALL_LOCATES_COMPLETEDATE )
• FIRST_INT_STREET ( type: esriFieldTypeString, alias: First Intersecting Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIRST_INT_STREET )
• SECOND_INT_STREET ( type: esriFieldTypeString, alias: Second Intersecting Street, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SECOND_INT_STREET )
• EMPLOYEE_EMAIL ( type: esriFieldTypeString, alias: Employee Email, editable: true, nullable: true, length: 25, defaultValue: null, modelName: EMPLOYEE_EMAIL )
• EMPLOYEE_BRANCH ( type: esriFieldTypeString, alias: Employee Branch, editable: true, nullable: true, length: 255, defaultValue: null, modelName: EMPLOYEE_BRANCH , Coded Values: [Engineering Design Solutions: Engineering Design Solutions] , [Environmental Services: Environmental Services] , [Facilities Management Services: Facilities Management Services] , ...14 more... )
• UTILITY_HIT ( type: esriFieldTypeString, alias: Utility Hit, editable: true, nullable: true, length: 1, defaultValue: N, modelName: UTILITY_HIT , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• LOCATE_EXPIREDATE ( type: esriFieldTypeDate, alias: Locate Expires On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LOCATE_EXPIREDATE )
• HIGH_VOLTAGE_PRESSURE ( type: esriFieldTypeString, alias: High Voltage/High Pressure, editable: true, nullable: true, length: 1, defaultValue: N, modelName: HIGH_VOLTAGE_PRESSURE , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_EMAIL_SENT_CLIENT ( type: esriFieldTypeString, alias: OSR Email sent to Client, editable: true, nullable: true, length: 1, defaultValue: N, modelName: SR_EMAIL_SENT_CLIENT , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SR_INITIALS ( type: esriFieldTypeString, alias: OSR Initials, editable: true, nullable: true, length: 3, defaultValue: null, modelName: SR_INITIALS )
• LOCATE_PROGRESS_STATUS ( type: esriFieldTypeString, alias: Locate Progress Status, editable: true, nullable: true, length: 500, defaultValue: null, modelName: LOCATE_PROGRESS_STATUS )
• SASKENERGY_PERMIT_REQ ( type: esriFieldTypeString, alias: SaskEnergy Permit Required, editable: true, nullable: true, length: 1, defaultValue: N, modelName: SASKENERGY_PERMIT_REQ , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• SASKENERGY_PERMIT_NUMBER ( type: esriFieldTypeString, alias: SaskEnergy Permit Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SASKENERGY_PERMIT_NUMBER )
• WORKORDER ( type: esriFieldTypeString, alias: Workorder Number, editable: true, nullable: true, length: 7, defaultValue: null, modelName: WORKORDER )
• TRANSCANPIPE_STATUS ( type: esriFieldTypeString, alias: TransCanada Pipeline Status, editable: true, nullable: true, length: 25, defaultValue: null, modelName: TRANSCANPIPE_STATUS , Coded Values: [Not Required: Not Required] , [Required: Required] , [Located: Located] , ...1 more... )
• TRANSCANPIPE_COMPLETEDATE ( type: esriFieldTypeDate, alias: TransCanada Pipeline Completed On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: TRANSCANPIPE_COMPLETEDATE )
• CUTSIDNUM ( type: esriFieldTypeDouble, alias: CUTSIDNUM, editable: true, nullable: true, defaultValue: null, modelName: CUTSIDNUM )
• CREATE_DATE ( type: esriFieldTypeDate, alias: Created On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATE_DATE )
• DISPATCH_COMMENTS ( type: esriFieldTypeString, alias: Dispatch Comments, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Dispatch_Comments )
• ORIGINATING_WO ( type: esriFieldTypeString, alias: ORIGINATING_WO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ORIGINATING_WO )
• REPAIR_WO_NO_1 ( type: esriFieldTypeString, alias: REPAIR_WO_NO_1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REPAIR_WO_NO_1 )
• EXCAVATION_METHOD ( type: esriFieldTypeString, alias: Excavation Method, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Excavation_Method , Coded Values: [Hydro Vacuum: Hydro Vacuum] , [None: None] , [Saw Cut: Saw Cut] , ...4 more... )
• DEPTH_SIZE ( type: esriFieldTypeString, alias: Depth Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Depth_Size , Coded Values: [Less than 1 m: Less than 1 m] , [1 m to 3 m: 1 m to 3 m] , [Greater than 3 m: Greater than 3 m] )
• ACTIVITY ( type: esriFieldTypeString, alias: ACTIVITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACTIVITY , Coded Values: [Catch Basin: Catch Basin] , [Hydrant: Hydrant] , [Irrigation: Irrigation] , ...16 more... )
• WORKING_ON ( type: esriFieldTypeString, alias: Working On, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Working_On , Coded Values: [Public Property Only: Public Property Only] , [Public and Private Property: Public and Private Property] )
• SR_PARKS ( type: esriFieldTypeString, alias: Service Request required for Parks, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SR_PARKS , Coded Values: [Y: Yes] , [N: No] , [N/A: N/A] )
• WORKDETAILS ( type: esriFieldTypeString, alias: WORKDETAILS, editable: true, nullable: true, length: 200, defaultValue: null, modelName: WORKDETAILS , Coded Values: [Regular Ticket (up to 1000 sq meters): Regular Ticket (up to 1000 sq meters)] , [Project (1000 sq meters to 60, 000 sq meters): Project (1000 sq meters to 60, 000 sq meters)] , [Large Project (60,000 sq meters to 800,000 sq meters): Large Project (60,000 sq meters to 800,000 sq meters)] , ...4 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: LOCATE_RESUBMIT_HISTORY
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• LocateRequestForm (0) -- Related To: Locate Request Form (0)
• LocateRequestForm (1) -- Related To: New (1)
• LocateRequestForm (2) -- Related To: In Progress (2)
• LocateRequestForm (3) -- Related To: Completed (3)
• LocateRequestForm (4) -- Related To: Expired (4)
• LocateRequestForm (5) -- Related To: Invalid Date (5)
• LocateRequestForm (6) -- Related To: Historic (6)

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata