medicationdispense

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

  • HIEBus medications

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