v_hydrant_service_result

v_hydrant_service_result

Purpose

  1. Hydrant service inspection results.

Relationships

  • v_hydrant_service: Many-to-One (N:1)

    • Many results link to one service record

    • Referenced through hydrant_service_id

  • v_hydrant: Many-to-One (N:1)

    • Many results link to one hydrant

    • Referenced through hydrant_id



Table



Column

Type

Description

id

integer

Primary key

hydrant_service_id

integer

Service reference

question

text

Inspection question

description

text

Detail description

answer_type_code

varchar(40)

Answer type

answer_code

varchar(25)

Response code

answer

text

Response detail

answer_date

timestamp

Response time

hydrant_type_code

varchar(50)

Hydrant type

hydrant_id

integer

Hydrant reference

client_code

varchar(28)

Organization ID

remarks

text

Additional notes

pos

integer

Position order






    • Related Articles

    • Methods on starting a Service or Flow Test of a Hydrant

      Purpose To demonstrate the different locations to start a Service or Flow Test of a Hydrant within First Due. Video Directions 1. From the Hydrants List: Using the advance search to filter the list or from saved views, from the actions columns select ...

    • Creating a Hydrant Service Checklist

      Purpose To explain how to create a Hydrant Service Checklist. Video Instructions 1. Navigate to the Hydrants module and click on Hydrant Service Checklist 2. Click on Add Check List to create a new Checklist. Multiple checklists can be created within ...

    • Hydrants Module - Hydrant Service Reports

      Purpose To explain how to run and download a report of Hydrant Service Results. Video Directions Go into the Hydrant Service Results page by following Reports > Hydrants. A list of all Hydrants will come up. Customize the report you wish to create by ...

    • Completing a Hydrant Service Checklist

      Purpose To explain how to complete a Hydrant Service Checklist. IMPORTANT: Failing checklist options will not be sent to any user within the First Due system. It is imperative that if an item is marked failing, a email be sent to the appropriate ...

    • Completing a Hydrant Work Order from a Service Checklist

      Purpose To demonstrate how to complete a Hydrant Work Order from inside a Service Checklist, including the automatic summary. Related Articles Completing a Hydrant Service Checklist Creating a Hydrant Service Checklist Video Instructions 1. Use the ...