Name: WorkOrder

Display Field: WORK_REQUEST_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -17790916.542252
YMin: -37052023.3913654
XMax: 19103249.8751582
YMax: 23980683.2663408
Spatial Reference: 102658 (2236)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"color":[35,42,163,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,0,0,255],"width":0.7,"type":"esriSLS","style":"esriSLSSolid"}}},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• WORK_REQUEST_NUMBER (type: esriFieldTypeString, alias: Work Request Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MONTH (type: esriFieldTypeString, alias: Month, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [January: January], [February: February], [March: March], ... 9 more ...)
• YEAR (type: esriFieldTypeString, alias: Year, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CITY (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Cayce: Cayce], [Columbia: Columbia], [Gaston: Gaston], ... 6 more ...)
• STATE (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: Zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [29033: 29033], [29053: 29053], [29061: 29061], ... 11 more ...)
• ADDRESS (type: esriFieldTypeString, alias: Confirmed Address (if different from original), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• LOCATION (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• NORTHING (type: esriFieldTypeString, alias: Northing, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EASTING (type: esriFieldTypeString, alias: Easting, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WORK_ORDER_TYPE (type: esriFieldTypeString, alias: Work Order Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Electrical: Electrical], [Miscellaneous: Miscellaneous], [Pump Maintenance: Pump Maintenance], ... 2 more ...)
• URGENCY (type: esriFieldTypeString, alias: Urgency, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [ASAP: ASAP], [Routine: Routine], [Urgent: Urgent])
• REQUESTED_BY (type: esriFieldTypeString, alias: Requested By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DEPARTMENT_COMPANY (type: esriFieldTypeString, alias: Department or Company, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CONTACT_PHONE_1 (type: esriFieldTypeString, alias: Contact Phone Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• CONTACT_PHONE_2 (type: esriFieldTypeString, alias: Contact Secondary Number, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• EMAIL_ADDRESS (type: esriFieldTypeString, alias: Contact Email Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PROBLEM (type: esriFieldTypeString, alias: Problem, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Elder Valve Installation: Elder Valve Installation], [Electrician Call: Electrician Call], [Irrigation Tap: Irrigation Tap], ... 12 more ...)
• PROBLEM_NOTES (type: esriFieldTypeString, alias: Problem Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• EMPLOYEE_ASSIGNED (type: esriFieldTypeString, alias: Employee Assigned, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alfred Brown: Alfred Brown], [Gary Bush: Gary Bush], [Glendon Butler: Glendon Butler], ... 25 more ...)
• TRUCK_NUMBER (type: esriFieldTypeString, alias: Truck Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• LABOR_HOURS_USED (type: esriFieldTypeSingle, alias: Labor Hours Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EQUIPMENT_HOURS_USED (type: esriFieldTypeSingle, alias: Equipment Hours Used, SQL Type: sqlTypeOther, nullable: true, editable: true)
• MATERIALS_USED (type: esriFieldTypeString, alias: Materials Used, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INVENTORY_TABLE_ID (type: esriFieldTypeString, alias: Inventory Table ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• INSTALLATION_REQUIRED (type: esriFieldTypeString, alias: Installation Required?, SQL Type: sqlTypeOther, length: 3, nullable: false, editable: true, Coded Values: [yes: Yes], [no: No])
• INSTALLATION_TYPE (type: esriFieldTypeString, alias: Installation Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Elder Valve Installation: Elder Valve Installation], [Commercial Meter Installation: Commercial Meter Installation], [Commercial/Irrigation Meter Installation: Commercial/Irrigation Meter Installation], ... 2 more ...)
• INSTALLATION_NOTES (type: esriFieldTypeString, alias: Installation Notes, SQL Type: sqlTypeOther, length: 400, nullable: true, editable: true)
• LOCATOR_TICKET_REQUIRED (type: esriFieldTypeString, alias: Locator Ticket Required?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [yes: Yes], [no: No])
• LOCATOR_TICKET_NOTES (type: esriFieldTypeString, alias: Locator Ticket Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FINDINGS_1 (type: esriFieldTypeString, alias: Findings, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Full Collapse: Full Collapse], [Grease Ball: Grease Ball], [Hole in Line: Hole in Line], ... 6 more ...)
• FINDINGS_1_NOTES (type: esriFieldTypeString, alias: Findings Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FINDINGS_2 (type: esriFieldTypeString, alias: Secondary Findings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Full Collapse: Full Collapse], [Grease Ball: Grease Ball], [Hole in Line: Hole in Line], ... 6 more ...)
• FINDINGS_2_NOTES (type: esriFieldTypeString, alias: Secondary Findings Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FINDINGS_3 (type: esriFieldTypeString, alias: Third Findings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Full Collapse: Full Collapse], [Grease Ball: Grease Ball], [Hole in Line: Hole in Line], ... 6 more ...)
• FINDINGS_3_NOTES (type: esriFieldTypeString, alias: Third Findings Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FINDINGS_4 (type: esriFieldTypeString, alias: Fourth Findings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Full Collapse: Full Collapse], [Grease Ball: Grease Ball], [Hole in Line: Hole in Line], ... 6 more ...)
• FINDINGS_4_NOTES (type: esriFieldTypeString, alias: Fourth Findings Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• FINDINGS_GENERAL (type: esriFieldTypeString, alias: Additional Findings Information, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SANITARY_SEWER_OVERFLOW (type: esriFieldTypeString, alias: Sanitary Sewer Overflow, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• SSO_RECORDED_WITH_DHEC (type: esriFieldTypeString, alias: SSO Recorded with DHEC, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• SSO_5000_GAL_PLUS (type: esriFieldTypeString, alias: SSO 5000 gal. plus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• DATE_AND_TIME_ISSUED (type: esriFieldTypeDate, alias: Date and Time Issued, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_DUE (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_AND_TIME_ARRIVED (type: esriFieldTypeDate, alias: Date and Time Arrived, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_AND_TIME_COMPLETED (type: esriFieldTypeDate, alias: Date and Time Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OPERATOR_CONFIRMATION (type: esriFieldTypeString, alias: Operator Confirmation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• DISPATCHER_CONFIRMATION (type: esriFieldTypeString, alias: Dispatcher Confirmation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [Needs Updating: Needs Updating])
• COMPLETION_NOTES (type: esriFieldTypeString, alias: Completion Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• OVERDUE (type: esriFieldTypeString, alias: Overdue, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• AdditionalEmployees (type: esriFieldTypeString, alias: Additional Employees, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: WorkOrder
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• MONTH: May
• YEAR: 2020
• CITY: Cayce
• STATE: SC
• INSTALLATION_REQUIRED: no

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/17/2023 6:36:43 AM

Schema Last Edit Date: 11/17/2023 6:36:43 AM

Data Last Edit Date: 11/17/2023 6:36:42 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat