Name: MaintenancePRV_History

Display Field: Condition_of_Bolts

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: MaintenancePRV_History
  Description:
  Prototype:
  PilotryReplace: Yes
  ReplacementComment: null
  Condition_of_Bolts: null
  High_Side_Valve_Operational: null
  Low_Side_Valve_Operational: null
  PRV_Status: null
  Sounding_Results: null
  High_Gauge_Port_Flow: null
  Low_Gauge_Port_Flow: null
  High_Side_Control_Port_Flow: null
  Low_Side_Control_Port_Flow: null
  Bonnet_Flush_Flow: null
  Needle_Valve_Clear: null
  Does_PRV_Open: null
  Does_PRV_Close: null
  High_Side_Pressure: null
  Low_Side_Pressure: null
  Activation_Pressure: null
  Ending_PRV_Status: null
  Comments: null
  Needs_Replacement: null
  WorkOrderID: null
  WorkDate: null
  WorkBy: null
  WorkType: PRV Inspection
  AdditionalWorkNeeded: null
  DataValidComment: null
  assetkey: null
  attachmentid1: null
  attachmentid2: null
  PilotryReplaceComment: null
  GUID: null
  additionalwork: null
  UpstreamPSI: null
  DownstreamPSI: null
  DataValid: null
  AdditionalWorkComment: null
  PRV_Full_Close: Yes
  DS_ValveIsolate: null
  PF_HS_Pressure: null
  PF_LS_Pressure: null
  PV_Adjust: Yes
  PV_Adjust_Comment: null
  ReplacementRecomendation: 1
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Update,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Update Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata