Key | Name | Data Type | Computed | Max Length (Bytes) | Nullability | Full Text Indexed | Language | Identity | Default | Description |
---|
 (3) | ID | [dbo].[uniqueid] | | 9 | NOT NULL | | | 1 - 1 | | Key to the Person Table |
(4) | LastName | varchar(35) | | 35 | NOT NULL | | | | | Last Name |
(4) | FirstName | varchar(35) | | 35 | NOT NULL | | | | | First Name |
(4) | MiddleName | varchar(35) | | 35 | NOT NULL | | | | (' ') | Middle Name or initial |
(2)![Foreign Keys FK_Person_SexDE: [dbo].[Sex_DE].SexDE Foreign Keys FK_Person_SexDE: [dbo].[Sex_DE].SexDE](../../../../Images/fk.png) | SexDE | [dbo].[dict_id] | | 5 | NOT NULL | | | | | Gender. Foreign key to Sex_DE.ID |
(3) | DateOfBirth | datetime | | 8 | NULL allowed | | | | | Date of Birth. This is just a date and does not include time of day. |
(2) | SSN | char(11) | | 11 | NOT NULL | | | | (' ') | Social Security Number |
(7)![Check Constraints CK_Person_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Person_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | | 1 | NOT NULL | | | | | Person 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. |
(3) | LastEditedDTTM | datetime | | 8 | NULL allowed | | | | | Last time demographics were updated. This includes any demographics update and not just the person table. |
 | MungedLastName | varchar(35) | | 35 | NOT NULL | | | | ('') | Last name with whitespace and punctuation removed. Used for patient search. |
| NameSearch | varchar(206) | | 206 | NOT NULL | True | 1033 | | ('') | Name search string for use with Full Text Search. |
| FullName | varchar(108) | True | 108 | NOT NULL | | | | | Computed column to store Lastname, FirstName and MiddleName |
| LastFirstName | varchar(72) | True | 72 | NULL allowed | | | | | Computed column to store Lastname and FirstName |
| GivenNameSearch | varchar(130) | | 130 | NOT NULL | True | 1033 | | ('') | Combined given name values to support a full-text search index for FHIR patient search |
 | SSNLast4 | varchar(4) | | 4 | NULL allowed | | | | | Last 4 digits of the Social Security Number |