All Layers and Tables (Water/wSystemValveCondition

Tables:

Table: System Valve Inspection (1)

Name:

Display Field:

Type:

Geometry Type:

Description:

Service Item Id:

Copyright Text:

Default Visibility: false

MaxRecordCount:

Supported Query Formats:

Supports Advanced Queries:

Supports Statistics:

Use Standardized Queries:

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

HasZ: false

HasM: false

Has Attachments:

HTML Popup Type:

Type ID Field:

Fields:

SDELOADER.Infrastructure_wSystemValveInspection.OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
SDELOADER.Infrastructure_wSystemValveInspection.INSSTART ( type: esriFieldTypeDate, alias: Start DateTime, length: 8 )
SDELOADER.Infrastructure_wSystemValveInspection.VALVECOND ( type: esriFieldTypeString, alias: Valve Condition, length: 50 , Coded Values: [New: New] , [Good: Good] , [Fair: Fair] , ...2 more... )
SDELOADER.Infrastructure_wSystemValveInspection.TURNHARD ( type: esriFieldTypeSmallInteger, alias: Hard to Turn , Coded Values: [0: False] , [1: True] )
SDELOADER.Infrastructure_wSystemValveInspection.OPERABLE ( type: esriFieldTypeSmallInteger, alias: Operable , Coded Values: [0: False] , [1: True] )
SDELOADER.Infrastructure_wSystemValveInspection.PAVED ( type: esriFieldTypeSmallInteger, alias: Paved Over , Coded Values: [0: False] , [1: True] )
SDELOADER.Infrastructure_wSystemValveInspection.CORRODED ( type: esriFieldTypeSmallInteger, alias: Corroded , Coded Values: [0: False] , [1: True] )
SDELOADER.Infrastructure_wSystemValveInspection.GSURFACE ( type: esriFieldTypeString, alias: Ground Surface, length: 50 , Coded Values: [Asphalt: Asphalt] , [Brick: Brick] , [Concrete: Concrete] , ...5 more... )
SDELOADER.Infrastructure_wSystemValveInspection.FINTORQUE ( type: esriFieldTypeInteger, alias: Final Torque (Ft Pounds) )
SDELOADER.Infrastructure_wSystemValveInspection.DEPTHTONUT ( type: esriFieldTypeDouble, alias: Depth To Nut (Feet) )
SDELOADER.Infrastructure_wSystemValveInspection.MAINTNEED ( type: esriFieldTypeString, alias: Maintenance Needed, length: 255 )
SDELOADER.Infrastructure_wSystemValveInspection.NOTES ( type: esriFieldTypeString, alias: Notes, length: 255 )
SDELOADER.Infrastructure_wSystemValveInspection.INSEND ( type: esriFieldTypeDate, alias: End DateTime, length: 8 )
SDELOADER.Infrastructure_wSystemValveInspection.WORKKEY ( type: esriFieldTypeString, alias: Workorder ID, length: 50 )
SDELOADER.Infrastructure_wSystemValveInspection.INSPECTID ( type: esriFieldTypeString, alias: Inspection ID, length: 50 )
SDELOADER.Infrastructure_wSystemValveInspection.FACILITYKEY ( type: esriFieldTypeString, alias: Facility ID, length: 50 )
SDELOADER.Infrastructure_wSystemValveInspection.INSPECTOR ( type: esriFieldTypeString, alias: Inspection User, length: 50 )
SDELOADER.Infrastructure_wSystemValveInspection.INSSTATUS ( type: esriFieldTypeString, alias: Inspection Status, length: 20 , Coded Values: [Unassigned: Unassigned] , [Assigned: Assigned] , [In Progress: In Progress] , ...1 more... )
SDELOADER.Infrastructure_wSystemValveInspection.ROTATION ( type: esriFieldTypeDouble, alias: Rotation )
SDELOADER.Infrastructure_wSystemValveInspection.LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, length: 8 )
SDELOADER.Infrastructure_wSystemValveInspection.LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
SDELOADER.Infrastructure_wSystemValveInspection.GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
SDELOADER.Infrastructure_wSystemValveInspection.created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
SDELOADER.Infrastructure_wSystemValveInspection.created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
SDELOADER.Infrastructure_wSystemValveInspection.last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
SDELOADER.Infrastructure_wSystemValveInspection.last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
SDELOADER.Infrastructure_wSystemValveInspection.VALVEFUNCTION ( type: esriFieldTypeString, alias: Valve Function, length: 50 , Coded Values: [ML: Main Line] , [FS: Fire Service] , [HYD: Hydrant] )
SDELOADER.Infrastructure_wSystemValveInspection.BOXCOND ( type: esriFieldTypeString, alias: Valve Box Condition, length: 50 , Coded Values: [Replace: Replace] , [Repair: Repair] , [Other: Other] , ...1 more... )
SDELOADER.Infrastructure_wSystemValveInspection.DIAMETER ( type: esriFieldTypeDouble, alias: Valve Diameter , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...32 more... )
SDELOADER.Infrastructure_wSystemValveInspection.LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 255 )
SDELOADER.Infrastructure_wSystemValveInspection.VALVEFOUNDOP ( type: esriFieldTypeString, alias: Valve Discovered Open?, length: 50 , Coded Values: [Yes: Yes] , [No: No] )
SDELOADER.Infrastructure_wSystemValveInspection.TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: Turns to Close )
SDELOADER.Infrastructure_wSystemValveInspection.VALVEDIRECTION ( type: esriFieldTypeString, alias: Direction to Close, length: 50 , Coded Values: [RHV: Right Hand To Close] , [LHV: Left Hand to Close] , [UNK: Unknown] )
SDELOADER.Infrastructure_wSystemValveInspection.ValveShutdown ( type: esriFieldTypeString, alias: Does valve get positive shutdown?, length: 50 , Coded Values: [1: Good - Valve shuts down successfully] , [2: Fair - Valve partially shuts down] , [3: Poor - Valve does not shut down, needs attention] , ...1 more... )
SDELOADER.Infrastructure_wSystemValveInspection.ASSETID ( type: esriFieldTypeString, alias: Asset ID, length: 20 )
SDELOADER.Infrastructure_wSystemValveInspection.Valve_GlobalID ( type: esriFieldTypeGUID, alias: Valve_GlobalID, length: 38 )
SDELOADER.Infrastructure_wSystemValveInspection.NUTTYPE ( type: esriFieldTypeString, alias: NUTTYPE, length: 255 , Coded Values: [2: 2" Square Nut] , [WHEEL: Wheel Valve] , [Other: Other (Noted elsewhere)] )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.ATTACHMENTID ( type: esriFieldTypeInteger, alias: ATTACHMENTID )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.CONTENT_TYPE ( type: esriFieldTypeString, alias: CONTENT_TYPE, length: 150 )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.ATT_NAME ( type: esriFieldTypeString, alias: ATT_NAME, length: 250 )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.DATA_SIZE ( type: esriFieldTypeInteger, alias: DATA_SIZE )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.DATA ( type: esriFieldTypeBlob, alias: DATA )
SDELOADER.Infrastructure_wSystemValveInspection__ATTACH.GLOBALID ( type: esriFieldTypeGUID, alias: GLOBALID, length: 38 )

Table: btvgis.SDELOADER.Infrastructure_wSystemValveInspection__ATTACH (2)