Formulary CSV Import v2
Minimum CorEMR Version: 5.2
Maximum CorEMR Version: 5.5
Deprecated
This specification is for historical purposes only and should not be used. The Formulary V3 format format supercedes this one.
Format
The file must be a Comma-Separated Value file (CSV) with the 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.
Matching
CorEMR will attempt to match the NDC Number with existing formulary entries. If found, the formulary entry will be updated. If not found, a new entry is created.
Column Mapping
| Column | Field | Datatype | Required | Notes |
|---|---|---|---|---|
| 1 | Generic Name | String(255) | R | |
| 2 | Strength | String(255) | R | |
| 3 | Form | String(255) | R | |
| 4 | Brand Name | String(255) | ||
| 5 | NDC Number | String(11) | R | |
| 6 | Pharmacy Drug Units | Float | R | |
| 7 | OTC (NYI) | Bool | R | Not yet implemented. |
| 8 | Preferred by Pharmacy | Bool | R | |
| 9 | Pharmacy Drug Cost | Float | ||
| 10 | RX Norm ID | Integer | ||
| 11 | Agency | String |
Example
We recommend headerless CSV files to reduce redundant data.
"ARIPIPRAZOLE","15MG","TAB","ABILIFY","13668021990","90.0000","0","0","","",""
"HALOG","0.1%","CRE","HALCINONIDE","10631009430","60.0000","0","0","","",""