For AI agents: the documentation index is at /docs/payerbox/llms.txt. A Markdown version of this page is available at /docs/payerbox/data-integration/uscdi/medications.md or by requesting it with the Accept: text/markdown header.
Payerbox Docs

Medications

Datasets

US Core 6.1.0 maps each USCDI element to FHIR.

medications

One row per medication order: the prescriber's intent, with drug, dose, and indication. For most payers this file is sparse or empty — orders live in EHR and e-prescribing systems, not in claims. If your medication data comes from pharmacy claims, it belongs in medication_dispenses; populate this file only with order-level data you actually hold.

ColumnRequiredFormat / valuesExample
record_idYesyour stable key for this order; medication_dispenses reference itMED-77120
patient_identifierYespatient keyMRN-4471903
statusYesactive, on-hold, cancelled, completed, entered-in-error, stopped, draft, unknown medicationrequest-statusactive
intentYesproposal, plan, order, original-order, reflex-order, filler-order, instance-order, option medicationrequest-intentorder
medication_codeYesRxNorm drug-level code, with medication_system (RxNorm assumed when empty) Medication Clinical Drug310965 ibuprofen 200 MG oral tablet
categoryIf availableinpatient, outpatient, community, discharge medicationrequest-categoryoutpatient
reportedRecommendedtrue / falsefalse
authored_onRecommendeddatetime2026-05-30
requester_npiRecommended10 digits9999999991
encounter_idIf applicableencounters keyENC-9912
dosage_textRecommendedthe sig, free text1 tab PO daily
dose_valueIf availabledecimal200
dose_unitIf dose_valueUCUM ucum-commonmg
refills_allowedIf availableinteger3
dispense_quantity_valueIf availabledecimal30
dispense_quantity_unitIf dispense_quantity_valueUCUM ucum-common{tbl}
indication_codeIf availableSNOMED CT or ICD-10-CM code, with indication_system (SNOMED CT assumed when empty) us-core-condition-code38341003 hypertensive disorder
is_deletedIf retractingtrue retracts this rowtrue
  • medication_code is the one coded field with no fallback: a row without it cannot become a MedicationRequest. The value set holds RxNorm codes at the prescribable-product level — a clinical or branded drug, not the bare ingredient. Send medication_system as http://www.nlm.nih.gov/research/umls/rxnorm.
  • status carries history: closed orders arrive as completed, stopped, or cancelled; entered-in-error retracts a record that should never have existed.
  • reported set to true marks an order known secondhand — reported by the member or imported from another system — rather than authored in the system that sent it.
  • dosage_text is the sig as written and the most valuable of the dose columns; dose_value + dose_unit are its structured counterpart, the USCDI Dose and Dose Unit of Measure elements. UCUM count units use curly braces: {tbl} tablets.
  • refills_allowed and the dispense_quantity_* pair describe what the order authorizes the pharmacy to dispense — refills and amount per fill.
  • requester_npi is the prescriber and must match a row in practitioners.

medication_dispenses

One row per fill: what the pharmacy actually handed over. For a payer this is usually the primary medication file — pharmacy claims are fill records. It carries the USCDI Medications (Fill Status) element and stays distinct from the order in medications.

ColumnRequiredFormat / valuesExample
record_idYesyour stable key for this fillMD-0001
patient_identifierYespatient keyMRN-4471903
statusYespreparation, in-progress, cancelled, on-hold, completed, entered-in-error, stopped, declined, unknown medicationdispense-statuscompleted
medication_codeYesRxNorm drug-level code, with medication_system (RxNorm assumed when empty) Medication Clinical Drug310965 ibuprofen 200 MG oral tablet
type_codeIf availablefill type: FF first fill, RF refill, EM emergency supply, UD unit dose ActPharmacySupplyTypeRF
pharmacy_org_npiRecommended10 digits9999999993
performer_npiIf available10 digits, the dispensing pharmacist9999999991
authorizing_prescription_idIf availablerecord_id of the medications rowMED-77120
quantity_valueIf availabledecimal30
quantity_unitIf quantity_valueUCUM ucum-common{tbl}
when_handed_overIf availabledatetime2026-06-01
dosage_textIf availablethe sig, free text1 tab PO daily
is_deletedIf retractingtrue retracts this rowtrue
  • status is the Fill Status element: completed for a fill picked up, in-progress or preparation for one underway, declined for one refused, entered-in-error to retract. The binding is required, so a value outside the list is rejected.
  • A pharmacy-claim row that carries only an NDC may send it with medication_system as http://hl7.org/fhir/sid/ndc; Payerbox crosswalks it to the RxNorm coding US Core requires.
  • pharmacy_org_npi is the dispensing pharmacy and performer_npi the dispensing pharmacist, when your source records one; both become MedicationDispense.performer.actor and must match a row in organizations and practitioners respectively. Pharmacy claims usually identify only the store — sending just pharmacy_org_npi is fine.
  • when_handed_over is when the medication left the pharmacy — for a claim, the fill date.

These resources are served by Patient Access, Provider Access, and Payer-to-Payer.

Last updated: