Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (11)![Foreign Keys FK_Person_Other_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Person_Other_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | numeric(16,0) | 9 | NOT NULL | | Person. Key to the Person Table |
 ![Foreign Keys FK_Person_Other_EmployerID_Employer_ID: [dbo].[Employer].EmployerID Foreign Keys FK_Person_Other_EmployerID_Employer_ID: [dbo].[Employer].EmployerID](../../../../Images/fk.png) | EmployerID | numeric(8,0) | 5 | NULL allowed | | Employer. Key to the Employer table. |
![Foreign Keys FK_Person_Other_EmploymentStatusDE_Employment_Status_DE_ID: [dbo].[Employment_Status_DE].EmploymentStatusDE Foreign Keys FK_Person_Other_EmploymentStatusDE_Employment_Status_DE_ID: [dbo].[Employment_Status_DE].EmploymentStatusDE](../../../../Images/fk.png) | EmploymentStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Employment Status. Key to the Employment_Status_DE table. |
 | 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(50) | 50 | NOT NULL | ('') | Person's Title |
 | PreferredName | varchar(35) | 35 | NOT NULL | ('') | Name the Person prefers to be called |
| DriversLicense | varchar(20) | 20 | NOT NULL | ('') | Drivers License Number |
| EmailAddress | varchar(80) | 80 | NOT NULL | ('') | Person's Email address |
 | SoundexLast | char(4) | 4 | NOT NULL | | Four character Soundex code basesd on the LastName for comparison |
(2) | SoundexFirst | char(4) | 4 | NOT NULL | | Four character Soundex code basesd on the FirstName for comparison |
 ![Foreign Keys FK_Person_Other_OccupationDE_Occupation_DE_ID: [dbo].[Occupation_DE].OccupationDE Foreign Keys FK_Person_Other_OccupationDE_Occupation_DE_ID: [dbo].[Occupation_DE].OccupationDE](../../../../Images/fk.png) | OccupationDE | [dbo].[dict_id] | 5 | NOT NULL | | Occupation. Key to the Occupation_DE table. |
![Foreign Keys FK_Person_Other_ReligionDE_Religion_DE_ID: [dbo].[Religion_DE].ReligionDE Foreign Keys FK_Person_Other_ReligionDE_Religion_DE_ID: [dbo].[Religion_DE].ReligionDE](../../../../Images/fk.png) | ReligionDE | [dbo].[dict_id] | 5 | NOT NULL | | Religion. Key to the Religion_DE table. |
 ![Foreign Keys FK_Person_Other_RaceDE_Race_DE_ID: [dbo].[Race_DE].RaceDE Foreign Keys FK_Person_Other_RaceDE_Race_DE_ID: [dbo].[Race_DE].RaceDE](../../../../Images/fk.png) | RaceDE | [dbo].[dict_id] | 5 | NOT NULL | | Race. Key to the Race_DE table. This has been relaced by the Person_Race table and LinkedRaceDEs and is no longer used. |
 ![Foreign Keys FK_Person_Other_MaritalStatusDE_Marital_Status_DE_ID: [dbo].[Marital_Status_DE].MaritalStatusDE Foreign Keys FK_Person_Other_MaritalStatusDE_Marital_Status_DE_ID: [dbo].[Marital_Status_DE].MaritalStatusDE](../../../../Images/fk.png) | MaritalStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Marital Status. Key to the Marital_Status_DE table. |
 ![Foreign Keys FK_Person_Other_PrimaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].PrimaryLanguageDE Foreign Keys FK_Person_Other_PrimaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].PrimaryLanguageDE](../../../../Images/fk.png) | PrimaryLanguageDE | numeric(8,0) | 5 | NULL allowed | | Primary Language. Key to Language_DE table |
 ![Foreign Keys FK_Person_Other_SecondaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].SecondaryLanguageDE Foreign Keys FK_Person_Other_SecondaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].SecondaryLanguageDE](../../../../Images/fk.png) | SecondaryLanguageDE | numeric(8,0) | 5 | NULL allowed | | Secondary Language. Key to Language_DE table |
