v_fire_inspection_item_result
Purpose
- Fire inspection checklist results.
Relationships
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 ...