Name: Valve Inspection

Display Field: inspectedby

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)
• inspectedby (type: esriFieldTypeString, alias: Inspected By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• dateinspected (type: esriFieldTypeDate, alias: Date Inspected, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• inspectednumber (type: esriFieldTypeString, alias: Inspected Number, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• systemtype (type: esriFieldTypeSmallInteger, alias: System Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Distribution], [2: Gathering], ... 3 more ...)
• atmoscorrosion (type: esriFieldTypeSmallInteger, alias: Atmospheric Corrosion, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• requirepaint (type: esriFieldTypeSmallInteger, alias: Differential Pressure, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• goodcondition (type: esriFieldTypeSmallInteger, alias: Good Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• requirelubrication (type: esriFieldTypeSmallInteger, alias: Require Lubrication, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• lubricated (type: esriFieldTypeSmallInteger, alias: Lubricated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• tagged (type: esriFieldTypeSmallInteger, alias: Tagged, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• operating (type: esriFieldTypeSmallInteger, alias: Operating, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• secured (type: esriFieldTypeSmallInteger, alias: Secured, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• accessible (type: esriFieldTypeSmallInteger, alias: Accessible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• signs (type: esriFieldTypeSmallInteger, alias: Signs, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• valveboxcond (type: esriFieldTypeSmallInteger, alias: Valve Box Condition, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Good], [2: Fair], ... 1 more ...)
• protectfromdamage (type: esriFieldTypeSmallInteger, alias: Protect From Damage, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• reviewedby (type: esriFieldTypeString, alias: Reviewed By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• revieweddate (type: esriFieldTypeDate, alias: Reviewed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• 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: Valve Inspection
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• atmoscorrosion: 0
• requirepaint: 0
• goodcondition: 0
• requirelubrication: 0
• lubricated: 0
• tagged: 0
• operating: 0
• secured: 0
• accessible: 0
• signs: 0
• valveboxcond: 0
• protectfromdamage: 0

Relationships:

• P_ValveInspection (1) -- Related To: Controllable Valve (200003)

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