v_epcr_consumable

v_epcr_consumable

Purpose

  1. Tracks consumable items used during patient care.

Relationships


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

    • Many consumables link to one EPCR

    • Referenced through epcr_id

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

    • Many consumables link to one inventory item

    • Referenced through name matching


Table


Column

Type

Description

id

integer

Primary key

epcr_id

integer

EPCR reference

client_code

varchar(28)

Organization ID

name

varchar(255)

Item name

quantity

integer

Quantity used

created_at

timestamp

Creation timestamp

patient_first_name

varchar(50)

Patient first name

patient_last_name

varchar(60)

Patient last name






    • Related Articles

    • v_epcr_history_medication

      Purpose Patient medication history records. Relationships f_epcr: Many-to-One (N:1) Many medication histories link to one EPCR Referenced through epcr_id v_epcr_history: Many-to-One (N:1) Many medications link to one history record Referenced through ...

    • v_epcr_disposition_team

      Purpose Patient care team disposition records. Relationships f_epcr: Many-to-One (N:1) Many dispositions link to one EPCR Referenced through epcr_id v_personnel: Many-to-Many (N:M) Many dispositions can involve many personnel Referenced through team ...

    • v_epcr_history

      Purpose Patient medical history records. Relationships f_epcr: Many-to-One (N:1) Many history records link to one EPCR Referenced through epcr_id v_epcr_history_medication: One-to-Many (1:N) One history record can have many medication records ...

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

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