v_epcr_other_crew

v_epcr_other_crew

Purpose

  1. 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 state_licensure_id_number



Table



Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

protective_equipment_codes

varchar(20)[]

Equipment codes

state_licensure_id_number

varchar(50)

License number

injury_exposure_type_codes

varchar(20)[]

Exposure codes

state_ems_certification_licensure_level_code

varchar(20)

Certification level

suspected_ems_work_code

text

Work code

created_at

timestamp

Creation timestamp





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

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

      Purpose To explain how to complete the Response section of an ePCR. Related Articles Completing an ePCR - 1. Response (This Article) Completing an ePCR - 2. Information Completing an ePCR - 3. Assessment Completing an ePCR - General Assessment ...

    • Setting up the ePCR - Form Language

      Purpose Form Language is the information displayed to a person signing (patient, crew member, nurse, etc.) when the signature box is presented to the signer. Use Form Language to create forms for each situation in which a signature may be obtained. ...

    • v_epcr_exam

      Purpose Patient examination records. Relationships f_epcr: Many-to-One (N:1) Many exams link to one EPCR Referenced through epcr_id v_epcr_vital: One-to-Many (1:N) One exam can have many vital sign records Referenced through timeline relationship ...