The medicationdispense
table is related to the MedicationDispense resource that is available via the FHIR API.
The medicationdispense
table represents filled prescriptions for a person
, determined from pharmacy claims.
See also:
Source Concepts
Table Schema
Name |
Type
|
Description |
personid |
VARCHAR(38) GUID |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
medicationdispenseid |
VARCHAR(38) GUID |
Internal identifier of the HIEBus source row.
|
code |
VARCHAR |
Mapped by Rosetta. The primary mapped terminology code determined to represent the prescription. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
display |
VARCHAR |
Mapped by Rosetta. The primary mapped terminology description determined to represent the prescription. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
codesystem |
VARCHAR |
Mapped by Rosetta. The terminology namespace of the code field. This is the preferred mapped concept determined by the Rosetta Terminology Service.
|
rxnormcode |
VARCHAR |
Mapped by Rosetta. The RxNorm CUI determined to represent the prescription.
|
termid |
INTEGER |
A reference to the original primary term that can be used to show the original code or relate to alternative mappings.
|
alternatetermids |
VARCHAR |
A comma delimited list of termids that provide supplemental terms (usually in alternate coding systems) to represent the prescription.
|
whenhandedover |
TIMESTAMP |
The date the prescription is filled and given to the person.
|
stopdate |
TIMESTAMP |
Determined via days supplied or quantity. The estimated date at which the supplied medication would be exhausted.
|
quantity |
DECIMAL |
Amount dispensed.
|
dayssupplied |
DECIMAL |
The expected number of days for which the supplied quantity is expected to last.
|
claimid |
VARCHAR(38) GUID |
Source claim, if determined from an claim-based data source.
|
encounterid |
VARCHAR(38) GUID |
Source encounter, if determined from an encounter-based data source.
|
datasource |
VARCHAR |
The name of the external data source. Commonly determined from the namespace of the source terminology namespace.
|
prescriberidentifier |
VARCHAR |
The identifier assigned to the primary provider associated with the prescription.
|
prescribername |
VARCHAR |
The name of the primary provider associated with the prescription.
|
lastupdated |
TIMESTAMP |
System generated timestamp indicating the most recent change to this data row. Used for differential operations. Managed in UTC.
|
Back to Tables