Data Dictionary
f_incident_report
Purpose Documents emergency incidents and responses. Relationships f_epcr: One-to-Many (1:N) One incident can have multiple EPCRs Referenced through incident_report_id v_incident_report_apparatus: One-to-Many (1:N) One incident can have multiple ...
f_fire_inspection
Purpose Documents fire inspections and their results. Relationships v_occupancy: Many-to-One (N:1) Many inspections can link to one occupancy Referenced through place_id v_fire_inspection_violation: One-to-Many (1:N) One inspection can have many ...
f_epcr_crew
Purpose Tracks crew members associated with electronic patient care reports. Relationships f_epcr: Many-to-One (N:1) Many crew members can be associated with one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many crew entries can ...
f_ecpr
Purpose Electronic Patient Care Report fact table for documenting patient care incidents. Relationships f_epcr_crew: One-to-Many (1:N) One EPCR can have multiple crew members Referenced through epcr_id v_epcr_complaint: One-to-Many (1:N) One EPCR can ...
f_asset_inventory
Purpose Tracks inventory of assets, including quantities and locations. Relationships v_equipment: One-to-Many (1:N) One inventory record can have many equipment items Referenced through asset_type_code v_apparatus: One-to-Many (1:N) One inventory ...
f_all_schedule
Purpose Comprehensive scheduling fact table tracking personnel assignments and work schedules. Relationships activity_type: Many-to-One (N:1) Many schedules link to one activity type Referenced through activity_type field v_fire_dept_user: ...
activity_type
Purpose Tracks types of activities and their configurations. Relationships f_all_schedule: One-to-Many (1:N) One activity_type can be associated with many schedules Referenced in f_all_schedule through activity_type field v_event_payroll_summary: ...