Name: Regulator Inspect

Display Field: manufacturer

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [American: American], [Fisher: Fisher], ... 7 more ...)
• manufacturemodel (type: esriFieldTypeString, alias: Manufacturer Model, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Other: Other])
• regulatortype (type: esriFieldTypeString, alias: Regulator Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Controller: Controller], [Monitor: Monitor])
• regulatordiameter (type: esriFieldTypeDouble, alias: Regulator Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.25: 1/4], [0.375: 3/8], ... 43 more ...)
• regulatorconnection (type: esriFieldTypeString, alias: Regulator Connection, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Thread: Thread], [Flange: Flange], ... 2 more ...)
• pressurerating (type: esriFieldTypeInteger, alias: Pressure Rating, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pressureunits (type: esriFieldTypeSmallInteger, alias: Pressure Units, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [231: Pounds/Square Inch], [232: Inch Water Column])
• pilotmake (type: esriFieldTypeInteger, alias: Pilot Make, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pilotconnectiontype (type: esriFieldTypeString, alias: Pilot Connect Type, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Screw: Screw], [Flange: Flange])
• flow (type: esriFieldTypeString, alias: Flow, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [Upstream: Upstream], [Downstream: Downstream])
• intermediatepressure (type: esriFieldTypeInteger, alias: Intermediate Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• outletpressure (type: esriFieldTypeInteger, alias: Outlet Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• maxinletpressure (type: esriFieldTypeInteger, alias: Max Inlet Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• minoutletpressure (type: esriFieldTypeInteger, alias: Min Outlet Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true)
• internalinspection (type: esriFieldTypeSmallInteger, alias: Internal Inspection, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• innervalve (type: esriFieldTypeSmallInteger, alias: Inner Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• innervalvediameter (type: esriFieldTypeDouble, alias: Inner Valve Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [0.25: 1/4], [0.375: 3/8], ... 43 more ...)
• internallockup (type: esriFieldTypeSmallInteger, alias: Internal Lockup, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internalsetpressure (type: esriFieldTypeSmallInteger, alias: Internal Set Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internaldiaphragmposition (type: esriFieldTypeSmallInteger, alias: Internal Diaphragm Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internalventposition (type: esriFieldTypeSmallInteger, alias: Internal Vent Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internalpilots (type: esriFieldTypeSmallInteger, alias: Internal Pilots, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internalcontrollinesclear (type: esriFieldTypeSmallInteger, alias: Internal Control Lines Clear, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• internalvalvessecured (type: esriFieldTypeSmallInteger, alias: Internal Valve Secured, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Pass], [2: Fail], ... 1 more ...)
• comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• updmdevice_globalid (type: esriFieldTypeGUID, alias: UPDMDevice GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (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)

Templates:

Name: Regulator Inspect
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• pressureunits: 231
• internalinspection: 0
• innervalve: 0
• internallockup: 0
• internalsetpressure: 0
• internaldiaphragmposition: 0
• internalventposition: 0
• internalpilots: 0
• internalcontrollinesclear: 0
• internalvalvessecured: 0

Relationships:

• P_RegulatorInspect (2) -- Related To: Regulator (200019)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/19/2021 9:28:30 PM

Schema Last Edit Date: 1/19/2021 9:28:30 PM

Data Last Edit Date: 1/19/2021 9:28:30 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Boxplots   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat