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 ...
    • Hydrants: 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 ...
    • Hydrant Setup: Flow & Service

      Purpose Statement This article outlines how administrators can configure default settings for hydrant flow testing and service status within the Hydrant module. These defaults streamline data entry, ensure consistency, and support operational ...
    • 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 ...