f_ecpr

f_ecpr

Purpose


  1. 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 have multiple complaints

    • Referenced through epcr_id

  • v_epcr_vital: One-to-Many (1:N)

    • One EPCR can have multiple vital signs

    • Referenced through epcr_id

  • v_personnel: Many-to-One (N:1)

    • Many EPCRs can be created by one personnel

    • Referenced through created_by

  • v_incident_report: Many-to-One (N:1)

    • Many EPCRs can be associated with one incident

    • Referenced through incident_report_id


Table


Column

Type

Description

id

integer

Primary key

client_code

varchar

Organization identifier

completed_at

timestamp

Completion timestamp

completed_by

integer

Completing user ID

completed_by_name

varchar

Completer name

created_at

timestamp

Creation timestamp

created_by

integer

Creator user ID

created_by_name

varchar

Creator name

updated_at

timestamp

Update timestamp

epcr_status

varchar

Report status

ems_status_id

integer

EMS status ID

cardiac_arrest_code

varchar

Cardiac arrest code

arrest_etiology_code

varchar

Arrest etiology code

resuscitation_attempts_codes

varchar[]

Resuscitation attempts

witnessed_by_codes

varchar[]

Witness codes

cpr_prior_to_arrival_code

varchar

Prior CPR code

aed_prior_to_arrival

varchar

Prior AED use

types_cpr_provided_codes

varchar[]

CPR types provided

first_monitored_rhythm_code

varchar

First rhythm code

is_rosc_codes

varchar[]

ROSC status codes

arrest_at

timestamp

Arrest timestamp

reason_for_discontinuation_code

varchar

Discontinuation reason

rhythm_at_destination_codes

varchar[]

Destination rhythm codes

end_of_cardiac_arrest_code

varchar

End status code

complaint_reported_dispatch_code

varchar

Dispatch complaint

emd_performed_code

varchar

EMD performance code

dispatch_priority_code

varchar

Priority code

patient_last_name

varchar

Patient last name

patient_first_name

varchar

Patient first name

gender_code

varchar

Gender code

age

integer

Patient age

age_unit_code

varchar

Age unit

birth_date

date

Birth date




    • Related Articles

    • 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_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_schedule

      Purpose Personnel scheduling fact table. Relationships v_personnel: Many-to-One (N:1) Many schedules link to one personnel record Referenced through personnel_id v_fire_dept_user: Many-to-One (N:1) Many schedules link to one user Referenced through ...

    • 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: ...

    • 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 ...