Electronic Health Information Export File Detail
| Medications.CSV |
| This file contains information about medication details for patients, including medication name, dosage, frequency, Sig, Prescribing Provider and other related data. |
| MRNumber |
varchar |
Patient ID (MRNumber) |
| Medication |
varchar |
Medication Name/Description |
| Medication Name |
varchar |
Name of the medication. Example: "Aspirin", "Ibuprofen", "Paracetamol" |
| Medication ID |
varchar |
First Databank Medication Id |
| Start Date |
varchar |
Start date of the medication Example: "2021-05-30", "2021-06-30" |
| End Date |
varchar |
End date of the medication Example: "2021-06-30", "2021-07-30" |
| Sig |
varchar |
Medication Intructions |
| Route |
varchar |
Route for medication. Example: "Oral", "Intravenous", "Injection" |
| Unit |
varchar |
Medication Strength / Unit |
| Unit of Measurement |
varchar |
Unit of Measurement for Medication |
| RXNorm Code |
varchar |
RXNorm ID |
| Ordering Provider |
varchar |
Provider that prescribed the medication |
| Active |
int |
Active Flag "0=Active, 1=Inactive, -1=Deleted" |