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.
medication_authoreddate
date
The date of the medication request, as specified by the FHIR bundle.
medication_dispenserequest_startdate
date
Start date of the medication supply, as specified by the FHIR bundle.
medication_dispenserequest_stopdate
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_code_system, and status_display
string
The code, display, and code system of the medication request status, as provided by the source.
source_code, source_display, and source_code_system
string
The code, display, and code system 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.
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.
datasource
string
Reflects the origin of the data. This may have been set in one of the previous convert operations. See Data Source.