Name: LOCATE_RESUBMIT_HISTORY

Display Field: EMPLOYEENAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 3000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: null

Fields:

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

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)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata