v_checklist_question_answers

v_checklist_question_answers

Purpose

  1. Checklist completion records view.

Relationships

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

    • Many answers link to one personnel

    • Referenced through personnel_id

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

    • Many answers link to one equipment

    • Referenced through asset matching



Table


Column

Type

Description

id

integer

Primary key

client_code

varchar(28)

Organization ID

completed_at

timestamp

Completion time

question

varchar(255)

Question text

section

varchar(255)

Section name

personnel_id

integer

Personnel reference

schedule_date

timestamp

Schedule date

personnel_name

varchar(255)

Personnel name

answer_type_code

varchar(32)

Answer type

checklist_id

integer

Checklist reference

checklist_name

varchar(255)

Checklist name

asset_name

varchar

Asset name

asset_type

text

Asset type

question_result

text

Answer result

duration

integer

Duration




    • Related Articles

    • v_cc_burn_permit_question

      Purpose Burn permit questions and answers view. Relationships v_cc_burn_permit: Many-to-One (N:1) Many questions link to one permit Referenced through permit_id Table Column Type Description permit_answer_id integer Primary key question text Question ...

    • Creating and Importing an Inspection Checklist

      Purpose Statement This feature enables fire departments and EMS agencies to create standardized inspection checklists by importing them from Excel templates. This streamlines the inspection process, ensures consistency across all inspections, and ...

    • Assets Module Setup: Creating an Asset Checklist

      Purpose Statement The Assets Checklist feature enables module managers to create standardized inspection, maintenance, and compliance checklists for apparatus, equipment, stations, and kits. By establishing structured checklists, departments can ...

    • Inspection Type - Part 2: Creating and Editing an Inspection Checklist

      Purpose Statement This article demonstrates how to create and edit comprehensive inspection checklists within the Fire/EMS software platform. Inspection checklists enable departments to standardize their inspection processes, ensure regulatory ...

    • 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 ...