v_fire_inspection_item_result

v_fire_inspection_item_result

Purpose

  1. Fire inspection checklist results.


Relationships

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

    • Many results link to one inspection

    • Referenced through fire_inspection_id

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

    • Many results created by one personnel

    • Referenced through created_by



Table


Column

Type

Description

id

integer

Primary key

fire_inspection_id

integer

Inspection reference

answer_code

varchar(30)

Response code

remark

text

Comments

created_by_name

varchar(255)

Inspector name

checklist_item_question

text

Question text

copy_number

integer

Copy number

is_mandatory_response

boolean

Required flag

section_title

varchar(255)

Section name

is_adhoc

boolean

Adhoc item

fire_inspection_answer_type_code

varchar

Answer type

code_set

varchar(50)

Code set

code_edition_year

integer

Code year

code_number

varchar(30)

Code number

code_description

text

Code description

client_code

varchar(28)

Organization ID

created_by

integer

Creator ID

unique_id

text

Unique identifier





    • Related Articles

    • v_fire_inspection_violation

      Purpose Fire code violation records. Relationships f_fire_inspection: Many-to-One (N:1) Many violations link to one inspection Referenced through fire_inspection_id v_occupancy: Many-to-One (N:1) Many violations link to one location Referenced ...
    • v_asset_inspection_completed

      Purpose Completed asset inspection records view. Relationships v_apparatus: Many-to-One (N:1) Many inspections link to one apparatus Referenced through apparatus_id v_equipment: Many-to-One (N:1) Many inspections link to one equipment item Referenced ...
    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...
    • Calculate Needed Fire Flow

      Purpose The purpose of this Knowledge Base Article is to demonstrate the process for calculating the Needed Fire Flow for an Occupancy. Video Instructions 1. Navigate to Admin then click on Roles. 2. Select edit for the Role to enable "Calculate ...
    • Inspection Type - Part 2: Creating and Editing an Inspection Checklist

      Purpose To demonstrate how to create and edit an Inspection Checklist. Related Articles Inspection Type - Part 1: Creating and Editing Inspection Type Inspection Type - Part 3: Forms Inspection Type - Part 4: Email Inspection Type - Part 5: Billing ...