medicationrequests.csv
This file contains information on the medication requests referenced in the FHIR bundle.
Columns
resource_id
string
The unique resource identifier from the FHIR bundle field medication.id.
authored_date
date
The date of the medication request, as specified by the FHIR bundle.
dispenserequest_start_date
date
Start date of the medication supply, as specified by the FHIR bundle.
dispenserequest_stop_date
date
Stop date of the medication supply, 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 request status, as provided by the source.
source_code, source_display, source_code_system, and source_code_text
string
The code, display, code system, and text of the medication, 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.
quantity
string
The requested quantity of the medication. This is from the medication resource’s dispenseRequest.quantity field, which is a decimal amount represented as a string.
requester_npi, requester_lastname, requester_firstname, requester_local_identifier, and requester_id
string
The NPI, name, local identifier and unique ID of the provider requesting the medication.
dosageinstruction_text
string
The text or sig of the dosage instruction for the medication.
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.
patient_id
string
The patient identifier of the patient for whom the medication request was documented. Uniquely identifies a row in patients.csv.
encounter_id
string
The encounter on which the medication request 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.