Patient Import CSV

Minimum CorEMR Version: 5.2

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

When importing this file, CorEMR will attempt to find an existing chart matching the given Patient ID value. If not found, a new chart and booking entry will be created. If found, that row is skipped. This means this format only works for importing patient data once.

Column Mapping

Column	Field	Datatype	Required	Notes
1	Patient ID	String(17)	Y	Patient’s unique number used to track the individual across all bookings.
2	Facility	String(32)	N	If the system is running multiple facilities, this must match a CorEMR facility code. Any blank values will be put into the facility the user is currently logged into.
3	First Name	String(255)	Y
4	Middle Name	String(255)
5	Last Name	String(255)	Y
6	Birth Date	Date	Y
7	Sex	String(7)	Y	"Male", "Female", or "Unknown".
8	Booking Number	String(32)	Y
9	Booking Date	Datetime	Y
10	SSN	String(11)
11	Race	String(255)		"American Indian or Alaskan Native", "Asian", "Black or African American", "Native Hawaiian or Other Pacific Islander", or "White".
12	Ethnicity	String(11)		"Hispanic" or "Non-Hispanic"
13	Height	Integer		Measured in inches.
14	Weight	Integer		Measured in US pounds.
15	Eye Color	String
16	Hair Color	String
17	Address1	String
18	Address2	String
19	City	String
20	State	String
21	Zipcode	String
22	Location Block	String
23	Location Pod	String
24	Location Cell	String
25	Location Full	String		If location is not separated in different fields, this FULL location can be provided.
26	Allergies	String

Examples

We recommend headerless CSV files to cutdown on filesizes.

Minimal Example

This lists an example of the bare minimum data one row can contain.

"23445566",,"David",,"Smith","1994-06-20","Male","2018050612231","2018-05-06T12:23:00Z",,,,,,,,,,,,,,,,

Full Example

"24334784","CORTEST","Allison","Bernice","Franks","1984-10-04","Female","2018032015451","2018-03-20T15:45:00Z","555555555","White","Non-Hispanic","63","115","Blue","Blonde","1145 Hobble Creek Canyon Rd","Springville","UT","84660,",,,"HIGHROAD : 01 : 12","NKMA"