Tables [dbo].[Person]
Table of primary demopraphics. A person can have one or more roles including patient, user, or provider.
KeyNameData TypeComputedMax Length (Bytes)NullabilityFull Text IndexedLanguageIdentityDefaultDescription
Cluster Primary Key PK_Person_ID: IDIndexes NIX_Person_LastEditedDttm_INC_ID, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID, TWstat_Person_MiddleName_LastName_FirstName_IsInactiveFLAG_ID(3)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Person Table
Indexes NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID, TWstat_Person_MiddleName_LastName_FirstName_IsInactiveFLAG_ID(4)LastNamevarchar(35)35NOT NULLLast Name
Indexes NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID, TWstat_Person_MiddleName_LastName_FirstName_IsInactiveFLAG_ID(4)FirstNamevarchar(35)35NOT NULLFirst Name
Indexes NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID, TWstat_Person_MiddleName_LastName_FirstName_IsInactiveFLAG_ID(4)MiddleNamevarchar(35)35NOT NULL(' ')Middle Name or initial
Indexes NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns(2)Foreign Keys FK_Person_SexDE: [dbo].[Sex_DE].SexDESexDE[dbo].[dict_id]5NOT NULLGender. Foreign key to Sex_DE.ID
Indexes xDOBPerson, NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns(3)DateOfBirthdatetime8NULL allowedDate of Birth. This is just a date and does not include time of day.
Indexes NIX_Person_MungedLastName_WithIncludeColumns, xSSNPerson(2)SSNchar(11)11NOT NULL(' ')Social Security Number
Indexes xDOBPerson, NIX_Person_LastName_FirstName_WithIncludeColumns, NIX_Person_MungedLastName_WithIncludeColumns, xSSNPerson, NIX_Person_SSNLast4_IsInactiveFLAG, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID, TWstat_Person_MiddleName_LastName_FirstName_IsInactiveFLAG_ID(7)Check Constraints CK_Person_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLPerson Is Inactive (Y/N)? An inactive person is not viewable. Normal inactivation is by role in the Patient_Member, IDXUser, or Provider tables. This is primarily used for the non-surviving person in patient merge.
Indexes Portal_Person, NIX_Person_LastEditedDttm_INC_ID, TWstat_Person_LastEditedDTTM_LastName_FirstName_MiddleName_IsInactiveFLAG_ID(3)LastEditedDTTMdatetime8NULL allowedLast time demographics were updated. This includes any demographics update and not just the person table.
Indexes NIX_Person_MungedLastName_WithIncludeColumnsMungedLastNamevarchar(35)35NOT NULL('')Last name with whitespace and punctuation removed. Used for patient search.
NameSearchvarchar(206)206NOT NULL
True
1033('')Name search string for use with Full Text Search.
FullNamevarchar(108)
True
108NOT NULLComputed column to store Lastname, FirstName and MiddleName
LastFirstNamevarchar(72)
True
72NULL allowedComputed column to store Lastname and FirstName
GivenNameSearchvarchar(130)130NOT NULL
True
1033('')Combined given name values to support a full-text search index for FHIR patient search
Indexes NIX_Person_SSNLast4_IsInactiveFLAGSSNLast4varchar(4)4NULL allowedLast 4 digits of the Social Security Number