Name: MaintenancePRV_History

Display Field: Condition_of_Bolts

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 )
• Condition_of_Bolts ( type: esriFieldTypeString, alias: Condition of Bolts, length: 255 , Coded Values: [Like New: Like New] , [Rusted: Rusted] , [Heavily Rusted: Heavily Rusted] )
• High_Side_Valve_Operational ( type: esriFieldTypeString, alias: High Side Valve Operational, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Low_Side_Valve_Operational ( type: esriFieldTypeString, alias: Low Side Valve Operational, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• PRV_Status ( type: esriFieldTypeString, alias: PRV Status, length: 255 , Coded Values: [Online: Online] , [Offline: Offline] )
• Sounding_Results ( type: esriFieldTypeString, alias: Sounding Results, length: 255 , Coded Values: [Active: Active] , [Quiet: Quiet] )
• High_Gauge_Port_Flow ( type: esriFieldTypeString, alias: High Gauge Port Flow, length: 255 , Coded Values: [Good: Good] , [Bad: Bad] )
• Low_Gauge_Port_Flow ( type: esriFieldTypeString, alias: Low Gauge Port Flow, length: 255 , Coded Values: [Good: Good] , [Bad: Bad] )
• High_Side_Control_Port_Flow ( type: esriFieldTypeString, alias: High Side Control Port Flow, length: 255 , Coded Values: [Good: Good] , [Bad: Bad] )
• Low_Side_Control_Port_Flow ( type: esriFieldTypeString, alias: Low Side Control Port Flow, length: 255 , Coded Values: [Good: Good] , [Bad: Bad] )
• Bonnet_Flush_Flow ( type: esriFieldTypeString, alias: Bonnet Flush Flow, length: 255 , Coded Values: [Good: Good] , [Bad: Bad] )
• Needle_Valve_Clear ( type: esriFieldTypeString, alias: Needle Valve Clear, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Does_PRV_Open ( type: esriFieldTypeString, alias: Does PRV Fully Open, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• Does_PRV_Close ( type: esriFieldTypeString, alias: Does PRV Fully Close, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• High_Side_Pressure ( type: esriFieldTypeInteger, alias: High Side Pressre )
• Low_Side_Pressure ( type: esriFieldTypeInteger, alias: Low Side Pressure )
• Activation_Pressure ( type: esriFieldTypeInteger, alias: Activation Pressure )
• Ending_PRV_Status ( type: esriFieldTypeString, alias: Ending PRV Status, length: 255 , Coded Values: [Online: Online] , [Offline: Offline] )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 255 )
• Needs_Replacement ( type: esriFieldTypeString, alias: Needs Replacement, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• WorkOrderID ( type: esriFieldTypeString, alias: Work Order ID, length: 255 )
• WorkDate ( type: esriFieldTypeDate, alias: Work Date, length: 8 )
• WorkBy ( type: esriFieldTypeString, alias: Work By, length: 255 )
• WorkType ( type: esriFieldTypeString, alias: Work Type, length: 255 )
• AdditionalWorkNeeded ( type: esriFieldTypeString, alias: Additional Work Needed, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• DataValidComment ( type: esriFieldTypeString, alias: Data Valid Comment, length: 255 )
• assetkey ( type: esriFieldTypeString, alias: Asset Key, length: 255 )
• attachmentid1 ( type: esriFieldTypeInteger, alias: attachmentid1 )
• attachmentid2 ( type: esriFieldTypeInteger, alias: attachmentid2 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• GUID ( type: esriFieldTypeGUID, alias: GUID, length: 38 )
• additionalwork ( type: esriFieldTypeString, alias: Additional Work Needed, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• UpstreamPSI ( type: esriFieldTypeInteger, alias: Upstream PSI )
• DownstreamPSI ( type: esriFieldTypeInteger, alias: Downstream PSI )
• DataValid ( type: esriFieldTypeString, alias: Data Valid, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• AdditionalWorkComment ( type: esriFieldTypeString, alias: Additional Work Comment, length: 255 )
• PRV_Full_Close ( type: esriFieldTypeString, alias: PRV_Full_Close, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• DS_ValveIsolate ( type: esriFieldTypeString, alias: DS_ValveIsolate, length: 255 )
• PF_HS_Pressure ( type: esriFieldTypeDouble, alias: PF_HS_Pressure )
• PF_LS_Pressure ( type: esriFieldTypeDouble, alias: PF_LS_Pressure )
• PV_Adjust ( type: esriFieldTypeString, alias: PV_Adjust, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• PV_Adjust_Comment ( type: esriFieldTypeString, alias: PV_Adjust_Comment, length: 255 )
• ReplacementRecomendation ( type: esriFieldTypeInteger, alias: ReplacementRecomendation , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• ReplacementComment ( type: esriFieldTypeString, alias: ReplacementComment, length: 255 )
• PilotryReplace ( type: esriFieldTypeString, alias: PilotryReplace, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Active Work: Active Work] )
• PilotryReplaceComment ( type: esriFieldTypeString, alias: PilotryReplaceComment, length: 255 )

Relationships:

• GIS_PROD.GDB_ADMIN.PRV (2) -- Related To: PRV (45)

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

  Iteminfo   Thumbnail   Metadata