Name: QBYTESTHYDRELCLASS.DBO.testreltable

Display Field: Manname

Type: Table

Geometry Type: N/A

Description:

Definition Expression: N/A

Copyright Text:

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:

Fields:

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

Templates:

• Name: QBYTESTHYDRELCLASS.DBO.testreltable
  Description:
  Prototype:
  Leak_Tested: No
  Manufacturer: null
  Year: 1900
  Location: null
  Staked: null
  Plowed: null
  Frozen: null
  HydrantNumber:
  Manmodel: None
  Manname: Eddy/Clow
  Mancode: null
  Eq_Hrs: 0
  Inspector: Vance Plant
  Pressure_Tested: Yes
  Oil_Level: Yes
  Check_Grease: Yes
  Threads_Serviced: Yes
  Packing_Tightened: Yes
  Branch_Valve: Yes
  Hydrant_Num_OK: Yes
  Location_Noted: Yes
  Straight_to_Road: Yes
  PSI: 60
  Steamer_Thread: Yes
  Hydrant_Work: Yes
  Branch_Valve_Loc: Straight
  Highway_Yellow_Cap: Yes
  Plugged_Drip: Yes
  Caps_Pentagon: Yes
  Leading_OK: Yes
  Hydrant_Needs: None
  Remarks: None
  Height_OK: Yes
  Vert_OK: Yes
  Paint_OK: Yes
  Caps_OK: Yes
  Nozzles_OK: Yes
  Opnut_OK: Yes
  Barrels_OK: Yes
  Mainvalve_OK: Yes
  Drainvalve_OK: Yes
  Branchvalve_OK: Yes
  Orings_OK: Yes
  Packing_OK: Yes
  Reflecpaint_OK: Yes
  Pumped_OK: Yes
  Inspector_Hrs: 0
  Inspector_OT: null
  Equip: null
  Inspector_Add: null
  inspadd_Hrs: null
  Inspadd_OT: null
  Inspector_Add2: null
  Inspadd2_Hrs: null
  Inspadd2_OT: null
  Equip_Hrs: null
  Descrip: null
  Descrip_Qt: null
  Descrip_Mk: null
  Descrip_Ptnum: null
  Descrip2: null
  Descrip2_Qt: null
  Descrip2_Mk: null
  Descrip2_Ptnum: null
  Descrip3: null
  Descrip3_Qt: null
  Descrip3_Mk: null
  Descrip3_Ptnum: null
  Descrip4: null
  Descrip4_Qt: null
  Descrip4_Mk: null
  Descrip4_Ptnum: null
  Descrip5: null
  Descrip5_Qt: null
  Descrip5_Mk: null
  Descrip5_Ptnum: null
  Descrip6: null
  Descrip6_Qt: null
  Descrip6_Mk: null
  Descrip6_Ptnum: null
  Descrip7: null
  Descrip7_Qt: null
  Descrip7_Mk: null
  Descrip7_Ptnum: null
  Descrip8: null
  Descrip8_Qt: null
  Descrip8_Mk: null
  Descrip8_Ptnum: null
  Insp_Hrs: 0.25
  Insp_Hrs2: 0
  Insp_Hrs3: 0
  Insp_OT: 0
  Insp_OT2: 0
  Insp_OT3: 0
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supported Operations:   Query   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Generate Renderer   Return Updates