ODBC Data Warehouse - Data Dictionary
Last Updated: September 01, 2026 at 01:23 AM
Schema: app
Overview
This is the master index for the ODBC Data Warehouse data dictionary. Use the links below to navigate to detailed documentation for each table.
- Total Tables: 123
- Total Views: 106
Recent Schema Changes
Comparison Date: September 01, 2026
Summary
The ODBC Data Warehouse has been updated with significant enhancements to occupancy and fire investigation data, including new preplan fields for building characteristics, construction details, and property values in the v_occupancy table, plus expanded fire investigation tracking capabilities with scene type classifications and incident timing fields. The v_checklist_question_answers view has been removed, which may impact users who relied on this view for accessing checklist response data. These changes primarily expand data collection capabilities for building preplanning and fire investigation workflows while streamlining the checklist data structure.
Removed Tables
- v_checklist_question_answers - Table removed
New Columns
- v_occupancy.address_note_type_id (integer) - New column added
- v_occupancy.preplan_solar_panel (character(1)) - New column added
- v_occupancy.preplan_total_volume_cu_cm (numeric(25) - New column added
- v_occupancy.preplan_additional_occupancy_class_ids (integer[]) - New column added
- v_occupancy.preplan_additional_property_use_id (integer) - New column added
- v_occupancy.preplan_ceiling_height_cm (integer) - New column added
- v_occupancy.preplan_volume_per_floor_cu_cm (numeric(14) - New column added
- v_occupancy.preplan_roof_deck_id (integer) - New column added
- v_occupancy.preplan_construction_type_id (integer) - New column added
- v_occupancy.preplan_property_value (numeric(14) - New column added
- v_occupancy.preplan_created_via_app_interface_code (character) - New column added
- v_occupancy.preplan_additional_construction_type_ids (integer[]) - New column added
- v_occupancy.brush_inspection_area_gis_2 (integer[]) - New column added
- v_occupancy.preplan_area_per_floor_sq_cm (numeric(12) - New column added
- v_occupancy.brush_inspection_area_gis_1 (integer[]) - New column added
- v_occupancy.preplan_life_hazard_use_ids (integer[]) - New column added
- v_occupancy.address_verification_status_code (character) - New column added
- v_apparatus.api_apparatus_id (character) - New column added
- f_fire_investigation.scene_type_marine (boolean) - New column added
- f_fire_investigation.scene_type_vehicle (boolean) - New column added
- f_fire_investigation.scene_type_compartment (boolean) - New column added
- f_fire_investigation.investigation_type_code (character) - New column added
- f_fire_investigation.incident_time (time) - New column added
- f_fire_investigation.incident_date (date) - New column added
- f_fire_investigation.scene_type_structure (boolean) - New column added
- f_fire_investigation.incident_at_local (timestamp) - New column added
- f_fire_investigation.scene_type_wildfire (boolean) - New column added
Removed Views
- v_checklist_question_answers - View removed
Tables Reference
Click on any table name below to view its detailed documentation:
- activity_type
- f_all_schedule
- f_all_schedule_payroll_summary
- f_asset_inventory
- f_ems_qa_review_fields
- f_ems_quality_assurance_review
- f_epcr
- f_epcr_custom_question
- f_fire_inspection
- f_fire_inspection_time_log
- f_fire_investigation
- f_fire_investigation_custom_question
- f_incident_report
- f_incident_report_neris
- f_schedule
- f_time_off_accrual
- f_trade_balance
- v_apparatus
- v_asset_inspection_completed
- v_cc_burn_permit
- v_cc_burn_permit_question
- v_cc_functional_needs
- v_cc_smoke_alarm_request
- v_daily_log
- v_dispatch
- v_epcr_complaint
- v_epcr_consumable
- v_epcr_disposition_team
- v_epcr_exam
- v_epcr_export_summary
- v_epcr_history
- v_epcr_history_medication
- v_epcr_medication
- v_epcr_other_crew
- v_epcr_procedure
- v_epcr_protocol
- v_epcr_signature
- v_epcr_vital
- v_equipment
- v_event
- v_event_participant
- v_event_payroll_summary
- v_fd_permit
- v_fd_permit_plan_review
- v_fire_burn_ban_area
- v_fire_dept_user
- v_fire_inspection_item_result
- v_fire_inspection_violation
- v_fire_investigation_compartment_fire_fields
- v_fire_investigation_hypothesis
- v_fire_investigation_marine_fire
- v_fire_investigation_structure_fire_fields
- v_fire_investigation_vehicle_fire_fields
- v_fire_investigation_wildfire
- v_fluid_entry
- v_health_wellness_exposure
- v_hydrant
- v_hydrant_service
- v_hydrant_service_flow_test
- v_hydrant_service_result
- v_incident_action_taken
- v_incident_report_apparatus
- v_incident_report_chemicals
- v_incident_report_deprecated_nfirs_fields
- v_incident_report_emerging_hazards
- v_incident_report_fire_fields
- v_incident_report_payroll_summary
- v_incident_report_people
- v_incident_report_people_address
- v_incident_report_people_insurance
- v_incident_report_personnel
- v_incident_report_prevention_fields
- v_incident_report_property_fields
- v_incident_report_question
- v_incident_report_station_response
- v_incident_report_weather_fields
- v_invoice
- v_invoice_line_item
- v_invoice_payment
- v_invoice_payment_with_refund
- v_life_hazard_use
- v_nfirs_civilian_casualty
- v_nfirs_ems
- v_nfirs_ems_medication
- v_nfirs_ems_signature
- v_nfirs_ems_treatment
- v_nfirs_ems_vital_sign
- v_nfirs_firefighter_casualty
- v_nfirs_firefighter_casualty_equipment
- v_occupancy
- v_occupancy_contact
- v_occupancy_history
- v_payroll_summary
- v_permissions_by_role
- v_permissions_by_user
- v_permit_questions
- v_personnel
- v_personnel_employment_history
- v_personnel_nemsis
- v_personnel_nemsis_licensure
- v_personnel_pay_rate
- v_preplan_expiring_hazmat
- v_preplan_expiring_unit
- v_preplan_expiring_unit_history
- v_preplan_hazmat
- v_preplan_hazmat_history
- v_preplan_last_completed
- v_preplan_unit
- v_preplan_unit_history
- v_roles_extracted
- v_time_off
- v_trade
- v_training_certification
- v_training_certification_user
- v_training_class
- v_training_class_attendee
- v_training_class_attendee_objective
- v_training_class_instructor
- v_training_class_payroll_summary
- v_training_class_training_objective
- v_training_topic
- v_work_order
- v_work_shift_request
Additional Information
- This data dictionary is automatically generated monthly from the ODBC Data Warehouse schema
- Each table article includes detailed information about columns, data types, constraints, and relationships
- For questions or clarifications, please contact the Data Services team