The medications table manages paid medication claims that indicate a medication dispense event- the specified patient has filled a prescription and obtained the specified medication.
| Name |
Type
|
Description |
| id |
VARCHAR |
Surrogate key. Primary key for the medications table.
|
| date |
VARCHAR |
The date the prescription was filled.
|
| refills |
INTEGER |
The number of refills permitted by this medication prescription.
|
| quantity |
NUMERIC |
The number of pills or items dispensed.
|
| dayssupplied |
INTEGER |
The number of days that the patient is supplied with this medication if the administration instructions are followed.
|
| prescribeddate |
VARCHAR |
The date that the presciption was created by a provider.
|
| identifier |
VARCHAR |
An identifier provided by the dispensing information system to uniquely identify this medication dispense event.
|
| dose |
NUMERIC |
The amount (interpreted with unitsterm_id) of the medication in each pill or item.
|
| isgeneric |
VARCHAR |
The dispensed medication is a generic.
|
| comment |
VARCHAR |
A human-readable text field with additional information about the medication dispense event.
|
| amountpaid |
NUMERIC |
Payment information related to the medication dispense event.
|
| amountbilled |
NUMERIC |
Payment information related to the medication dispense event.
|
| refillnumber |
SMALLINT |
If the prescription permits refills, the refill number.
|
| patient_id |
VARCHAR |
Surrogate key. Foreign key reference to patients.id
|
| encounter_id |
VARCHAR |
Surrogate key. Foreign key reference to encounters.id
|
| term_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| therapeuticclassterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| caregiver_id |
VARCHAR |
Surrogate key. Foreign key reference to caregivers.id
|
| unitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| claim_id |
VARCHAR |
Surrogate key. Foreign key reference to claims.id
|
| frequencyterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| statusterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| filledbycaregiver_id |
VARCHAR |
Surrogate key. Foreign key reference to caregivers.id
|
| doseunitsterm_id |
INTEGER |
Surrogate key. Foreign key reference to terms.id
|
| reconcilestatusterm_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.
|
| alternateidentifier |
VARCHAR |
An identifier provided by the dispensing information system to uniquely identify this medication dispense event.
|
| strength |
VARCHAR |
The strength of the medication dispensed.
|
| dispenseaswritten |
VARCHAR |
Supplemental instructions for the medication claim to allow/disallow generic substitutions.
|
| 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
|
| properties |
VARCHAR |
Additional properties that describe the medication event managed as xml.
|
| sequence |
INTEGER |
If applicable, the sequence the medication appears on the related claim.
|
