Name: QBYTESTHYDRELCLASS.DBO.testreltable

Display Field: Manname

Type: Table

Geometry Type: N/A

Description: null

Definition Expression: N/A

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, AMF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID , alias: OBJECTID )
• Manufacturer ( type: esriFieldTypeString , alias: Manufacturer , length: 50 , Coded Values: [Eddy: Eddy] , [Ludlow: Ludlow] , [Mueller Sup: Mueller Sup] , ...5 more... )
• Year ( type: esriFieldTypeInteger , alias: Year , Range: [1800, 2100] )
• Location ( type: esriFieldTypeString , alias: Location , length: 50 )
• Staked ( type: esriFieldTypeString , alias: Staked , length: 50 , Coded Values: [Fiberglass: Fiberglass] , [Wood: Wood] , [Removed: Removed] )
• Plowed ( type: esriFieldTypeString , alias: Plowed , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Frozen ( type: esriFieldTypeString , alias: Frozen , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• GlobalID ( type: esriFieldTypeGlobalID , alias: GlobalID , length: 38 )
• created_user ( type: esriFieldTypeString , alias: created_user , length: 255 , Coded Values: [Vance Plant: Vance Plant] , [Gary Schierloh: Gary Schierloh] , [Steve Burch: Steve Burch] , ...3 more... )
• created_date ( type: esriFieldTypeDate , alias: created_date , length: 36 )
• last_edited_user ( type: esriFieldTypeString , alias: last_edited_user , length: 255 , Coded Values: [Vance Plant: Vance Plant] , [Gary Schierloh: Gary Schierloh] , [Steve Burch: Steve Burch] , ...3 more... )
• last_edited_date ( type: esriFieldTypeDate , alias: last_edited_date , length: 36 )
• Inspector ( type: esriFieldTypeString , alias: Inspector , length: 50 , Coded Values: [Vance Plant: Vance Plant] , [Gary Schierloh: Gary Schierloh] , [Steve Burch: Steve Burch] , ...3 more... )
• Pressure_Tested ( type: esriFieldTypeString , alias: Pressure_Tested , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Oil_Level ( type: esriFieldTypeString , alias: Oil_Level , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Check_Grease ( type: esriFieldTypeString , alias: Check_Grease , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Threads_Serviced ( type: esriFieldTypeString , alias: Threads_Serviced , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Packing_Tightened ( type: esriFieldTypeString , alias: Packing_Tightened , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Branch_Valve ( type: esriFieldTypeString , alias: Branch_Valve , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Hydrant_Num_OK ( type: esriFieldTypeString , alias: Hydrant_Num_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Location_Noted ( type: esriFieldTypeString , alias: Location_Noted , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Straight_to_Road ( type: esriFieldTypeString , alias: Straight_to_Road , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• PSI ( type: esriFieldTypeSmallInteger , alias: PSI , Range: [10, 1000] )
• Steamer_Thread ( type: esriFieldTypeString , alias: Steamer_Thread , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Hydrant_Work ( type: esriFieldTypeString , alias: Hydrant_Work , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Branch_Valve_Loc ( type: esriFieldTypeString , alias: Branch_Valve_Loc , length: 50 , Coded Values: [High: High] , [Low: Low] , [Straight: Straight] )
• Highway_Yellow_Cap ( type: esriFieldTypeString , alias: Highway_Yellow_Cap , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Plugged_Drip ( type: esriFieldTypeString , alias: Plugged_Drip , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Caps_Pentagon ( type: esriFieldTypeString , alias: Caps_Pentagon , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Leading_OK ( type: esriFieldTypeString , alias: Leading_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Hydrant_Needs ( type: esriFieldTypeString , alias: Hydrant_Needs , length: 150 )
• Remarks ( type: esriFieldTypeString , alias: Remarks , length: 150 )
• Height_OK ( type: esriFieldTypeString , alias: Height_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Vert_OK ( type: esriFieldTypeString , alias: Vert_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Paint_OK ( type: esriFieldTypeString , alias: Paint_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Caps_OK ( type: esriFieldTypeString , alias: Caps_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Nozzles_OK ( type: esriFieldTypeString , alias: Nozzles_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Opnut_OK ( type: esriFieldTypeString , alias: Opnut_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Barrels_OK ( type: esriFieldTypeString , alias: Barrels_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Mainvalve_OK ( type: esriFieldTypeString , alias: Mainvalve_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Drainvalve_OK ( type: esriFieldTypeString , alias: Drainvalve_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Branchvalve_OK ( type: esriFieldTypeString , alias: Branchvalve_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Orings_OK ( type: esriFieldTypeString , alias: Orings_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Packing_OK ( type: esriFieldTypeString , alias: Packing_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Reflecpaint_OK ( type: esriFieldTypeString , alias: Reflecpaint_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Pumped_OK ( type: esriFieldTypeString , alias: Pumped_OK , length: 50 , Coded Values: [Yes: Yes] , [No: No] )
• Inspector_Hrs ( type: esriFieldTypeInteger , alias: Inspector_Hrs , Range: [0, 10] )
• Inspector_OT ( type: esriFieldTypeInteger , alias: Inspector_OT )
• Equip ( type: esriFieldTypeString , alias: Equip , length: 50 , Coded Values: [02-3: 02-3] )
• Inspector_Add ( type: esriFieldTypeString , alias: Inspector_Add , length: 50 , Coded Values: [Vance Plant: Vance Plant] , [Gary Schierloh: Gary Schierloh] , [Steve Burch: Steve Burch] , ...3 more... )
• inspadd_Hrs ( type: esriFieldTypeInteger , alias: inspadd_Hrs , Range: [0, 10] )
• Inspadd_OT ( type: esriFieldTypeInteger , alias: Inspadd_OT , Range: [0, 10] )
• Inspector_Add2 ( type: esriFieldTypeString , alias: Inspector_Add2 , length: 50 , Coded Values: [Vance Plant: Vance Plant] , [Gary Schierloh: Gary Schierloh] , [Steve Burch: Steve Burch] , ...3 more... )
• Inspadd2_Hrs ( type: esriFieldTypeInteger , alias: Inspadd2_Hrs , Range: [0, 10] )
• Inspadd2_OT ( type: esriFieldTypeInteger , alias: Inspadd2_OT , Range: [0, 10] )
• Equip_Hrs ( type: esriFieldTypeInteger , alias: Equip_Hrs , Range: [0, 10] )
• Descrip ( type: esriFieldTypeString , alias: Descrip , length: 150 )
• Descrip_Qt ( type: esriFieldTypeInteger , alias: Descrip_Qt , Range: [1, 100] )
• Descrip_Mk ( type: esriFieldTypeString , alias: Descrip_Mk , length: 50 )
• Descrip_Ptnum ( type: esriFieldTypeString , alias: Descrip_Ptnum , length: 50 )
• Descrip2 ( type: esriFieldTypeString , alias: Descrip2 , length: 150 )
• Descrip2_Qt ( type: esriFieldTypeInteger , alias: Descrip2_Qt , Range: [1, 100] )
• Descrip2_Mk ( type: esriFieldTypeString , alias: Descrip2_Mk , length: 50 )
• Descrip2_Ptnum ( type: esriFieldTypeString , alias: Descrip2_Ptnum , length: 50 )
• Descrip3 ( type: esriFieldTypeString , alias: Descrip3 , length: 150 )
• Descrip3_Qt ( type: esriFieldTypeInteger , alias: Descrip3_Qt , Range: [1, 100] )
• Descrip3_Mk ( type: esriFieldTypeString , alias: Descrip3_Mk , length: 50 )
• Descrip3_Ptnum ( type: esriFieldTypeString , alias: Descrip3_Ptnum , length: 50 )
• Descrip4 ( type: esriFieldTypeString , alias: Descrip4 , length: 150 )
• Descrip4_Qt ( type: esriFieldTypeInteger , alias: Descrip4_Qt , Range: [1, 100] )
• Descrip4_Mk ( type: esriFieldTypeString , alias: Descrip4_Mk , length: 50 )
• Descrip4_Ptnum ( type: esriFieldTypeString , alias: Descrip4_Ptnum , length: 50 )
• Descrip5 ( type: esriFieldTypeString , alias: Descrip5 , length: 150 )
• Descrip5_Qt ( type: esriFieldTypeInteger , alias: Descrip5_Qt , Range: [1, 100] )
• Descrip5_Mk ( type: esriFieldTypeString , alias: Descrip5_Mk , length: 50 )
• Descrip5_Ptnum ( type: esriFieldTypeString , alias: Descrip5_Ptnum , length: 50 )
• Descrip6 ( type: esriFieldTypeString , alias: Descrip6 , length: 150 )
• Descrip6_Qt ( type: esriFieldTypeInteger , alias: Descrip6_Qt , Range: [1, 100] )
• Descrip6_Mk ( type: esriFieldTypeString , alias: Descrip6_Mk , length: 50 )
• Descrip6_Ptnum ( type: esriFieldTypeString , alias: Descrip6_Ptnum , length: 50 )
• Descrip7 ( type: esriFieldTypeString , alias: Descrip7 , length: 150 )
• Descrip7_Qt ( type: esriFieldTypeInteger , alias: Descrip7_Qt , Range: [1, 100] )
• Descrip7_Mk ( type: esriFieldTypeString , alias: Descrip7_Mk , length: 50 )
• Descrip7_Ptnum ( type: esriFieldTypeString , alias: Descrip7_Ptnum , length: 50 )
• Descrip8 ( type: esriFieldTypeString , alias: Descrip8 , length: 150 )
• Descrip8_Qt ( type: esriFieldTypeInteger , alias: Descrip8_Qt , Range: [1, 100] )
• Descrip8_Mk ( type: esriFieldTypeString , alias: Descrip8_Mk , length: 50 )
• Descrip8_Ptnum ( type: esriFieldTypeString , alias: Descrip8_Ptnum , length: 50 )
• Insp_Hrs ( type: esriFieldTypeSingle , alias: Insp_Hrs )
• Insp_Hrs2 ( type: esriFieldTypeSingle , alias: Insp_Hrs2 )
• Insp_Hrs3 ( type: esriFieldTypeSingle , alias: Insp_Hrs3 )
• Insp_OT ( type: esriFieldTypeSingle , alias: Insp_OT )
• Insp_OT2 ( type: esriFieldTypeSingle , alias: Insp_OT2 )
• Insp_OT3 ( type: esriFieldTypeSingle , alias: Insp_OT3 )
• Eq_Hrs ( type: esriFieldTypeSingle , alias: Eq_Hrs )
• Mancode ( type: esriFieldTypeSmallInteger , alias: Mancode , Coded Values: [1: Eddy Clow] , [2: Mueller] , [3: Ludlow] , ...1 more... )
• Manname ( type: esriFieldTypeString , alias: Manname , length: 50 , Coded Values: [Eddy/Clow: Eddy/Clow] , [Mueller: Mueller] , [Ludlow: Ludlow] , ...1 more... )
• Manmodel ( type: esriFieldTypeString , alias: Manmodel , length: 50 , Coded Values: [None: None] , [Centurion: Centurion] , [Super Centurion: Super Centurion] , ...1 more... )
• HydrantNumber ( type: esriFieldTypeString , alias: HydrantNumber , length: 50 )
• Leak_Tested ( type: esriFieldTypeString , alias: Leak_Tested , length: 50 , Coded Values: [No: No] , [Yes: Yes] , [Needs Work: Needs Work] )

Relationships:

• testrelateclassto (0) -- Related To: Hydrants to Inspect (0)

Supported Operations:   Query   Query Related Records   Generate Renderer   Return Updates