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

    • Checklist Item Numbering on Inspection Forms

      Purpose Statement This feature enables sequential numbering for checklist items on inspection forms, providing clear organization and easy reference for inspectors and administrators. The numbering system improves documentation accuracy, enhances ...

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

    • Inspection Record - Schedule Reinspection

      Purpose Statement The Schedule Reinspection feature enables fire prevention officers and inspection personnel to efficiently schedule follow-up inspections when violations or failed checklist items are identified during initial inspections. This ...

    • Portal Permit Formula Line Item

      Purpose Statement The Portal Permit Formula Line Item feature enables fire departments and EMS agencies to automatically calculate permit fees based on custom data fields entered by applicants through the Community Connect Portal and Business Portal. ...