medicationadministrations

The medicationadministrations manages information about the administration of a single dose of a medication, usually as part of a hospitalization. Medicationadministrations are delivery instances of medicationprofiles that describe multi-instance medication instructions.

Table Schema

Name Type Description
id VARCHAR

Surrogate key. Primary key for the medicationadministrations table.

scheduledtime VARCHAR

The time that the dose was scheduled for administration.

dosestarttime VARCHAR

The beginning of the period over which the dose was administered.

doseendtime VARCHAR

The end of the period over which the dose was administered.

dose NUMERIC

If applicable, the amount of the dose.

doserate NUMERIC

If applicable, the rate of the dose.

volume NUMERIC

If applicable, the volum of the dose.

fluidrate NUMERIC

If applicable, the rate of the dose.

ivbagnumber INTEGER

If applicable, the number of the iv bag used to deliver the dose.

waste VARCHAR

A text field for supplemental information about the dose.

response VARCHAR

A text field for supplemental information about the patient’s response to the dose.

comment VARCHAR

A text field for supplemental information about the dose.

quantityperdose VARCHAR

If applicable, quantity of substance administer in each dose.

lotnumber VARCHAR

A text field for supplemental information about the dose.

expirationdate VARCHAR

If recorded, the expiration date of the medication provided.

medicationprofile_id VARCHAR

Surrogate key. Foreign key reference to medicationprofiles.id

statusterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

doseunitsterm_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

fluidrateunitsterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

ivflowtypeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

routeterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

methodterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

siteterm_id INTEGER

Surrogate key. Foreign key reference to terms.id

caregiver_id VARCHAR

Surrogate key. Foreign key reference to caregivers.id

reasongiventerm_id INTEGER

Surrogate key. Foreign key reference to terms.id

reasonnotgiventerm_id INTEGER

Surrogate key. Foreign key reference to terms.id

patient_id VARCHAR

Surrogate key. Foreign key reference to patients.id

encounter_id VARCHAR

Surrogate key. Foreign key reference to encounters.id

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

tenant_id SMALLINT

Surrogate key. Foreign key reference to tenants.id


Back to Tables