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.
|
| rxnormdisplay |
VARCHAR |
Mapped by Rosetta. The description for the RxNorm CUI.
|
| 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