ODBC Data Warehouse - Data Dictionary
Last Updated: October 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: October 01, 2026
Summary
The ODBC Data Warehouse has been enhanced with 10 new columns across multiple views, primarily expanding medical data capture capabilities in the EPCR vital signs and medication history modules with fields for pain scales, arterial pressure, trauma scores, and detailed medication dosing information. Additionally, a new training log indicator has been added to the training class view, and incident reporting now includes NERIS ID tracking. One breaking change occurred where the EPCR number field in the NFIRS EMS view changed from integer to character format, which may require updates to existing queries or integrations that reference this field.
New Columns
- v_training_class.is_training_log (boolean) - New column added
- f_incident_report_neris.neris_id (character) - New column added
- v_epcr_vital.pain_scale_type_code (character) - New column added
- v_epcr_vital.mean_arterial_pressure (integer) - New column added
- v_epcr_vital.revised_trauma_score (integer) - New column added
- v_epcr_vital.apgar_score (numeric) - New column added
- v_epcr_history_medication.route_code (character) - New column added
- v_epcr_history_medication.dosage_unit_code (character) - New column added
- v_epcr_history_medication.frequency_code (character) - New column added
- v_epcr_history_medication.dose (double) - New column added
Modified Columns
- v_nfirs_ems.epcr_number - Data type changed from integer to character
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