ODBC Data Warehouse - Data Dictionary

Last Updated: July 13, 2026 at 09:57 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: 124
Total Views: 107

Recent Schema Changes

Comparison Date: July 13, 2026

Summary

The ODBC Data Warehouse has undergone a major expansion with the addition of 114 new tables and views covering comprehensive fire department operations including incident reporting, fire inspections, EMS records, personnel management, training, and financial tracking. This significant enhancement provides users with access to detailed data across all aspects of fire department operations, from NFIRS reporting and emergency medical services to equipment management and payroll processing. Users can now access much more granular and specialized data views that were previously unavailable, greatly expanding reporting and analysis capabilities.

New Tables

v_preplan_last_completed - New table added
v_fire_inspection_violation - New table added
v_permissions_by_user - New table added
v_incident_report_people - New table added
v_nfirs_firefighter_casualty_equipment - New table added
v_fire_investigation_compartment_fire_fields - New table added
v_incident_report_people_address - New table added
v_preplan_unit - New table added
v_occupancy_history - New table added
v_incident_report_fire_fields - New table added
v_epcr_complaint - New table added
v_nfirs_civilian_casualty - New table added
v_fire_investigation_wildfire - New table added
f_incident_report - New table added
v_nfirs_ems_vital_sign - New table added
v_fd_permit - New table added
v_incident_report_deprecated_nfirs_fields - New table added
v_personnel_pay_rate - New table added
v_work_order - New table added
v_preplan_hazmat - New table added
v_invoice_payment_with_refund - New table added
v_time_off - New table added
v_epcr_vital - New table added
v_daily_log - New table added
v_training_class_attendee - New table added
v_life_hazard_use - New table added
v_preplan_hazmat_history - New table added
v_preplan_expiring_unit - New table added
f_time_off_accrual - New table added
v_epcr_other_crew - New table added
v_cc_burn_permit_question - New table added
v_epcr_procedure - New table added
v_epcr_export_summary - New table added
v_training_class_training_objective - New table added
v_apparatus - New table added
f_schedule - New table added
v_preplan_unit_history - New table added
v_event_payroll_summary - New table added
v_nfirs_ems_medication - New table added
f_epcr - New table added
f_all_schedule - New table added
v_incident_report_prevention_fields - New table added
v_training_certification_user - New table added
f_trade_balance - New table added
v_occupancy_contact - New table added
v_nfirs_ems_signature - New table added
v_personnel_employment_history - New table added
v_trade - New table added
v_incident_report_weather_fields - New table added
v_work_shift_request - New table added
v_incident_report_people_insurance - New table added
v_dispatch - New table added
v_payroll_summary - New table added
v_incident_report_payroll_summary - New table added
activity_type - New table added
v_epcr_medication - New table added
f_epcr_custom_question - New table added
v_epcr_disposition_team - New table added
v_incident_action_taken - New table added
v_invoice_line_item - New table added
v_cc_functional_needs - New table added
v_training_class_payroll_summary - New table added
v_personnel - New table added
v_preplan_expiring_hazmat - New table added
v_event_participant - New table added
v_health_wellness_exposure - New table added
v_nfirs_ems - New table added
v_epcr_signature - New table added
v_hydrant_service - New table added
v_permit_questions - New table added
v_hydrant_service_flow_test - New table added
v_checklist_question_answers - New table added
v_training_class - New table added
v_roles_extracted - New table added
v_fire_investigation_marine_fire - New table added
v_training_class_attendee_objective - New table added
v_training_certification - New table added
f_fire_inspection - New table added
v_incident_report_chemicals - New table added
v_epcr_consumable - New table added
v_epcr_protocol - New table added
v_incident_report_question - New table added
v_fire_burn_ban_area - New table added
v_personnel_nemsis_licensure - New table added
v_fire_inspection_item_result - New table added
v_training_class_instructor - New table added
v_personnel_nemsis - New table added
v_fd_permit_plan_review - New table added
v_invoice - New table added
v_permissions_by_role - New table added
v_incident_report_apparatus - New table added
v_incident_report_property_fields - New table added
v_equipment - New table added
f_fire_investigation - New table added
v_event - New table added
v_hydrant_service_result - New table added
v_fluid_entry - New table added
v_incident_report_station_response - New table added
v_epcr_exam - New table added
v_nfirs_ems_treatment - New table added
f_ems_quality_assurance_review - New table added
f_ems_qa_review_fields - New table added
v_incident_report_emerging_hazards - New table added
v_fire_investigation_structure_fire_fields - New table added
v_training_topic - New table added
f_fire_inspection_time_log - New table added
f_fire_investigation_custom_question - New table added
v_cc_burn_permit - New table added
v_asset_inspection_completed - New table added
v_fire_investigation_hypothesis - New table added
v_invoice_payment - New table added
v_nfirs_firefighter_casualty - New table added
v_preplan_expiring_unit_history - New table added
v_cc_smoke_alarm_request - New table added
f_all_schedule_payroll_summary - New table added
v_incident_report_personnel - New table added
v_fire_dept_user - New table added
v_epcr_history - New table added
f_incident_report_neris - New table added
v_occupancy - New table added
v_hydrant - New table added
f_asset_inventory - New table added
v_epcr_history_medication - New table added
v_fire_investigation_vehicle_fire_fields - New table added

