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

    • Setting up the ePCR - Devices

      Purpose To explain how to enter the data elements of the Devices section of your EMS Setup. Related Articles Setting up the ePCR - Demographics Setting up the ePCR - EMS Contacts Setting up the ePCR - Vendor Directory Setting up the ePCR - Protocols ...

    • Setting up the ePCR - Statistics

      Purpose To explain how to enter the data elements of the Statistics section of your EMS Setup. Related Articles Setting up the ePCR - Demographics Setting up the ePCR - EMS Contacts Setting up the ePCR - Vendor Directory Setting up the ePCR - ...

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