Patient

The <Patient> element is the root element within the XML, which contains all the data in the file. The <Patient> element also contains directory information at the root level.

Element	Description	Type	Notes
patient_no	patient number	int	key data
LocationID	location number	int	The location number is number assigned by the system to each location. This location number is probably different than any colloquial store numbers used by the practice.
address_no	address number	int	The address number tied to the <address> element.
address_no_old	former address	int	The address number tied to the <address> element.
guarantor_no	gurantor number	int	The patient number assigned to the patient's guarantor. If the number is the same as the patient's patient number, then the patient is their own guarantor.
use_guarantor_address	guarantor's address	bit	0 = no 1 = yes
mid_name	patient's middle initial	nvarchar
last_name	patient's last name	nvarchar
suffix	patient's suffix	nvarchar	For example, Jr., Sr., II. May be blank.
entry_date	date patient created	datetime
sex	patient's sex	smallint	-1 = blank 0 = male 1 = female 2 = unknown
birth_date	birth date	datetime	YYYY-MM-DD w/timestamp
ss_no	social security number	nvarchar	May be blank, 4 digits, or 9 digits.
title	title	nvarchar	For example, Mrs., Sir, Dr., Her Royal Highness. May be blank.
provider	provider name	int	provider name
chart_no	chart number	nvarchar	This number/schema is set by the practice. May be blank.
salutation	salutation	nvarchar	Customizable salutation for patient correspondence. For example, Dear [name].
nickname	nickname	nvarchar	May be blank.
employer	employer	nvarchar	May be blank.
emp_status	employment status	int	May be blank.
marital_status	marital status	int	May be blank.
med_alert	medical alerts	ntext	May be blank.
notes	notes	ntext	May be blank.
active	active/inactive	smallint	0 = inactive 1 = active
last_office_visit_date	date of latest visit	datetime
day_phone	daytime phone number	nvarchar
last_exam_date	date of latest exam	datetime
deceased	deceased	bit	0 = alive/no selection 1 = deceased
deceased_date	date of death	datetime	Date of death or date documented.
patient_retired	retired	bit	0 = not retired/no selection 1= retired
patient_retire_date	date of retirement	datetime	Date of retirement or date documented.
pager_no	pager number	nvarchar	May be blank.
eMail_address	email address	nvarchar	May be blank.
cell_phone	mobile phone number	nvarchar	May be blank.
first_name	patient's first name	nvarchar
PriCarePhy	primary care provider	int	Number corresponds to provider table.
Pref_language	preferred language	int	Number corresponds to language table.
TargetIOP_OD	target IOP (right eye)	nvarchar	May be blank.
TargetIOP_OS	target IOP (left eye)	nvarchar	May be blank.
PatientRace	patient race(s)	navchar	Maybe blank. There may be multiple races listed.
ethnicity	ethnicity	navchar	May be blank.
TextingOK	texting OK?	bit	0 = no/no selection 1 = yes
prior_first_name	prior first name	nvarchar	May be blank.
prior_mid_name	prior middle initial	nvarchar	May be blank.
prior_last_name	prior last name	nvarchar	May be blank.
prior_suffix	prior suffix	nvarchar	May be blank.
prior_title	prior title	nvarchar	May be blank.