New Views

v_preplan_last_completed - New view added
v_fire_inspection_violation - New view added
v_permissions_by_user - New view added
v_incident_report_people - New view added
v_nfirs_firefighter_casualty_equipment - New view added
v_fire_investigation_compartment_fire_fields - New view added
v_incident_report_people_address - New view added
v_preplan_unit - New view added
v_occupancy_history - New view added
v_incident_report_fire_fields - New view added
v_epcr_complaint - New view added
v_nfirs_civilian_casualty - New view added
v_fire_investigation_wildfire - New view added
v_nfirs_ems_vital_sign - New view added
v_fd_permit - New view added
v_incident_report_deprecated_nfirs_fields - New view added
v_personnel_pay_rate - New view added
v_work_order - New view added
v_preplan_hazmat - New view added
v_invoice_payment_with_refund - New view added
v_time_off - New view added
v_epcr_vital - New view added
v_daily_log - New view added
v_training_class_attendee - New view added
v_life_hazard_use - New view added
v_preplan_hazmat_history - New view added
v_preplan_expiring_unit - New view added
v_epcr_other_crew - New view added
v_cc_burn_permit_question - New view added
v_epcr_procedure - New view added
v_epcr_export_summary - New view added
v_training_class_training_objective - New view added
v_apparatus - New view added
v_nfirs_ems_medication - New view added
v_preplan_unit_history - New view added
v_event_payroll_summary - New view added
v_incident_report_prevention_fields - New view added
v_training_certification_user - New view added
v_occupancy_contact - New view added
v_nfirs_ems_signature - New view added
v_personnel_employment_history - New view added
v_trade - New view added
v_incident_report_weather_fields - New view added
v_work_shift_request - New view added
v_incident_report_people_insurance - New view added
v_dispatch - New view added
v_payroll_summary - New view added
v_incident_report_payroll_summary - New view added
v_epcr_medication - New view added
v_epcr_disposition_team - New view added
v_incident_action_taken - New view added
v_invoice_line_item - New view added
v_cc_functional_needs - New view added
v_training_class_payroll_summary - New view added
v_personnel - New view added
v_preplan_expiring_hazmat - New view added
v_nfirs_ems - New view added
v_event_participant - New view added
v_health_wellness_exposure - New view added
v_epcr_signature - New view added
v_hydrant_service - New view added
v_permit_questions - New view added
v_hydrant_service_flow_test - New view added
v_checklist_question_answers - New view added
v_training_class - New view added
v_roles_extracted - New view added
v_fire_investigation_marine_fire - New view added
v_training_class_attendee_objective - New view added
v_training_certification - New view added
v_incident_report_chemicals - New view added
v_incident_report_question - New view added
v_epcr_consumable - New view added
v_epcr_protocol - New view added
v_fire_burn_ban_area - New view added
v_personnel_nemsis_licensure - New view added
v_fire_inspection_item_result - New view added
v_training_class_instructor - New view added
v_personnel_nemsis - New view added
v_fd_permit_plan_review - New view added
v_invoice - New view added
v_permissions_by_role - New view added
v_incident_report_apparatus - New view added
v_incident_report_property_fields - New view added
v_equipment - New view added
v_hydrant_service_result - New view added
v_event - New view added
v_fluid_entry - New view added
v_incident_report_station_response - New view added
v_epcr_exam - New view added
v_nfirs_ems_treatment - New view added
v_incident_report_emerging_hazards - New view added
v_fire_investigation_structure_fire_fields - New view added
v_training_topic - New view added
v_cc_burn_permit - New view added
v_asset_inspection_completed - New view added
v_fire_investigation_hypothesis - New view added
v_invoice_payment - New view added
v_nfirs_firefighter_casualty - New view added
v_preplan_expiring_unit_history - New view added
v_cc_smoke_alarm_request - New view added
v_incident_report_personnel - New view added
v_fire_dept_user - New view added
v_epcr_history - New view added
v_occupancy - New view added
v_hydrant - New view added
v_epcr_history_medication - New view added
v_fire_investigation_vehicle_fire_fields - New view added

Tables Reference

Click on any table name below to view its detailed documentation:

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

Search

Knowledge Center

ODBC Data Dictionary - Overview and Changes