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.