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