Name: Water Meter Work Orders

Display Field: AssignedBy

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: 1602051.7606212
YMin: 7205145.19346673
XMax: 1664462.01959972
YMax: 7222626.94994873
Spatial Reference: 102743 (3566)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[169,0,230,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[169,0,230,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: true

Has Attachments: true

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)
• AssignedBy (type: esriFieldTypeString, alias: AssignedBy, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Joanna: Joanna], [Steven: Steven], [Brent: Brent], ... 8 more ...)
• AssignedTo (type: esriFieldTypeString, alias: AssignedTo, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Steven Lord: Steven Lord], [Brent Seamons: Brent Seamons], [Joanna Brunson: Joanna Brunson], ... 9 more ...)
• Priority (type: esriFieldTypeString, alias: Priority, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Normal: Normal Priority], [Medium: Medium Priority], [High: High Priority])
• Category (type: esriFieldTypeString, alias: Category/Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Inspection: Inspection], [NewMeterSet: New meter], [MeterReplacement: Replacement meter], ... 1 more ...)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Complete: Complete], [Incomplete: Incomplete], [Closed: Closed (Office Only)])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• LidCondition (type: esriFieldTypeString, alias: LidCondition, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Missing: The lid is missing], [Broken: The lid is broken], [OK: The lid is in OK Condition], ... 1 more ...)
• Grade (type: esriFieldTypeString, alias: Grade, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [High: High Grade], [Low: Low Grade], [OK: OK Grade], ... 1 more ...)
• Barrel (type: esriFieldTypeString, alias: Barrel, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Clean: The barrel is clean], [Dirty: The barrel is dirty], [Full of Water: The barrel is full of water], ... 2 more ...)
• REL_GLOBALID (type: esriFieldTypeGUID, alias: REL_GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• DateAssigned (type: esriFieldTypeDate, alias: Date Assigned, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateCompleted (type: esriFieldTypeDate, alias: Date Completed, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DateDue (type: esriFieldTypeDate, alias: Date Due, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OldReading (type: esriFieldTypeDouble, alias: OldReading, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TransponderNumber (type: esriFieldTypeString, alias: TransponderNumber, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Resolution (type: esriFieldTypeString, alias: Resolution, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [None: No Work Order needed], [Immediate: Work Order needed Immediately], [Future: Future Work Order needed])
• AdditionalWork (type: esriFieldTypeString, alias: Additional Work, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• TypeOfAdditionalWork (type: esriFieldTypeString, alias: Type of Additional Work, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Inspection: Inspection], [Work Order: Work Order])
• AdditionalWorkWhen (type: esriFieldTypeString, alias: When Additional Work, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true, Coded Values: [Now: Now], [Next Week: Next Week], [Next Month: Next Month])
• 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)
• Work_Order_Instructions (type: esriFieldTypeString, alias: Work Order Instructions, SQL Type: sqlTypeOther, length: 1500, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• Contact_Information (type: esriFieldTypeString, alias: Contact Information, SQL Type: sqlTypeOther, length: 350, nullable: true, editable: true)
• ReviewStatus (type: esriFieldTypeString, alias: Has the work order been reviewed?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])

Templates:

Name: Water Meter Work Orders
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• AdditionalWork: No
• ReviewStatus: No

Relationships:

• (0) -- Related To: Water Meters (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/15/2022 11:44:40 PM

Schema Last Edit Date: 2/15/2022 11:44:40 PM

Data Last Edit Date: 2/15/2022 11:44:40 PM

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