Data Dictionary
v_work_order
Purpose Equipment/apparatus work order records. Relationships v_apparatus: Many-to-One (N:1) Many work orders link to one apparatus Referenced through apparatus_id v_equipment: Many-to-One (N:1) Many work orders link to one equipment item Referenced ...
v_training_instructor
Purpose Training class instructor records. Relationships v_training_class: Many-to-One (N:1) Many instructors link to one class Referenced through training_class_id v_personnel: Many-to-One (N:1) Many instruction records link to one personnel ...
v_training_class_attendee_objective
Purpose Training objective completion records. Relationships v_training_class_attendee: Many-to-One (N:1) Many objectives link to one attendance record Referenced through training_class_attendee_id v_training_class: Many-to-One (N:1) Many objectives ...
v_training_class_attendee
Purpose Training class attendance records. Relationships v_training_class: Many-to-One (N:1) Many attendees link to one class Referenced through training_class_id v_personnel: Many-to-One (N:1) Many attendance records link to one personnel Referenced ...
v_training_class
Purpose Training class records. Relationships v_training_class_attendee: One-to-Many (1:N) One class can have many attendees Referenced through training_class_id v_training_class_instructor: One-to-Many (1:N) One class can have many instructors ...
v_training_certification_user
Purpose User training certification records. Relationships v_training_certification: Many-to-One (N:1) Many user certs link to one certification type Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many certifications held ...
v_trade_certification
Purpose Training certification records. Relationships v_training_certification_user: One-to-Many (1:N) One certification type can have many user certifications Referenced through training_certification_id v_personnel: Many-to-One (N:1) Many ...
v_trade
Purpose Shift trade records. Relationships v_personnel: Many-to-One (N:1) Many trades requested by one personnel Referenced through user_id v_personnel: Many-to-One (N:1) Many trades accepted by one personnel Referenced through accepting_user_id ...
v_time_off
Purpose Personnel time off records. Relationships v_personnel: Many-to-One (N:1) Many time off records link to one personnel Referenced through user_id v_personnel: Many-to-One (N:1) Many time off records approved by one personnel Referenced through ...
v_preplan_unit_history
Purpose Historical pre-plan unit information. Relationships v_preplan_unit: Many-to-One (N:1) Many history records link to one current unit Referenced through matching attributes Table Column Type Description id integer Primary key ...
v_preplan_unit
Purpose Pre-plan unit information. Relationships v_occupancy: Many-to-One (N:1) Many units link to one location Referenced through preplan relationship v_preplan_expiring_unit: One-to-One (1:1) Each unit may have one expiring record Referenced ...
v_preplan_last_completed
Purpose Last completed pre-plan information. Relationships v_personnel: Many-to-One (N:1) Many completions done by one personnel Referenced through preplan_last_completed_by v_occupancy: One-to-One (1:1) One completion links to one location ...
v_preplan_hazmat_history
Purpose Historical hazardous materials records. Relationships v_preplan_hazmat: Many-to-One (N:1) Many history records link to one current hazmat record Referenced through matching attributes v_occupancy: Many-to-One (N:1) Many hazmat histories link ...
v_preplan_hazmat
Purpose Hazardous materials in pre-plans. Relationships v_occupancy: Many-to-One (N:1) Many hazmat records link to one location Referenced through address_id v_preplan_expiring_hazmat: One-to-One (1:1) Each hazmat record may have one expiring record ...
v_preplan_expiring_unit
Purpose Expiring pre-plan unit information. Relationships v_occupancy: Many-to-One (N:1) Many units link to one location Referenced through preplan relationship v_preplan_unit: One-to-One (1:1) Each expiring unit links to one unit record Referenced ...
v_preplan_expiring_hazmat
Purpose Expiring hazardous materials in pre-plans. Relationships v_occupancy: Many-to-One (N:1) Many hazmat records link to one location Referenced through address_id v_preplan_hazmat: One-to-One (1:1) Each expiring hazmat links to one hazmat record ...
v_personnel_pay_rate
Purpose Personnel pay rate history. Relationships v_personnel: Many-to-One (N:1) Many pay rates link to one personnel Referenced through personnel_id v_fire_dept_user: Many-to-One (N:1) Many pay rates link to one user Referenced through user_id Table ...
v_personnel_nemsis_licensure
Purpose Personnel NEMSIS licensure records. Relationships v_personnel_nemsis: Many-to-One (N:1) Many licenses link to one NEMSIS record Referenced through personnel_nemsis_id v_personnel: Many-to-One (N:1) Many licenses link to one personnel ...
v_personnel_nemsis
Purpose Personnel NEMSIS certification details. Relationships v_personnel: Many-to-One (N:1) Many NEMSIS records link to one personnel Referenced through personnel_id v_personnel_nemsis_licensure: One-to-Many (1:N) One NEMSIS record can have many ...
v_personnel_employment_history
Purpose Personnel employment history records. Relationships v_personnel: Many-to-One (N:1) Many history records link to one personnel Referenced through user_id v_fire_dept_user: Many-to-One (N:1) Many history records created by one user Referenced ...
v_personnel
Purpose Personnel information and assignments. Relationships v_fire_dept_user: One-to-One (1:1) One personnel links to one user account Referenced through id/personnel_id f_all_schedule: One-to-Many (1:N) One personnel can have many schedules ...
v_permit_questions
Purpose Fire department permit questions and answers. Relationships v_fd_permit: Many-to-One (N:1) Many questions link to one permit Referenced through fd_permit_id Table Column Type Description id integer Primary key fd_permit_custom_question text ...
v_payroll_summary
Purpose Payroll summary records. Relationships v_personnel: Many-to-One (N:1) Many payroll records link to one personnel Referenced through user_id activity_type: Many-to-One (N:1) Many payroll records link to one activity type Referenced through ...
v_occupancy_history
Purpose Historical occupancy information. Relationships v_occupancy: Many-to-One (N:1) Many history records link to one occupancy Referenced through place_id Table Column Type Description id integer Primary key place_id integer Location reference ...
v_occupancy_contact
Purpose Contact information for occupancies. Relationships v_occupancy: Many-to-One (N:1) Many contacts link to one occupancy Referenced through place_id Table Column Type Description id integer Primary key contact_type_id integer Contact type ...
v_occupancy
Purpose Building and occupancy information. Relationships v_occupancy_contact: One-to-Many (1:N) One occupancy can have many contacts Referenced through place_id f_fire_inspection: One-to-Many (1:N) One occupancy can have many inspections Referenced ...
v_nfirs_firefighter_casualty_equipment
Purpose Equipment related to firefighter casualties. Relationships v_nfirs_firefighter_casualty: Many-to-One (N:1) Many equipment records link to one casualty Referenced through nfirs_firefighter_casualty_id Table Column Type Description id integer ...
v_nfirs_firefighter_casualty
Purpose Firefighter casualty records for NFIRS reporting. Relationships v_incident_report: Many-to-One (N:1) Many casualties link to one incident Referenced through incident_report_id v_nfirs_firefighter_casualty_equipment: One-to-Many (1:N) One ...
v_nfirs_ems_vital_sign
Purpose EMS vital signs records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many vital signs link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many vital signs taken by one provider Referenced ...
v_nfirs_ems_treatment
Purpose EMS treatment records for NFIRS reporting. Relationships v_nfirs_ems: Many-to-One (N:1) Many treatments link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many treatments performed by one provider Referenced ...
v_nfirs_ems_signature
Purpose Electronic signature records for EMS reports. Relationships v_nfirs_ems: Many-to-One (N:1) Many signatures link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many signatures created by one provider ...
v_nfirs_ems_medication
Purpose EMS medication administration records for NFIRS. Relationships v_nfirs_ems: Many-to-One (N:1) Many medications link to one EMS record Referenced through nfirs_ems_id v_personnel: Many-to-One (N:1) Many medications administered by one provider ...
v_nfirs_ems
Purpose EMS incident details for NFIRS reporting. Relationships v_incident_report_people: Many-to-One (N:1) Many EMS records link to one person Referenced through incident_report_people_id v_nfirs_ems_medication: One-to-Many (1:N) One EMS record can ...
v_nfirs_civilian_casualty
Purpose Civilian casualty records for incidents. Relationships v_incident_report: Many-to-One (N:1) Many casualties link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many casualties recorded by one personnel ...
v_life_hazard_use
Purpose Life safety hazard classifications. Relationships v_occupancy: One-to-Many (1:N) One hazard classification can apply to many occupancies Referenced through life_hazard_use_id Table Column Type Description id integer Primary key client_code ...
v_invoice_payment
Purpose Invoice payment records. Relationships v_invoice: Many-to-One (N:1) Many payments link to one invoice Referenced through invoice relationship Table Column Type Description id integer Primary key client_code varchar(28) Organization ID ...
v_invoice_line_item
Purpose Invoice line items details. Relationships v_invoice: Many-to-One (N:1) Many line items link to one invoice Referenced through invoice_id Table Column Type Description invoice_id integer Invoice reference client_code varchar(28) Organization ...
v_invoice
Purpose Invoice records. Relationships v_invoice_line_item: One-to-Many (1:N) One invoice can have many line items Referenced through invoice_id v_invoice_payment: One-to-Many (1:N) One invoice can have many payments Referenced through invoice_id ...
v_incident_report_station_response
Purpose Station response records for incidents. Relationships v_incident_report: Many-to-One (N:1) Many station responses link to one incident Referenced through incident_report_id v_personnel: Many-to-One (N:1) Many responses link to one personnel ...
v_incident_report_question
Purpose Incident report question responses. Relationships v_incident_report: Many-to-One (N:1) Many questions link to one incident Referenced through incident_report_id v_incident_report_apparatus: Many-to-One (N:1) Many questions link to one ...
Next page