Tables [dbo].[Patient_Member]
Patient Specific Demographic Information
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Patient_Member_ID: IDIndexes XPat_Member_Covering, XAK1Patient_Member, TWstat_Patient_Member_AmbulatoryStatusDE_ID, TWstat_Patient_Member_BloodType_ID, TWstat_Patient_Member_Build_ID, TWstat_Patient_Member_CurrentChartLocationDE_ID, TWstat_Patient_Member_EducationLevel_ID, TWstat_Patient_Member_EthnicGroup1_ID, TWstat_Patient_Member_EthnicGroup2_ID, TWstat_Patient_Member_EthnicGroup3_ID, TWstat_Patient_Member_EyeColor_ID, TWstat_Patient_Member_GuarantorBusinessEntityID_ID, TWstat_Patient_Member_GuarantorPersonID_ID, TWstat_Patient_Member_HairColor_ID, TWstat_Patient_Member_HasDonorCardFLAG_ID, TWstat_Patient_Member_HasLivingWillFLAG_ID, TWstat_Patient_Member_HomeChartLocationDE_ID, TWstat_Patient_Member_IsAdoptedFLAG_ID, TWstat_Patient_Member_IsAnyCaseActiveFLAG_ID, TWstat_Patient_Member_IsCitizenFLAG_ID, TWstat_Patient_Member_IsConfidentialFLAG_ID, TWstat_Patient_Member_IsInactiveFLAG_ID, TWstat_Patient_Member_IsVeteranFLAG_ID, TWstat_Patient_Member_MilitaryServiceFLAG_ID, TWstat_Patient_Member_MotherID_ID, TWstat_Patient_Member_MothersMaidenName_ID, TWstat_Patient_Member_MultiBirthFLAG_ID, TWstat_Patient_Member_NCRStatusFLAG_ID, TWstat_Patient_Member_NeedsInterpreterFLAG_ID, TWstat_Patient_Member_PersonsHousehold_ID, TWstat_Patient_Member_PlaceOfBirth_ID, TWstat_Patient_Member_PrimaryPatientLocationDE_ID, TWstat_Patient_Member_ProviderID_ID, TWstat_Patient_Member_ProxyMedFormularyDE_ID, TWstat_Patient_Member_RegionDE_ID, TWstat_Patient_Member_RightLeft_ID, TWstat_Patient_Member_VIPTypeDE_ID(37)Foreign Keys FK_Patient_Member_ID_Person_ID: [dbo].[Person].IDID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes TWstat_Patient_Member_GuarantorBusinessEntityID_IDGuarantorBusinessEntityIDnumeric(8,0)5NOT NULLGuarantor Business Entity ID
Indexes TWstat_Patient_Member_GuarantorPersonID_IDGuarantorPersonIDnumeric(16,0)9NOT NULL(0)Patients Guarantor. Link to Person.ID.
Indexes TWstat_Patient_Member_VIPTypeDE_IDForeign Keys FK_Patient_Member_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDEVIPTypeDE[dbo].[dict_id]5NOT NULLVery Important Person Type. Link to VIP_Type_DE.ID.
Indexes TWstat_Patient_Member_RightLeft_IDCheck Constraints CK_Patient_Member_RightLeft_Left_Or_Right : ([RightLeft]='' OR [RightLeft]='L' OR [RightLeft]='R')RightLeftchar(1)1NOT NULL('U')Flag indicating Right Handed person or Left Handed Person
Indexes TWstat_Patient_Member_EyeColor_IDEyeColorchar(10)10NOT NULL(' ')Patient Eye Color
Indexes TWstat_Patient_Member_HairColor_IDHairColorchar(10)10NOT NULL(' ')Patient Hair Color
Indexes TWstat_Patient_Member_Build_IDBuildvarchar(20)20NOT NULL(' ')Patients Personal Appearance like "Well Built person.."
Indexes TWstat_Patient_Member_BloodType_IDBloodTypechar(5)5NOT NULL(' ')Blood Type of patient
Indexes TWstat_Patient_Member_IsAdoptedFLAG_IDCheck Constraints CK_Patient_Member_IsAdoptedFLAG_Yes_Or_No : ([IsAdoptedFLAG]='N' OR [IsAdoptedFLAG]='Y')IsAdoptedFLAG[dbo].[BOOL]1NOT NULLFlag indicating Adapted or Non Adapted
Indexes TWstat_Patient_Member_MultiBirthFLAG_IDCheck Constraints CK_Patient_Member_MultiBirthFLAG_Yes_Or_No : ([MultiBirthFLAG]='N' OR [MultiBirthFLAG]='Y')MultiBirthFLAG[dbo].[BOOL]1NOT NULLFlag indicating Multi Birth
Indexes TWstat_Patient_Member_PlaceOfBirth_IDPlaceOfBirthvarchar(35)35NOT NULL(' ')Patients Birth Place
Indexes TWstat_Patient_Member_EthnicGroup1_IDEthnicGroup1char(2)2NOT NULL(' ')Ethnicity Group of Patient
Indexes TWstat_Patient_Member_EthnicGroup2_IDEthnicGroup2char(2)2NOT NULL(' ')Ethnicity Group of Patient
Indexes TWstat_Patient_Member_EthnicGroup3_IDEthnicGroup3char(2)2NOT NULL(' ')Ethnicity Group of Patient
Indexes TWstat_Patient_Member_IsCitizenFLAG_IDCheck Constraints CK_Patient_Member_IsCitizenFLAG_Yes_Or_No : ([IsCitizenFLAG]='N' OR [IsCitizenFLAG]='Y')IsCitizenFLAG[dbo].[BOOL]1NOT NULLIs Patient a Citizen
Indexes TWstat_Patient_Member_NeedsInterpreterFLAG_IDCheck Constraints CK_Patient_Member_NeedsInterpreterFLAG_Yes_Or_No : ([NeedsInterpreterFLAG]='N' OR [NeedsInterpreterFLAG]='Y')NeedsInterpreterFLAG[dbo].[BOOL]1NOT NULLFlag indicating Interpretor needed or Not
Indexes TWstat_Patient_Member_EducationLevel_IDEducationLevelsmallint2NOT NULL(0)Patient Educational Level
Indexes TWstat_Patient_Member_MilitaryServiceFLAG_IDCheck Constraints CK_Patient_Member_MilitaryServiceFLAG_Yes_Or_No : ([MilitaryServiceFLAG]='N' OR [MilitaryServiceFLAG]='Y')MilitaryServiceFLAG[dbo].[BOOL]1NOT NULL(' ')Flag indicating patient is serving in the military
Indexes TWstat_Patient_Member_IsVeteranFLAG_IDCheck Constraints CK_Patient_Member_IsVeteranFLAG_Yes_Or_No : ([IsVeteranFLAG]='N' OR [IsVeteranFLAG]='Y')IsVeteranFLAG[dbo].[BOOL]1NOT NULLFlag indicating the patient is a Veteran
Indexes TWstat_Patient_Member_PersonsHousehold_IDPersonsHouseholdsmallint2NOT NULL(0)Number of people residing in the household
Indexes TWstat_Patient_Member_NCRStatusFLAG_IDCheck Constraints CK_Patient_Member_NCRStatusFLAG_Yes_Or_No : ([NCRStatusFLAG]='N' OR [NCRStatusFLAG]='Y')NCRStatusFLAG[dbo].[BOOL]1NOT NULLNCR Status of patient
Indexes XPat_Member_Covering, XAK1Patient_Member(2)Check Constraints CK_Patient_Member_IsDeceasedFLAG_Yes_Or_No : ([IsDeceasedFLAG]='N' OR [IsDeceasedFLAG]='Y')IsDeceasedFLAG[dbo].[BOOL]1NOT NULLFlag to indicate Deceased
Indexes XPat_Member_Covering, TWstat_Patient_Member_IsInactiveFLAG_ID(2)Check Constraints CK_Patient_Member_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLFlag indicating Inactive or Active Patient
Indexes TWstat_Patient_Member_HasDonorCardFLAG_IDCheck Constraints CK_Patient_Member_HasDonorCardFLAG_Yes_Or_No : ([HasDonorCardFLAG]='N' OR [HasDonorCardFLAG]='Y')HasDonorCardFLAG[dbo].[BOOL]1NOT NULLFlag indicating if a Donor Card exists or Not
Indexes TWstat_Patient_Member_IsConfidentialFLAG_IDCheck Constraints CK_Patient_Member_IsConfidentialFLAG_Yes_Or_No : ([IsConfidentialFLAG]='N' OR [IsConfidentialFLAG]='Y')IsConfidentialFLAG[dbo].[BOOL]1NOT NULLIs this patient data is confidential
Indexes TWstat_Patient_Member_MotherID_IDMotherID[dbo].[uniqueid]9NOT NULLMother. Link to Person.ID
Indexes TWstat_Patient_Member_MothersMaidenName_IDMothersMaidenNamevarchar(35)35NOT NULL(' ')Mothers Maiden Name
Indexes TWstat_Patient_Member_HasLivingWillFLAG_IDCheck Constraints CK_Patient_Member_HasLivingWillFLAG_Yes_Or_No : ([HasLivingWillFLAG]='N' OR [HasLivingWillFLAG]='Y')HasLivingWillFLAG[dbo].[BOOL]1NOT NULLDoes the patient have a living will?
Indexes TWstat_Patient_Member_ProviderID_IDProviderID[dbo].[uniqueid]9NOT NULLPrimary Care Provider. Link to Provider.ID if PCPTYPE = 'P' or Referring_Provider_DE.ID if PCPTYPE = 'R'.
Indexes TWstat_Patient_Member_IsAnyCaseActiveFLAG_IDCheck Constraints CK_Patient_Member_IsAnyCaseActiveFLAG_Yes_Or_No : ([IsAnyCaseActiveFLAG]='N' OR [IsAnyCaseActiveFLAG]='Y')IsAnyCaseActiveFLAG[dbo].[BOOL]1NOT NULLIs there an active case?
Indexes TWstat_Patient_Member_AmbulatoryStatusDE_IDAmbulatoryStatusDE[dbo].[dict_id]5NOT NULLAmbulatory Status. Link to Ambulatory_Status_DE.ID.
Indexes TWstat_Patient_Member_RegionDE_IDForeign Keys FK_Patient_Member_RegionDE_Region_DE_ID: [dbo].[Region_DE].RegionDERegionDE[dbo].[dict_id]5NOT NULLReligion. Link to Region_DE.ID.
Indexes TWstat_Patient_Member_ProxyMedFormularyDE_IDProxyMedFormularyDEnumeric(8,0)5NOT NULL(0)ProxyMed Formulary. No longer used.
Indexes TWstat_Patient_Member_PrimaryPatientLocationDE_IDForeign Keys FK_Patient_Member_Pat_Loc_DE: [dbo].[Patient_Location_DE].PrimaryPatientLocationDEPrimaryPatientLocationDE[dbo].[dict_id]5NOT NULL(0)Primary Location. Link to Patient_Location_DE.ID
SecondaryPatientLocationvarchar(255)255NULL allowedSecondary Location
Indexes TWstat_Patient_Member_HomeChartLocationDE_IDForeign Keys FK_Patient_Member_HomeChartLocationDE: [dbo].[Chart_Location_DE].HomeChartLocationDEHomeChartLocationDE[dbo].[dict_id]5NOT NULL(0)Usual Chart Location of the paper Chart. Link to Chart_Location_DE.ID.
Indexes TWstat_Patient_Member_CurrentChartLocationDE_IDForeign Keys FK_Patient_Member_CurrentChartLocationDE: [dbo].[Chart_Location_DE].CurrentChartLocationDECurrentChartLocationDE[dbo].[dict_id]5NOT NULL(0)Current Location of the paper chart. Link to Chart_Location_DE.ID.
PCPTYPEchar(1)1NOT NULL('P')P - Provider or R - Referring Provider
ExtMedHxStatuschar(1)1NULL allowed('U')Medical History Status
ExtMedHxStatusChangedByID[dbo].[uniqueid]9NULL allowedMedical History Changed by
ExtMedHxStatusChangedDTTMdatetime8NULL allowedMedical History changed when
MAIVervarchar(35)35NOT NULL('')MAIVer
MAIPatDescvarchar(255)255NOT NULL('')MAIPatDesc
MAIPatIndchar(15)15NOT NULL('')MAIPatInd
BirthOrdertinyint1NOT NULL((0))Birth order if the patient is from a multiple birth
EmpaneledToTypechar(1)1NOT NULL('P')Indicates if a PCP ID (indicated by 'P') or is a PCT ID (indicated by 'T') is stored in EmpaneledTo Column
EmpaneledTo[dbo].[uniqueid]9NOT NULL((0))Holds PCP ID or PCT ID
Foreign Keys FK_Patient_Member_AgencyDE_Agency_DE_ID: [dbo].[Agency_DE].AgencyDEAgencyDE[dbo].[dict_id]5NOT NULL((0))Agency. Link to Agency_DE
Foreign Keys FK_Patient_Member_BureauDE_Bureau_DE_ID: [dbo].[Bureau_DE].BureauDEBureauDE[dbo].[dict_id]5NOT NULL((0))Bureau. Link to Bureau_DE
Foreign Keys FK_Patient_Member_EmploymentTypeDE_Employment_Type_DE_ID: [dbo].[Employment_Type_DE].EmploymentTypeDEEmploymentTypeDE[dbo].[dict_id]5NOT NULL((0))Employment Type. Link to Employment_Type_DE
EmployeeTypechar(1)1NOT NULL('')Employee Type =  E - Employee or D - Dependent
Foreign Keys FK_Patient_Member_JobTitleDE_Job_Title_DE_ID: [dbo].[Job_Title_DE].JobTitleDEJobTitleDE[dbo].[dict_id]5NOT NULL((0))Job Title. Link to Job_Title_DE
Foreign Keys FK_Patient_Member_PostDE_Post_DE_ID: [dbo].[Post_DE].PostDEPostDE[dbo].[dict_id]5NOT NULL((0))Post. Link to Post_DE