ODBC Data Warehouse - Data Dictionary

Last Updated: November 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: November 01, 2026

Summary

Schema changes detected. Please review the detailed changes below.

New Columns

• v_invoice.contact_company_name (text) - New column added
• v_invoice.billing_type (text) - New column added
• v_invoice.contact_email (text) - New column added
• v_invoice.contact_phone (text) - New column added
• v_hydrant.flow_hydrant_two (integer) - New column added
• v_hydrant.pitot_gauge_two (integer) - New column added
• v_hydrant.fh_two_facility_code (character) - New column added
• v_hydrant.flow_hydrant_one (integer) - New column added
• v_hydrant.pitot_gauge_one (integer) - New column added
• v_hydrant.fh_one_facility_code (character) - New column added
• v_epcr_medication.medication_administered_by_another_unit_code (character) - New column added
• v_epcr_medication.medication_authorization_physician (character) - New column added
• v_fire_inspection_violation.anchor_id (integer) - New column added
• v_fire_inspection_violation.anchor_type (character) - New column added
• f_epcr.destination_gps_location (character) - New column added
• f_epcr.destination_street_address (character) - New column added
• f_epcr.suit (character) - New column added
• f_epcr.environmental_food_allergies_codes (character) - New column added
• f_epcr.patient_occupation_code (character) - New column added
• f_epcr.disaster_codes (character) - New column added
• f_epcr.unit (character) - New column added
• f_epcr.incident_facility_name (character) - New column added
• f_epcr.emails (character) - New column added
• f_epcr.justification_for_transport (character) - New column added
• f_epcr.country_residence_code (character) - New column added
• f_epcr.others_symptom_codes (character) - New column added
• f_epcr.how_moved_from_ambulance_codes (character) - New column added
• f_epcr.height_of_fall (integer) - New column added
• f_epcr.mile_post_major_roadway (character) - New column added
• f_epcr.unit_arrived_staging_area_at (timestamp) - New column added
• f_epcr.emergency_department_admission_at (character) - New column added
• f_epcr.alternate_home_residence_code (character) - New column added
• f_epcr.scene_cross_street (character) - New column added
• f_epcr.how_moved_to_ambulance_codes (character) - New column added
• f_epcr.osha_ppe_used_codes (character) - New column added
• f_epcr.standby_purpose_code (character) - New column added
• f_epcr.phone_numbers (character) - New column added
• f_epcr.hospital_discharge_at (character) - New column added
• f_epcr.scene_country_code (character) - New column added
• f_epcr.patient_activity_codes (character) - New column added
• f_epcr.sex_code (character) - New column added
• f_epcr.arrival_destination_landing_area_at (timestamp) - New column added
• f_epcr.middle_initial_name (character) - New column added
• f_epcr.name_suffix (character) - New column added
• f_epcr.patient_preferred_languages_codes (character) - New column added
• f_epcr.reason_interfacility_transfer_medical_transport_code (character) - New column added
• f_epcr.patient_occupational_industry_code (character) - New column added
• f_epcr.destination_location_us_national_grid_coordinates (character) - New column added
• f_epcr.position_during_transport_codes (character) - New column added
• f_epcr.initial_responder_arrived_at (timestamp) - New column added
• f_epcr.hospital_admission_at (character) - New column added
• f_epcr.hospital_diagnosis_codes (character) - New column added
• v_occupancy_contact.is_billing_contact (boolean) - New column added
• v_work_order.locker_name (text) - New column added
• v_work_order.locker_id (integer) - New column added

Modified Columns

• v_fire_investigation_vehicle_fire_fields.odometer - Data type changed from numeric(7 to character
• v_fire_investigation_structure_fire_fields.obstacles_description - Data type changed from character to text
• v_personnel.personnel_zip - Data type changed from text 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