Tables [dbo].[Person_Aliases]
Aliases for the Person
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_Aliases_ID_LastName_FirstName: ID\LastName\FirstNameIndexes TWstat_Person_Aliases_FirstName_ID_LastName, TWstat_Person_Aliases_MiddleName_ID_LastName_FirstName, TWstat_Person_Aliases_MungedLastName_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexFirst_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexLast_ID_LastName_FirstName(5)Foreign Keys FK_Person_Aliases_ID_Person_ID: [dbo].[Person].IDID[dbo].[uniqueid]9NOT NULLKey to the Person Table
Cluster Primary Key PK_Person_Aliases_ID_LastName_FirstName: ID\LastName\FirstNameIndexes XPerson_Aliases_LastName, TWstat_Person_Aliases_FirstName_ID_LastName, TWstat_Person_Aliases_MiddleName_ID_LastName_FirstName, TWstat_Person_Aliases_MungedLastName_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexFirst_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexLast_ID_LastName_FirstName(6)LastNamevarchar(35)35NOT NULLLast name for the person
Cluster Primary Key PK_Person_Aliases_ID_LastName_FirstName: ID\LastName\FirstNameIndexes TWstat_Person_Aliases_FirstName_ID_LastName, TWstat_Person_Aliases_MiddleName_ID_LastName_FirstName, TWstat_Person_Aliases_MungedLastName_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexFirst_ID_LastName_FirstName, TWstat_Person_Aliases_SoundexLast_ID_LastName_FirstName(5)FirstNamevarchar(35)35NOT NULLFirst name for the person
Indexes NIX_Person_Aliases_MungedLastName_INC_MiddleName, TWstat_Person_Aliases_MiddleName_ID_LastName_FirstName(2)MiddleNamevarchar(35)35NOT NULLMiddle name for the person
SuffixNamechar(5)5NOT NULLSuffix to the Person's name
PrefixNamechar(5)5NOT NULLPrefix to the Person's name
TitleNamevarchar(20)20NOT NULL(' ')Person's Title
Indexes TWstat_Person_Aliases_SoundexLast_ID_LastName_FirstNameSoundexLastchar(4)4NOT NULLFour character Soundex code basesd on the LastName for comparison
Indexes TWstat_Person_Aliases_SoundexFirst_ID_LastName_FirstNameSoundexFirstchar(4)4NOT NULLFour character Soundex code basesd on the FirstName for comparison
Indexes NIX_Person_Aliases_MungedLastName_INC_MiddleName, TWstat_Person_Aliases_MungedLastName_ID_LastName_FirstName(2)MungedLastNamevarchar(35)35NOT NULL('')Munged value of the LastName data. Spaces, dashes and single quotes removed. This is used for patient search.