Name: ValveHistory

Display Field: assetkey

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

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

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 20 )
• workorderid ( type: esriFieldTypeString, alias: Workorder Key, length: 50 )
• workdate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• workby ( type: esriFieldTypeString, alias: Work By, length: 50 )
• turnstoclose ( type: esriFieldTypeDouble, alias: Turns to Close )
• hightorque ( type: esriFieldTypeSmallInteger, alias: HighTorque )
• worktype ( type: esriFieldTypeString, alias: Work Type, length: 50 , Coded Values: [Valve Maintenance: Valve Maintenance] , [Valve Install/Review/Update: Valve Install/Review/Update] , [Valve Data Update: Valve Data Update] , ...1 more... )
• attachmentid ( type: esriFieldTypeInteger, alias: AttachmentID )
• currentlyopen ( type: esriFieldTypeString, alias: CurrentlyOpen, length: 10 )
• operable ( type: esriFieldTypeString, alias: Operable, length: 10 )
• comments ( type: esriFieldTypeString, alias: Comments, length: 1000 )
• valveboxblown ( type: esriFieldTypeString, alias: Valve Box Blown, length: 50 )
• statusbefore ( type: esriFieldTypeString, alias: Valve Status Before, length: 50 )
• operated ( type: esriFieldTypeString, alias: Valve Operated, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• resistance ( type: esriFieldTypeString, alias: Turn Resistance, length: 50 , Coded Values: [Easy: Easy] , [Average: Average] , [Hard: Hard] , ...1 more... )
• leak ( type: esriFieldTypeString, alias: Leaks Present, length: 50 )
• currentstatus ( type: esriFieldTypeString, alias: Valves Current Status, length: 50 )
• valvebox ( type: esriFieldTypeString, alias: Valve Box Condition, length: 50 , Coded Values: [Good: Good] , [Repairs Made: Repairs Made] )
• nut ( type: esriFieldTypeString, alias: Nut Condition, length: 50 , Coded Values: [Good: Good] , [Fair: Fair] , [Rounded: Rounded] , ...2 more... )
• repairreason ( type: esriFieldTypeString, alias: Repair Reason, length: 250 )
• repairdescription ( type: esriFieldTypeString, alias: Repair Description, length: 250 , Coded Values: [Valve Replace: Valve Replace] , [Valve Box Reset-Replace: Vavle Box Reset-Replace] , [Valve Nut Missing/Rounded: Valve Nut Missing/Rounded] , ...2 more... )
• attachmentid2 ( type: esriFieldTypeInteger, alias: AttachmentID )
• surface ( type: esriFieldTypeString, alias: Surface, length: 50 )
• debris ( type: esriFieldTypeString, alias: Open Direction, length: 50 )
• nutcomment ( type: esriFieldTypeString, alias: Debris, length: 200 )
• sounded ( type: esriFieldTypeString, alias: Nut Comment, length: 50 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• resistancecomment ( type: esriFieldTypeString, alias: Sounded, length: 200 )
• otherissue ( type: esriFieldTypeString, alias: Resistance Comment, length: 200 )
• additionalwork ( type: esriFieldTypeString, alias: Other Issue, length: 50 , Coded Values: [No: No] , [Valve Replace: Valve Replace] , [Valve Box Replace: Valve Box Replace] , ...2 more... )
• reviewneeded ( type: esriFieldTypeString, alias: Status Returned, length: 10 )
• valvecondition ( type: esriFieldTypeString, alias: Valve Condition, length: 50 )
• MeasureDown ( type: esriFieldTypeDouble, alias: MeasureDown )
• DataValidComment ( type: esriFieldTypeString, alias: Data Valid Comment, length: 255 )
• AttachmentID3 ( type: esriFieldTypeInteger, alias: AttachmentID3 )
• WorkingHours ( type: esriFieldTypeInteger, alias: WorkingHours )
• Man_Hours_Breakdown ( type: esriFieldTypeString, alias: Man_Hours_Breakdown, length: 500 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• assetkey2 ( type: esriFieldTypeString, alias: assetkey2, length: 255 )
• DataValid_Comment ( type: esriFieldTypeString, alias: Data Valid Comment, length: 255 )
• DataValid ( type: esriFieldTypeString, alias: Data Valid, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• commentaddwork ( type: esriFieldTypeString, alias: Additional Work Comment, length: 255 )
• outofservice ( type: esriFieldTypeString, alias: Out of Service, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )

Relationships:

• GIS_PROD.GDB_ADMIN.wValves (0) -- Related To: Valves (0)

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

  Iteminfo   Thumbnail   Metadata