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

    • Assets Module Setup: Creating an Asset Checklist

      Purpose The purpose of this article is to inform users how to create an asset checklist in the Assets Module Setup. Video Directions 1. Click on Assets. 2. Click on Setup. 3. Click on Check List. 4. Click on Add Check List. 5. Complete the following ...

    • Checklist: Editing an Existing Checklist

      Purpose The purpose of this article is to inform First Due users how to edit an existing checklist in the First Due Assets module. Video Directions 1. Click on Assets. 2. Click on Setup. 3. Click on Checklist. 4. Locate the checklist that is to be ...

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

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