Clinically Enhanced Data

Minnesota Hosptial Association Logo

AHRQ MHA Logo

Rx Data Requirements

8/16/2012

Rx Data Requirement Notes:

• Fields 1 (MHA Hospital ID), 2 (Medical Record Number), 3 (Patient Account Number), and 7 (Admit Date/Time) are required to link to the UB data.
• If only ADHF (Acute Decompensated Heart Failure) data is included, patients with any of the following ICD-9-CM codes as a principal diagnosis should be included:
  • 428.xx heart failure
  • 398.91 rheumatic heart failure
  • 402.01, 402.11, 402.91 hypertensive heart failure
  • 404.01, 404.03, 404.11, 404.13, 404.91, 404.93 hypertensive heart failure and kidney failure
• Optionality: R=Required, O=Optional, C=Conditional
• Note: The Pharmacy data focus is on Drug Orders and not Drugs Administered.

Data Field Notes:

1. MHA Hospital ID
   3-digit number assigned to your hospital by MHA. Same as UB data.
2. Medical Record Nubmer
3. Patient Account Number
   Can be hospital internal number. Same as UB data.
4. Patient Date of Birth
5. Patient Sex
   
   Reference Table 1:

A	Ambiguous
F	Female
M	Male
N	Not applicable
O	Other
U	Unknown




6. Patient Social Security Number
   Only include last 4 digits.
7. Admit Date/Time
8. Discharge Date/Time
9. Rx Order Number
   This may be a unique, internal number assigned to the order by the hospital/pharmacy system.
10. Order Type
    
    Reference Table 2:

I	Inpatient Order
O	Outpatient Order
P	Patient Reported

Required if sending more than inpatient orders (such as discharge medications). If your system is not able to send in this format, we can map if provided with your data definitions.

11. Ordering Provider
    Prefer NPI.
12. Date/Time of Order
13. Strength
    The strength of the medication. E.g., "500" (for 500MG).
14. Strength Units
    The unit of measure for the strength. Reference Table 3:

Reference Table 3:

15. Order Start Date
    Used to specify the first date/time that the medication should be administered
16. Order End Date
    Used to specify the date/time that the medication should be discontinued (not administered). Either End Date or Duration is required.
17. Duration
    Used to specify the number of days that the medication should be administered. Either Duration or End Date is required.
18. Drug ID
    Internal hospital drug number.
19. Drug Code
    RxNorm or NDC or SNOMED code for this drug order. Required if available.
20. Drug Name
    Text description of the drug referred to in #18 and #19.
21. Give Amount Minimum
    For varying amount orders, this should be the minimum amount of medication to be given to the patient per dose. For non-varying order, it is the exact amount to be given with each dose. The give amount may refer to a strength, volume, or number of tablets/capsules, etc. For example, for a dosage of Tylenol 650mg, the patient might receive two 325mg tablets per dose. The give amount, in this case, could be "650" or "2". The unit of measure in each case (e.g., mg or tablets) will be defined in the "Give units" (see #22).
22. Give Amount Maximum
    In a varying amount order, this is the maximum ordered amount of medication to be given with each dose. In a non-varying dose order, this field can also contain the exact amount, but this is optional. If the maximum dose is the same as the minimum dose, this will be interpreted as being an order with non-varying dosage amounts.
23. Give Units
    This field clarifies the unit of measure for the Give minimum/maximum and Strength Units fields. See Reference Table 3 above.
24. Route Code
    Reference table 4:

HL7 TABLE 162 - ROUTE OF ADMINISTRATION

25. Route Text
    Text description of Route Code, #24.
26. Interval
    Code for the frequency (interval) in which the drug is to be administered. Also note #29, PRN.
    Reference table 5:

27. Order Status
    Reference Table 6:

28. Component
    Is this a component of a compound drug? "Y" or "N". Required if "Y".
29. PRN
    Is this prescription PRN (as needed)? "Y" or "N". Required if "Y".
30. Patient Allergies
    Text description of any allergy information for this patient.
31. Comments