PATIENT_ALIAS

Description:

The PATIENT_ALIAS table contains the aliases and soundex data for your patients. Each patient may have multiple aliases; therefore, a line number is used to uniquely identify each alias for a patient.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID number assigned to the patient record.
2	LINE	INTEGER	No
	The line number associated with the alias information associated with this row. Multiple pieces of information can be associated with this row.
3	ALIAS	VARCHAR	No
	The alias on the patient record.