The medicationprofiles table manages instructions to administer a specified medication to a specified patient over time. A medicationprofile is a prescription or fully qualified medication order with administration instructions. Specific instances of medication delivery that implement the medicationprofile are managed in the medicationadministrations table.
| Name |
Type
|
Description |
| id |
VARCHAR |
Surrogate key. Primary key for the medicationprofiles table.
|
| identifier |
VARCHAR |
A unique identifier provided by the source information system to identify this medication profile.
|
| mindose |
NUMERIC |
Minimum dose.
|
| maxdose |
NUMERIC |
Maximum dose.
|
| strength |
VARCHAR |
Dose strength.
|
| doserate |
NUMERIC |
Dose rate.
|
| volume |
NUMERIC |
Dose volume.
|
| dispenseamount |
NUMERIC |
Dispense amount.
|
| starttime |
VARCHAR |
Start of the period to which this medication instruction applies.
|
| stoptime |
VARCHAR |
End of the period to which this medication instruction applies.
|
| deliverytimes |
VARCHAR |
A comma separated list of times at which the medication should be administered.
|
| sunday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| monday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| tuesday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| wednesday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| thursday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| friday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| saturday |
VARCHAR |
T/F. T to instruct delivery of the medication on this day of the week.
|
| substitution |
VARCHAR |
T/F. T if a substitution is permitted.
|
| instructions |
VARCHAR |
Human readable supplemental instructions that describe how the medication should be administered.
|
| isprn |
VARCHAR |
T/F. T if the medication should be administered as needed.
|
| quantityperdose |
VARCHAR |
Dose quantity.
|
| patient_id |
VARCHAR |
Surrogate key. Foreign key reference to patients.id
|
| encounter_id |
VARCHAR |
Surrogate key. Foreign key reference to encounters.id
|
| order_id |
VARCHAR |
Surrogate key. Foreign key reference to orders.id
|
| caregiver_id |
VARCHAR |
Surrogate key. Foreign key reference to caregivers.id
|
| medicationterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| doseunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| strengthunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| doserateunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| volumeunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| routeterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| adminmethodterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| adminsiteterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| dispenseunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| frequencyterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| inserteddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was first inserted into HIEBus.
|
| insertedbyapplication_id |
SMALLINT |
The application that first inserted the row into HIEBus. Foreign key reference to applications.id.
|
| insertedbyuser_id |
VARCHAR |
The user associated with the process that first inserted the row into HIEBus. Foreign key reference to users.id.
|
| modifieddate |
TIMESTAMP |
Timestamp (UTC) indicating the date the row was last modified.
|
| modifiedbyapplication_id |
SMALLINT |
The application that last modified the row. Foreign key reference to applications.id.
|
| modifiedbyuser_id |
VARCHAR |
The user associated with the process that last modified the row. Foreign key reference to users.id.
|
| medicationtext |
VARCHAR |
A supplemental text field to describe the medication that is to be administered.
|
| medicationalternateterms |
VARCHAR |
An xml representation of additional terms that were sent by the source system to describe the medication.
|
| datasource_id |
VARCHAR |
Surrogate key. Foreign key reference to datasources.id. The external data source from which the data in this row originated.
|
| tenant_id |
SMALLINT |
Surrogate key. Foreign key reference to tenants.id
|
