medicationdispenses.csv
This file contains information on the instances of a medication being dispensed referenced in the FHIR bundle. These could be from a hospital, pharmacy, etc.
Columns
resource_id
string
The unique resource identifier from the FHIR bundle field medicationdispenses.id.
prepared_date
date
The date when the dispense was packaged or prepared, as specified by the FHIR bundle.
handedover_date
date
The date when the dispense was given, as specified by the FHIR bundle.
encounter_date
date
The admit date of the encounter during which the medication request was documented, as specified by the FHIR bundle.
status_code, status_display, and status_code_system
string
The code, display, and code system of the medication dispense status, as provided by the source.
notperformedreason_code, notperformedreason_display, and notperformedreason_code_system
string
The code, display, and code system of why medication dispense was not performed, as specified by the FHIR bundle.
category_code, category_display, and category_code_system
string
The code, display, and code system of the medication dispense’s category, as specified by the FHIR bundle. This indicates the setting where the medication is consumed.
source_code, source_display, source_code_system, and source_code_text
string
The code, display, code system, and text of the medicationdispense, as provided by the source.
rxnormcode[N] and rxnormdisplay[N]
string
The code and display of any RxNorm codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., rxnormcode1 and rxnormdisplay1, rxnormcode2 and rxnormdisplay2, etc.
ndccode[N] and ndcdisplay[N]
string
The code and display of any NDC codes that Orchestrate derived from the source code and uplift. Each pair will be numbered sequentially, e.g., ndccode1 and ndcdisplay1, ndccode2 and ndcdisplay2, etc.
authorizingprescription_id
string
The medication request identifier for the medication. If set, it identifies a row in medicationrequests.csv.
type_code, type_display, type_code_system, and type_code_text
string
The code, display, code system and text of the medicationdispense’s type, as specified by the FHIR bundle. This indicates the fill type.
quantity_value
decimal
The amount dipensed as a physical quantity, if provided by the source.
quantity_unit_code, quantity_unit_display, and quantity_unit_code_system
string
The code, display, and code system components of the dipensed amount’s unit of measurement.
dayssupply_value
decimal
The amount of medication expressed as timing, if provided as a physical quantity by the source
dayssupply_unit_code, dayssupply_unit_display, and dayssupply_unit_code_system
string
The code, display, and code system components of the medication supply timing’s unit of measurement.
note
string
Any additional information about the medication dispense, as specified by the FHIR bundle.
dosageinstruction_text
string
The text or sig of the dosage instruction for the medication that was dispensed.
dosageinstruction_dose_value, dosageinstruction_dose_unit
string
The dose of the medication, along with the unit of measurement, if provided by the source.
dosageinstruction_route_code, dosageinstruction_route_display, and dosageinstruction_route_code_system
string
The code, display, and code system of the route of administration for the medication.
refills
decimal
Number of refills, if provided by the source. This might be populated if FHIR bundle is sourced from a CDA document.
refillnumber
decimal
The refill number of medicationdispense, if provided by source. This might be populated if FHIR bundle is sourced from a CDA document.
performer_npi, performer_lastname, performer_firstname, performer_local_identifier, and performer_id
string
The NPI, name, local identifier, and unique ID of the provider performing the medication administration.
patient_id
string
The patient identifier of the patient for whom the medication dispense was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the medication dispense was documented. Uniquely identifies a row in encounters.csv.
metadata_id
string
Reflects the origin of the data. Uniquely identifies a row in metadata.csv.