| DictationID | varchar(20) | 20 | NULL allowed | | DictationID |
| GenericAttribute | varchar(1000) | 1000 | NOT NULL | ('') | PIPE delimited data related to the Person |
![Foreign Keys FK_Person_Other_EthnicityDE_Ethnicity_DE_ID: [dbo].[Ethnicity_DE].EthnicityDE Foreign Keys FK_Person_Other_EthnicityDE_Ethnicity_DE_ID: [dbo].[Ethnicity_DE].EthnicityDE](../../../../Images/fk.png) | EthnicityDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Ethnicity. Key to the Ethnicity_DE table. |
![Foreign Keys FK_Person_Other_ClinicalSummaryPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ClinicalSummaryPatientCommunicationDE Foreign Keys FK_Person_Other_ClinicalSummaryPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ClinicalSummaryPatientCommunicationDE](../../../../Images/fk.png) | ClinicalSummaryPatientCommunicationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Patient Communication Method for Clinical Summaries. Key to the PatientCommunication_DE table. |
![Foreign Keys FK_Person_Other_ReminderPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ReminderPatientCommunicationDE Foreign Keys FK_Person_Other_ReminderPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ReminderPatientCommunicationDE](../../../../Images/fk.png) | ReminderPatientCommunicationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Patient Communication Method for Reminders. Key to the PatientCommunication_DE table. |
![Check Constraints CK_Person_Other_ProhibitTaskAssignmentFLAG_Yes_Or_No : ([ProhibitTaskAssignmentFLAG]='N' OR [ProhibitTaskAssignmentFLAG]='Y') Check Constraints CK_Person_Other_ProhibitTaskAssignmentFLAG_Yes_Or_No : ([ProhibitTaskAssignmentFLAG]='N' OR [ProhibitTaskAssignmentFLAG]='Y')](../../../../Images/c-constraint.png) | ProhibitTaskAssignmentFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | This contains a Y or N to detemine if the provider / User is allowed to have Tasks assigned |
| LinkedRaceDEs | varchar(255) | 255 | NOT NULL | ('') | listed of related Races |
![Foreign Keys FK_Person_Other_ChartUpdatePatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ChartUpdatePatientCommunicationDE Foreign Keys FK_Person_Other_ChartUpdatePatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ChartUpdatePatientCommunicationDE](../../../../Images/fk.png) | ChartUpdatePatientCommunicationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Patient Communication Method for Chart Updates. Key to the PatientCommunication_DE table. |
![Foreign Keys FK_Person_Other_ResultNotificationPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ResultNotificationPatientCommunicationDE Foreign Keys FK_Person_Other_ResultNotificationPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ResultNotificationPatientCommunicationDE](../../../../Images/fk.png) | ResultNotificationPatientCommunicationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Patient Communication Method for Result Notifications. Key to the PatientCommunication_DE table. |
| PortalRegistrationStatusDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Portal Registration Status. Link to Portal_Registration_Status_DE.ID. |
| IsSensitiveHealth | bit | 1 | NOT NULL | ((0)) | Does the patient hava a Potential sensitive health condition? |
| DateOfDeath | datetime | 8 | NULL allowed | | Date of Death of a deceased patient. |
| LastContactedDTTM | datetime | 8 | NULL allowed | | Last Contacted Date Time |
| BirthState | varchar(50) | 50 | NULL allowed | | Birth State of patient |
| BirthCountry | varchar(30) | 30 | NULL allowed | | Birth Country of patient |
![Foreign Keys FK_Person_Other_IndustryDE: [dbo].[Industry_DE].IndustryDE Foreign Keys FK_Person_Other_IndustryDE: [dbo].[Industry_DE].IndustryDE](../../../../Images/fk.png) | IndustryDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Industry the patient is employeed in. Link to Industry_DE.ID |
![Foreign Keys FK_Person_Other_SexualOrientationDE: [dbo].[Sexual_Orientation_DE].SexualOrientationDE Foreign Keys FK_Person_Other_SexualOrientationDE: [dbo].[Sexual_Orientation_DE].SexualOrientationDE](../../../../Images/fk.png) | SexualOrientationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Sexual Orientation. Link to Sexual_Orientation_DE.ID |
![Foreign Keys FK_Person_Other_GenderIdentityDE: [dbo].[Gender_Identity_DE].GenderIdentityDE Foreign Keys FK_Person_Other_GenderIdentityDE: [dbo].[Gender_Identity_DE].GenderIdentityDE](../../../../Images/fk.png) | GenderIdentityDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Gender Identity. Link to Gender_Identity_DE.ID |
![Foreign Keys FK_Person_Other_PatientOccupationDE: [dbo].[Patient_Occupation_DE].PatientOccupationDE Foreign Keys FK_Person_Other_PatientOccupationDE: [dbo].[Patient_Occupation_DE].PatientOccupationDE](../../../../Images/fk.png) | PatientOccupationDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Occupation. Link to Patient_Occupation_DE.ID |
![Foreign Keys FK_Person_Other_BirthSexDE: [dbo].[Sex_DE].BirthSexDE Foreign Keys FK_Person_Other_BirthSexDE: [dbo].[Sex_DE].BirthSexDE](../../../../Images/fk.png) | BirthSexDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Birth Sex. Link to Sex_DE.ID |
![Foreign Keys FK_Person_Other_PrefPronounDE: [dbo].[Preferred_Pronoun_DE].PrefPronounDE Foreign Keys FK_Person_Other_PrefPronounDE: [dbo].[Preferred_Pronoun_DE].PrefPronounDE](../../../../Images/fk.png) | PrefPronounDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Preferred Gender Pronoun. Link to Preferred_Pronoun_DE.ID |
| PreviousLastName | varchar(35) | 35 | NOT NULL | ('') | Previous Last Name of patient |
| PreviousFirstName | varchar(35) | 35 | NOT NULL | ('') | Previous First Name of patient |
| NameToUse | varchar(50) | 50 | NOT NULL | ('') | Name that should be used when addressing or referencing a patient |