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.