Roster-based CSV Integration
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.
Releases
If your CSV does not include Release Date, CorEMR will "sync" the active population with the full list. Please indicate to CorEMR if your export will be including the Release Date; we will default to assuming you will, which will result in patients not being released from the system.
Preloading
A preload file is not required when using a Roster-based CSV integration.
Column Mapping
| Column | Field | Datatype | Required | Notes |
|---|---|---|---|---|
| 1 | Last Name | String(255) | R | |
| 2 | First Name | String(255) | R | |
| 3 | Middle Name | String(255) | ||
| 4 | Patient ID | String(17) | R | Patient’s unique number used to track the individual across all bookings. |
| 5 | Birth Date | Date | R | |
| 6 | SSN | String(11) | SSNs only benefit detecting merge candidates and is not recommended to be transmitted. | |
| 7 | Sex | String(7) | R | "Male", "Female", or "Unknown". |
| 8 | Race | String(255) | "American Indian or Alaskan Native", "Asian", "Black or African American", "Native Hawaiian or Other Pacific Islander", or "White". | |
| 9 | Facility | String(32) | R | Determines CorEMR facility patient belongs in. Unused in single-facility installations. |
| 10 | Agency | String(255) | Billing Agency: String passed to pharmacy for billing purposes. Example: ICE, USM, County, etc. | |
| 11 | Housing | String(127) | R | |
| 12 | Bed | String(127) | ||
| 13 | Booking Number | String(32) | R | |
| 14 | Booking Date | Datetime | R | |
| 15 | Release Date | Datetime | ||
| 16 | Height | Integer | Measured in inches. | |
| 17 | Photo Path | String(255) |
Examples
Minimal Example
This lists an example of the bare minimum data one row can contain.
"Smith","Samuel","","344560","1995-08-20","","Male","","FACTEST","","BLOCK","","2018060612341","2018-06-06T12:34","","",""
Extended Example
"Jasperson","Peter","James","356009","1992-11-16","555555555","Male","White","FACTEST","ICE","Block","Pod 4 : Cell 6","2017122516201","2018-06-06T16:20","","70","exampleface.jpg"