PatientAlias


Description

Patient alias management storing alternative names and identifiers for patients to support name variations and identity management. This table manages patient aliases including alternative first and last names, alias types, primary alias designation, and comments, supporting patient identification, name variations, cultural naming practices, and identity management for healthcare services.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pkPatAliasID int identity 4 √ null

Primary key - Unique identifier for each patient alias record
patientID int 4 √ null
Patient.PatientID FK__PatientAlias__Patient C

Patient reference - Links to Patient table for the patient who has this alias (foreign key to Patient.PatientID)
aliasFirstName varchar 50 √ null

Alias first name - Alternative first name for the patient
aliasLastName varchar 50 √ null

Alias last name - Alternative last name for the patient
aliasType int 4 √ null

Alias type - Numeric classification of the alias type (e.g., nickname, maiden name, cultural name)
primaryAlias int 4 √ null

Primary alias flag - Numeric indicator whether this is the primary alias for the patient
Comments varchar 500 √ null

Alias comments - Additional comments or notes about the patient alias

Indexes

Constraint Name Type Sort Column(s)
PK__PatientAlias__7579F271 Primary key Asc pkPatAliasID

Relationships

Close relationships within degrees of separation