Data Dictionary Tables
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: ...
Popular Articles
Pre-Plans 101
First Due Academy: Pre-Plans 101 This training session dives into the features and functionality within First Due's Pre-Incident Planning Module. In 101 level sessions we review fundamental module navigation, demonstrate common use cases, offer ...
Completing an Incident Report - Apparatus
Purpose The purpose of this article is to guide you through the Apparatus section when completing an incident report. Related Articles Completing an Incident Report - Response Completing an Incident Report - Size Up Concurrent Data Entry of Apparatus ...
NFIRS 101
First Due Academy: NFIRS 101 This training session focuses on First Due's NFIRS Incident Reporting functionality and processes. In 101 level sessions we review fundamental module navigation, demonstrate common use cases, offer product tips, and ...
Assets 101
First Due Academy: Assets 101 This training session offers specialized instruction for the features and functionality associated with First Due's Assets & Inventory Module. In 101 level sessions we review fundamental module navigation, demonstrate ...
Welcome to the First Due Knowledge Base
Welcome Data drives the 21st century fire service...First Due puts you in the driver's seat. Thank you for becoming part of the First Due family of fire/EMS agencies, local administrators, and users of this remarkable system for managing your entire ...