v_fire_inspection_violation

v_fire_inspection_violation

Purpose

  1. 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 through place_id

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

    • Many violations link to one checklist result

    • Referenced through checklist_item_result_id



Table



Column

Type

Description

id

integer

Primary key

place_id

integer

Location reference

fire_inspection_id

integer

Inspection reference

preplan_id

integer

Pre-plan reference

checklist_item_result_id

integer

Result reference

violation_created_at

timestamp

Creation time

violation_resolved_at

timestamp

Resolution time

preplan_business_name

varchar

Business name

checklist_item_question

text

Violation item

checklist_item_remark

text

Comments

initial_status

varchar(30)

Initial status

current_status

varchar(30)

Current status

code

varchar(30)

Violation code

code_description

text

Code description

fire_inspection_type_name

varchar(255)

Inspection type

inspection_number

varchar(30)

Inspection number

location_cache

text

Location details

client_code

varchar(28)

Organization ID






    • Related Articles

    • f_fire_inspection

      Purpose Documents fire inspections and their results. Relationships v_occupancy: Many-to-One (N:1) Many inspections can link to one occupancy Referenced through place_id v_fire_inspection_violation: One-to-Many (1:N) One inspection can have many ...

    • v_fire_inspection_item_result

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

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

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