ODBC Data Warehouse - Data Dictionary
Last Updated: June 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: 121
- Total Views: 104
Recent Schema Changes
Comparison Date: June 01, 2026
No schema changes detected since the last update.
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_checklist_question_answers
- 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_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_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