Active Medication CSV Import
Minimum CorEMR Version: 5.2
Prerequisites
CorEMR requires patients and all possible providers be in the system before importing medications.
Format
The file must be a Comma-Separated Value file (CSV) with the text, number, and order of columns exactly as listed. The columns marked Required must have the specified type of data present or importing will not occur. All other columns may be left blank, but must still be present in the file. If a field is not able to be included and is not required, that field should be left blank.
Patient Matching
CorEMR will attempt to match the Patient ID/Booking Number field with an existing chart in the system. The field CorEMR will match on is selectable when importing.
Provider Matching
CorEMR will attempt to match the Provider DEA field with an existing provider in the system.
Column Mapping
| Column | Field | Datatype | Required | Notes |
|---|---|---|---|---|
| 1 | RX Number | String(255) | Y | Unique patient prescription number. |
| 2 | Patient ID | String(32) | Y | Patient’s unique number used to track the individual across all bookings. |
| 3 | Medication Generic Name | String(255) | Y | |
| 4 | Medication Brand Name | String(255) | ||
| 5 | Medication NDC | String(11) | ||
| 6 | Medication Strength | String(255) | Y | |
| 7 | Medication Form | String(255) | Y | |
| 8 | Total Doses | Integer | Y | |
| 9 | Units per Dose | Integer | Y | |
| 10 | Route | String(255) | Y | |
| 11 | Signature | String(255) | Y | |
| 12 | Expanded Signature | String(255) | Not Yet Implemented | |
| 13 | Provider Last Name | String(255) | Y | |
| 14 | Provider First Name | String(255) | Y | |
| 15 | Provider DEA | String(9) | Y | |
| 16 | Date Prescribed | Date | Y | |
| 17 | Start Date | Date | Y | |
| 18 | End Date | Date | Y | |
| 19 | Refills | Integer | Y | If number of refills is unknown, this may be set to 0, but none of the imported medications in CorEMR will be refillable. |
Example
RX Number,Patient ID,Medication Generic Name,Medication Brand Name,Medication NDC,Medication Strength,Medication Form,Total Doses,Units per Dose,Route,Sig,Expanded Sig,Provider Last Name,Provider First Name,Provider DEA,Date Prescribed,Start Date,End Date,Refills
"123456","45678","MedroxyPROG 150mg Syr","","59762453802","150MG/ML","INJ","0.01","1","IM","INJECT 150MG IM EVERY 3 MONTHS","INJECT 150MG IM EVERY 3 MONTHS","SMITH","JOHN","#######","20150114","20150119","20150317","0"
"123456","45678","Doxepin 50mg Capsule","Sinequan","59762453802","50MG","CAP","1","1","ORALLY","TAKE ONE CAPSULE(S) ORALLY AT BEDTIME","TAKE ONE CAPSULE(S) ORALLY AT BEDTIME","SMITH","JOHN","#######","20150114","20150119","20150317","1"