Pharma Table

Field NameTypeModificationsComment
patientid
integer
mapped id
pharmaid
integer
See reference file (hirid_variable_reference.csv) for pharma id lookup.
givenat
timestamp
timeshift
Time of administration
enteredentryat
timestamp
timeshift
Time point the entry was made into the data base
givendose
float
Unit see doseunit
cumulativedose
float
Cumulative dose given since the start of the infusion (Infusion ID)
fluidamount_calc
double
calculated
Unit is Milliliters. This is a calculated value from the source system and is not reliable in some of the cases when drugs (not fluids) are given.
cumulfluidamount_calc
double
calculated
Unit is Milliliters. Sum of all fluidamount_calc for this infusionid.
doseunit
string
Unit of givendose and cumulativedose
route
string
infusionid
long
mapped id
Unique ID of infusion.
typeid
short
0=Fluids 1=Drugs
subtypeid
double
0=crystalloid 1=blood product 2=colloid 3=enteral 4=parenteral 5=concentrate 7=other 8=drug
recordstatus
short
2=invalidated 4=start 8=record 32=notified, not administered 256=stop 512=include in record reports