Patient file CSV layout

Patient File
It lets you add patients in Medisoft using input in the form of CSV file. Note that row 1 is not used. This row can contain column names or a comment.

Key for Type column:
Text = alpha characters (e.g. a, b, c)
Numeric = numbers, whole and fractions e.g. (20.00,-7.50,-4,65)
Date = a YYYYMMDD format or MM/DD/YYYY (e.g. 20020625 or 06/25/2002).

See notes below Column# Data Element Data Type Max. Length Remark

* 1 Chart Text 15

**/td> 2 First Name Text 20

** 3 Last Name Text 20

* 4 Middle Initial Text 1

* 5 Address Line 1 Text 39

* 6 Address Line 2 Text 39

* 7 City Text 25

* 8 State Text 2

* 9 Zip Code Text 10

* 10 Work Phone Numeric 14

* 11 Work Phone Ext. Numeric 6

* 12 Home Phone Numeric 14 Telephone numbers must not use any brackets or dashes e.g. 8015620111

* 13 Social Security # Text 11 e.g. 528-33-3333

** 14 Sex Text 1 F (or Female)=Female else Male

* 15 Marital Status Text 1 S=Single; M=Married; X=LegallySeparated; D=Divorced; W=Widowed; empty=Unknown/Not Applicable

* 16 Birth Date Date 8 AAmerican or universal date format e.g. 03/14/1977 or 19770314

Note:
* field improves quality of imported data, but can be left empty
** field requires a value

See notes below	Column#	Data Element	Data Type	Max. Length	Remark
*	1	Chart	Text	15
**/td>	2	First Name	Text	20
**	3	Last Name	Text	20
*	4	Middle Initial	Text	1
*	5	Address Line 1	Text	39
*	6	Address Line 2	Text	39
*	7	City	Text	25
*	8	State	Text	2
*	9	Zip Code	Text	10
*	10	Work Phone	Numeric	14
*	11	Work Phone Ext.	Numeric	6
*	12	Home Phone	Numeric	14	Telephone numbers must not use any brackets or dashes e.g. 8015620111
*	13	Social Security #	Text	11	e.g. 528-33-3333
**	14	Sex	Text	1	F (or Female)=Female else Male
*	15	Marital Status	Text	1	S=Single; M=Married; X=LegallySeparated; D=Divorced; W=Widowed; empty=Unknown/Not Applicable
*	16	Birth Date	Date	8	AAmerican or universal date format e.g. 03/14/1977 or 19770314