Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (5)![Foreign Keys FK_Person_Aliases_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Person_Aliases_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Person Table |
 (6) | LastName | varchar(35) | 35 | NOT NULL | | Last name for the person |
 (5) | FirstName | varchar(35) | 35 | NOT NULL | | First name for the person |
(2) | MiddleName | varchar(35) | 35 | NOT NULL | | Middle name for the person |
| SuffixName | char(5) | 5 | NOT NULL | | Suffix to the Person's name |
| PrefixName | char(5) | 5 | NOT NULL | | Prefix to the Person's name |
| TitleName | varchar(20) | 20 | NOT NULL | (' ') | Person's Title |
 | SoundexLast | char(4) | 4 | NOT NULL | | Four character Soundex code basesd on the LastName for comparison |
 | SoundexFirst | char(4) | 4 | NOT NULL | | Four character Soundex code basesd on the FirstName for comparison |
(2) | MungedLastName | varchar(35) | 35 | NOT NULL | ('') | Munged value of the LastName data. Spaces, dashes and single quotes removed. This is used for patient search. |