Tables [dbo].[Person_Other]
Additional demographic information for the Patient, User and providers
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Person_Other_ID: IDIndexes XSoundexPerson, TWstat_Person_Other_EmployerID_ID, TWstat_Person_Other_MaritalStatusDE_ID, TWstat_Person_Other_OccupationDE_ID, TWstat_Person_Other_PrefixName_ID, TWstat_Person_Other_PrimaryLanguageDE_ID, TWstat_Person_Other_RaceDE_ID, TWstat_Person_Other_SecondaryLanguageDE_ID, TWstat_Person_Other_SoundexFirst_ID, TWstat_Person_Other_SuffixName_ID, TWstat_Person_Other_TitleName_ID(11)Foreign Keys FK_Person_Other_ID_Person_ID: [dbo].[Person].IDIDnumeric(16,0)9NOT NULLPerson. Key to the Person Table
Indexes TWstat_Person_Other_EmployerID_IDForeign Keys FK_Person_Other_EmployerID_Employer_ID: [dbo].[Employer].EmployerIDEmployerIDnumeric(8,0)5NULL allowedEmployer. Key to the Employer  table.
Foreign Keys FK_Person_Other_EmploymentStatusDE_Employment_Status_DE_ID: [dbo].[Employment_Status_DE].EmploymentStatusDEEmploymentStatusDE[dbo].[dict_id]5NOT NULLEmployment Status. Key to the Employment_Status_DE table.
Indexes TWstat_Person_Other_SuffixName_IDSuffixNamechar(5)5NOT NULL('')Suffix to the Person's name
Indexes TWstat_Person_Other_PrefixName_IDPrefixNamechar(5)5NOT NULL('')Prefix to the Person's name
Indexes TWstat_Person_Other_TitleName_IDTitleNamevarchar(50)50NOT NULL('')Person's Title
Indexes TWstat_Person_Other_PreferredNamePreferredNamevarchar(35)35NOT NULL('')Name the Person prefers to be called
DriversLicensevarchar(20)20NOT NULL('')Drivers License Number
EmailAddressvarchar(80)80NOT NULL('')Person's Email address
Indexes XSoundexPersonSoundexLastchar(4)4NOT NULLFour character Soundex code basesd on the LastName for comparison
Indexes XSoundexPerson, TWstat_Person_Other_SoundexFirst_ID(2)SoundexFirstchar(4)4NOT NULLFour character Soundex code basesd on the FirstName for comparison
Indexes TWstat_Person_Other_OccupationDE_IDForeign Keys FK_Person_Other_OccupationDE_Occupation_DE_ID: [dbo].[Occupation_DE].OccupationDEOccupationDE[dbo].[dict_id]5NOT NULLOccupation. Key to the Occupation_DE table.
Foreign Keys FK_Person_Other_ReligionDE_Religion_DE_ID: [dbo].[Religion_DE].ReligionDEReligionDE[dbo].[dict_id]5NOT NULLReligion. Key to the Religion_DE table.
Indexes TWstat_Person_Other_RaceDE_IDForeign Keys FK_Person_Other_RaceDE_Race_DE_ID: [dbo].[Race_DE].RaceDERaceDE[dbo].[dict_id]5NOT NULLRace. Key to the Race_DE table. This has been relaced by the Person_Race table and LinkedRaceDEs and is no longer used.
Indexes TWstat_Person_Other_MaritalStatusDE_IDForeign Keys FK_Person_Other_MaritalStatusDE_Marital_Status_DE_ID: [dbo].[Marital_Status_DE].MaritalStatusDEMaritalStatusDE[dbo].[dict_id]5NOT NULLMarital Status. Key to the Marital_Status_DE table.
Indexes TWstat_Person_Other_PrimaryLanguageDE_IDForeign Keys FK_Person_Other_PrimaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].PrimaryLanguageDEPrimaryLanguageDEnumeric(8,0)5NULL allowedPrimary Language. Key to Language_DE table
Indexes TWstat_Person_Other_SecondaryLanguageDE_IDForeign Keys FK_Person_Other_SecondaryLanguageDE_Language_DE_ID: [dbo].[Language_DE].SecondaryLanguageDESecondaryLanguageDEnumeric(8,0)5NULL allowedSecondary Language. Key to Language_DE table
DictationIDvarchar(20)20NULL allowedDictationID
GenericAttributevarchar(1000)1000NOT NULL('')PIPE delimited data related to the Person
Foreign Keys FK_Person_Other_EthnicityDE_Ethnicity_DE_ID: [dbo].[Ethnicity_DE].EthnicityDEEthnicityDE[dbo].[dict_id]5NOT NULL((0))Ethnicity. Key to the Ethnicity_DE table.
Foreign Keys FK_Person_Other_ClinicalSummaryPatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ClinicalSummaryPatientCommunicationDEClinicalSummaryPatientCommunicationDE[dbo].[dict_id]5NOT 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].ReminderPatientCommunicationDEReminderPatientCommunicationDE[dbo].[dict_id]5NOT 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')ProhibitTaskAssignmentFLAG[dbo].[BOOL]1NOT NULL('N')This contains a Y or N to detemine if the provider / User is allowed to have Tasks assigned
LinkedRaceDEsvarchar(255)255NOT NULL('')listed of related Races
Foreign Keys FK_Person_Other_ChartUpdatePatientCommunicationDE_Patient_Communication_DE_ID: [dbo].[Patient_Communication_DE].ChartUpdatePatientCommunicationDEChartUpdatePatientCommunicationDE[dbo].[dict_id]5NOT 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].ResultNotificationPatientCommunicationDEResultNotificationPatientCommunicationDE[dbo].[dict_id]5NOT NULL((0))Patient Communication Method for Result Notifications. Key to the PatientCommunication_DE table.
PortalRegistrationStatusDE[dbo].[dict_id]5NOT NULL((0))Portal Registration Status. Link to Portal_Registration_Status_DE.ID.
IsSensitiveHealthbit1NOT NULL((0))Does the patient hava a Potential sensitive health condition?
DateOfDeathdatetime8NULL allowedDate of Death of a deceased patient.
LastContactedDTTMdatetime8NULL allowedLast Contacted Date Time
BirthStatevarchar(50)50NULL allowedBirth State of patient
BirthCountryvarchar(30)30NULL allowedBirth Country of patient
Foreign Keys FK_Person_Other_IndustryDE: [dbo].[Industry_DE].IndustryDEIndustryDE[dbo].[dict_id]5NOT NULL((0))Industry the patient is employeed in. Link to Industry_DE.ID
Foreign Keys FK_Person_Other_SexualOrientationDE: [dbo].[Sexual_Orientation_DE].SexualOrientationDESexualOrientationDE[dbo].[dict_id]5NOT NULL((0))Sexual Orientation. Link to Sexual_Orientation_DE.ID
Foreign Keys FK_Person_Other_GenderIdentityDE: [dbo].[Gender_Identity_DE].GenderIdentityDEGenderIdentityDE[dbo].[dict_id]5NOT NULL((0))Gender Identity. Link to Gender_Identity_DE.ID
Foreign Keys FK_Person_Other_PatientOccupationDE: [dbo].[Patient_Occupation_DE].PatientOccupationDEPatientOccupationDE[dbo].[dict_id]5NOT NULL((0))Occupation. Link to Patient_Occupation_DE.ID
Foreign Keys FK_Person_Other_BirthSexDE: [dbo].[Sex_DE].BirthSexDEBirthSexDE[dbo].[dict_id]5NOT NULL((0))Birth Sex. Link to Sex_DE.ID
Foreign Keys FK_Person_Other_PrefPronounDE: [dbo].[Preferred_Pronoun_DE].PrefPronounDEPrefPronounDE[dbo].[dict_id]5NOT NULL((0))Preferred Gender Pronoun. Link to Preferred_Pronoun_DE.ID
PreviousLastNamevarchar(35)35NOT NULL('')Previous Last Name of patient
PreviousFirstNamevarchar(35)35NOT NULL('')Previous First Name of patient
NameToUsevarchar(50)50NOT NULL('')Name that should be used when addressing or referencing a patient