f_epcr_crew

f_epcr_crew

Purpose

  1. 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 link to one personnel

    • Referenced through crew member identification



Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

crew_member_response_role_codes

varchar[]

Response roles

state_licensure_id_number

varchar

License number

state_licensure_name

varchar

License name

state_ems_certification_licensure_level_code

varchar

Certification level

client_code

varchar

Organization identifier

created_at

timestamp

Creation timestamp

patient_first_name

varchar

Patient first name

patient_last_name

varchar

Patient last name




    • Related Articles

    • v_epcr_other_crew

      Purpose Additional crew member records for patient care. Relationships f_epcr: Many-to-One (N:1) Many crew records link to one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many crew records link to one personnel Referenced through ...

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

    • v_epcr_procedure

      Purpose Patient care procedure records. Relationships f_epcr: Many-to-One (N:1) Many procedures link to one EPCR Referenced through epcr_id v_personnel: Many-to-One (N:1) Many procedures performed by one personnel Referenced through ...

    • Completing an ePCR - Response

      Completing an ePCR - Response Purpose Statement To explain how to complete the Response section of an ePCR (electronic Patient Care Record) in First Due. This section captures critical incident response data including crew information, dispatch ...

    • Resolving QA/QI comments - Crew Members

      Purpose Statement This article demonstrates the process for resolving QA/QI comments from the perspective of the ePCR report author, ensuring proper response to reviewer feedback and maintaining quality documentation standards. Background Information ...