f_fire_inspection
Table Name: f_fire_inspection
Last Updated: June 01, 2026 at 01:21 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| client_code | character | Yes | - |
| place_id | integer | Yes | - |
| preplan_id | integer | Yes | - |
| user_assigned_id | integer | Yes | - |
| team_id | integer | Yes | - |
| user_completed_id | integer | Yes | - |
| place_location_cache | text | Yes | - |
| fire_inspection_type_name | character | Yes | - |
| fire_inspection_type_id | integer | Yes | - |
| fire_inspection_scheduled_at | timestamp | Yes | - |
| fire_inspection_completed_at | timestamp | Yes | - |
| fire_inspection_schedule_type_code | character | Yes | - |
| is_re_inspection | boolean | Yes | - |
| fire_inspection_reinspection_number | integer | Yes | - |
| fire_inspection_status_code | character | Yes | - |
| fire_inspection_notes | text | Yes | - |
| is_printed | boolean | Yes | - |
| fire_inspection_no_signature_reason | text | Yes | - |
| fire_inspection_has_open_sdf_violations | boolean | Yes | - |
| fire_inspection_has_sfd_permits | boolean | Yes | - |
| has_recurring_scheduled | boolean | Yes | - |
| inspection_preplan_contact_name | character | Yes | - |
| inspection_preplan_contact_type_id | integer | Yes | - |
| inspection_preplan_contact_type | character | Yes | - |
| batt_dept_shift_name | character | Yes | - |
| batt_dept_shift_id | integer | Yes | - |
| inspection_number | character | Yes | - |
| assigned_user | character | Yes | - |
| assigned_team | character | Yes | - |
| completed_by_user | character | Yes | - |
| fire_station | character | Yes | - |
| fire_station_id | integer | Yes | - |
| preplan_business_name | character | Yes | - |
| preplan_is_inspectable | boolean | Yes | - |
| preplan_business_phone | character | Yes | - |
| preplan_business_type | character | Yes | - |
| preplan_building_use | character | Yes | - |
| based_on_fire_inspection_id | integer | Yes | - |
| original_fire_inspection_id | integer | Yes | - |
| preplan_is_dangerous_building | boolean | Yes | - |
| fd_permit_type_ids | integer[] | Yes | - |
| is_emailed | boolean | Yes | - |
| created_by | integer | Yes | - |
| created_at | timestamp | Yes | - |
| started_at | timestamp | Yes | - |
| ended_at | timestamp | Yes | - |
| fire_inspection_adjusted_time | integer | Yes | - |
| fire_inspection_total_time | integer | Yes | - |
| responsible_inspector_id | integer | Yes | - |
| responsible_team_id | integer | Yes | - |
| is_reassignment | boolean | Yes | - |
| reassignment_at | timestamp | Yes | - |
| responsible_inspector | character | Yes | - |
| responsible_team | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.