Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (37)![Foreign Keys FK_Patient_Member_ID_Person_ID: [dbo].[Person].ID Foreign Keys FK_Patient_Member_ID_Person_ID: [dbo].[Person].ID](../../../../Images/fk.png) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID |
 | GuarantorBusinessEntityID | numeric(8,0) | 5 | NOT NULL | | Guarantor Business Entity ID |
 | GuarantorPersonID | numeric(16,0) | 9 | NOT NULL | (0) | Patients Guarantor. Link to Person.ID. |
 ![Foreign Keys FK_Patient_Member_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDE Foreign Keys FK_Patient_Member_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDE](../../../../Images/fk.png) | VIPTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | Very Important Person Type. Link to VIP_Type_DE.ID. |
 ![Check Constraints CK_Patient_Member_RightLeft_Left_Or_Right : ([RightLeft]='' OR [RightLeft]='L' OR [RightLeft]='R') Check Constraints CK_Patient_Member_RightLeft_Left_Or_Right : ([RightLeft]='' OR [RightLeft]='L' OR [RightLeft]='R')](../../../../Images/c-constraint.png) | RightLeft | char(1) | 1 | NOT NULL | ('U') | Flag indicating Right Handed person or Left Handed Person |
 | EyeColor | char(10) | 10 | NOT NULL | (' ') | Patient Eye Color |
 | HairColor | char(10) | 10 | NOT NULL | (' ') | Patient Hair Color |
 | Build | varchar(20) | 20 | NOT NULL | (' ') | Patients Personal Appearance like "Well Built person.." |
 | BloodType | char(5) | 5 | NOT NULL | (' ') | Blood Type of patient |
 ![Check Constraints CK_Patient_Member_IsAdoptedFLAG_Yes_Or_No : ([IsAdoptedFLAG]='N' OR [IsAdoptedFLAG]='Y') Check Constraints CK_Patient_Member_IsAdoptedFLAG_Yes_Or_No : ([IsAdoptedFLAG]='N' OR [IsAdoptedFLAG]='Y')](../../../../Images/c-constraint.png) | IsAdoptedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating Adapted or Non Adapted |
 ![Check Constraints CK_Patient_Member_MultiBirthFLAG_Yes_Or_No : ([MultiBirthFLAG]='N' OR [MultiBirthFLAG]='Y') Check Constraints CK_Patient_Member_MultiBirthFLAG_Yes_Or_No : ([MultiBirthFLAG]='N' OR [MultiBirthFLAG]='Y')](../../../../Images/c-constraint.png) | MultiBirthFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating Multi Birth |
 | PlaceOfBirth | varchar(35) | 35 | NOT NULL | (' ') | Patients Birth Place |
 | EthnicGroup1 | char(2) | 2 | NOT NULL | (' ') | Ethnicity Group of Patient |
 | EthnicGroup2 | char(2) | 2 | NOT NULL | (' ') | Ethnicity Group of Patient |
 | EthnicGroup3 | char(2) | 2 | NOT NULL | (' ') | Ethnicity Group of Patient |
 ![Check Constraints CK_Patient_Member_IsCitizenFLAG_Yes_Or_No : ([IsCitizenFLAG]='N' OR [IsCitizenFLAG]='Y') Check Constraints CK_Patient_Member_IsCitizenFLAG_Yes_Or_No : ([IsCitizenFLAG]='N' OR [IsCitizenFLAG]='Y')](../../../../Images/c-constraint.png) | IsCitizenFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is Patient a Citizen |
 ![Check Constraints CK_Patient_Member_NeedsInterpreterFLAG_Yes_Or_No : ([NeedsInterpreterFLAG]='N' OR [NeedsInterpreterFLAG]='Y') Check Constraints CK_Patient_Member_NeedsInterpreterFLAG_Yes_Or_No : ([NeedsInterpreterFLAG]='N' OR [NeedsInterpreterFLAG]='Y')](../../../../Images/c-constraint.png) | NeedsInterpreterFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating Interpretor needed or Not |
 | EducationLevel | smallint | 2 | NOT NULL | (0) | Patient Educational Level |
 ![Check Constraints CK_Patient_Member_MilitaryServiceFLAG_Yes_Or_No : ([MilitaryServiceFLAG]='N' OR [MilitaryServiceFLAG]='Y') Check Constraints CK_Patient_Member_MilitaryServiceFLAG_Yes_Or_No : ([MilitaryServiceFLAG]='N' OR [MilitaryServiceFLAG]='Y')](../../../../Images/c-constraint.png) | MilitaryServiceFLAG | [dbo].[BOOL] | 1 | NOT NULL | (' ') | Flag indicating patient is serving in the military |
 ![Check Constraints CK_Patient_Member_IsVeteranFLAG_Yes_Or_No : ([IsVeteranFLAG]='N' OR [IsVeteranFLAG]='Y') Check Constraints CK_Patient_Member_IsVeteranFLAG_Yes_Or_No : ([IsVeteranFLAG]='N' OR [IsVeteranFLAG]='Y')](../../../../Images/c-constraint.png) | IsVeteranFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating the patient is a Veteran |
 | PersonsHousehold | smallint | 2 | NOT NULL | (0) | Number of people residing in the household |
 ![Check Constraints CK_Patient_Member_NCRStatusFLAG_Yes_Or_No : ([NCRStatusFLAG]='N' OR [NCRStatusFLAG]='Y') Check Constraints CK_Patient_Member_NCRStatusFLAG_Yes_Or_No : ([NCRStatusFLAG]='N' OR [NCRStatusFLAG]='Y')](../../../../Images/c-constraint.png) | NCRStatusFLAG | [dbo].[BOOL] | 1 | NOT NULL | | NCR Status of patient |
(2)![Check Constraints CK_Patient_Member_IsDeceasedFLAG_Yes_Or_No : ([IsDeceasedFLAG]='N' OR [IsDeceasedFLAG]='Y') Check Constraints CK_Patient_Member_IsDeceasedFLAG_Yes_Or_No : ([IsDeceasedFLAG]='N' OR [IsDeceasedFLAG]='Y')](../../../../Images/c-constraint.png) | IsDeceasedFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag to indicate Deceased |
(2)![Check Constraints CK_Patient_Member_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y') Check Constraints CK_Patient_Member_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsInactiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating Inactive or Active Patient |
 ![Check Constraints CK_Patient_Member_HasDonorCardFLAG_Yes_Or_No : ([HasDonorCardFLAG]='N' OR [HasDonorCardFLAG]='Y') Check Constraints CK_Patient_Member_HasDonorCardFLAG_Yes_Or_No : ([HasDonorCardFLAG]='N' OR [HasDonorCardFLAG]='Y')](../../../../Images/c-constraint.png) | HasDonorCardFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Flag indicating if a Donor Card exists or Not |
 ![Check Constraints CK_Patient_Member_IsConfidentialFLAG_Yes_Or_No : ([IsConfidentialFLAG]='N' OR [IsConfidentialFLAG]='Y') Check Constraints CK_Patient_Member_IsConfidentialFLAG_Yes_Or_No : ([IsConfidentialFLAG]='N' OR [IsConfidentialFLAG]='Y')](../../../../Images/c-constraint.png) | IsConfidentialFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is this patient data is confidential |
 | MotherID | [dbo].[uniqueid] | 9 | NOT NULL | | Mother. Link to Person.ID |
 | MothersMaidenName | varchar(35) | 35 | NOT NULL | (' ') | Mothers Maiden Name |
 ![Check Constraints CK_Patient_Member_HasLivingWillFLAG_Yes_Or_No : ([HasLivingWillFLAG]='N' OR [HasLivingWillFLAG]='Y') Check Constraints CK_Patient_Member_HasLivingWillFLAG_Yes_Or_No : ([HasLivingWillFLAG]='N' OR [HasLivingWillFLAG]='Y')](../../../../Images/c-constraint.png) | HasLivingWillFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Does the patient have a living will? |
 | ProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Primary Care Provider. Link to Provider.ID if PCPTYPE = 'P' or Referring_Provider_DE.ID if PCPTYPE = 'R'. |
 ![Check Constraints CK_Patient_Member_IsAnyCaseActiveFLAG_Yes_Or_No : ([IsAnyCaseActiveFLAG]='N' OR [IsAnyCaseActiveFLAG]='Y') Check Constraints CK_Patient_Member_IsAnyCaseActiveFLAG_Yes_Or_No : ([IsAnyCaseActiveFLAG]='N' OR [IsAnyCaseActiveFLAG]='Y')](../../../../Images/c-constraint.png) | IsAnyCaseActiveFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Is there an active case? |
 | AmbulatoryStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Ambulatory Status. Link to Ambulatory_Status_DE.ID. |
 ![Foreign Keys FK_Patient_Member_RegionDE_Region_DE_ID: [dbo].[Region_DE].RegionDE Foreign Keys FK_Patient_Member_RegionDE_Region_DE_ID: [dbo].[Region_DE].RegionDE](../../../../Images/fk.png) | RegionDE | [dbo].[dict_id] | 5 | NOT NULL | | Religion. Link to Region_DE.ID. |
 | ProxyMedFormularyDE | numeric(8,0) | 5 | NOT NULL | (0) | ProxyMed Formulary. No longer used. |
 ![Foreign Keys FK_Patient_Member_Pat_Loc_DE: [dbo].[Patient_Location_DE].PrimaryPatientLocationDE Foreign Keys FK_Patient_Member_Pat_Loc_DE: [dbo].[Patient_Location_DE].PrimaryPatientLocationDE](../../../../Images/fk.png) | PrimaryPatientLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Primary Location. Link to Patient_Location_DE.ID |
| SecondaryPatientLocation | varchar(255) | 255 | NULL allowed | | Secondary Location |
 ![Foreign Keys FK_Patient_Member_HomeChartLocationDE: [dbo].[Chart_Location_DE].HomeChartLocationDE Foreign Keys FK_Patient_Member_HomeChartLocationDE: [dbo].[Chart_Location_DE].HomeChartLocationDE](../../../../Images/fk.png) | HomeChartLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Usual Chart Location of the paper Chart. Link to Chart_Location_DE.ID. |
 ![Foreign Keys FK_Patient_Member_CurrentChartLocationDE: [dbo].[Chart_Location_DE].CurrentChartLocationDE Foreign Keys FK_Patient_Member_CurrentChartLocationDE: [dbo].[Chart_Location_DE].CurrentChartLocationDE](../../../../Images/fk.png) | CurrentChartLocationDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Current Location of the paper chart. Link to Chart_Location_DE.ID. |
| PCPTYPE | char(1) | 1 | NOT NULL | ('P') | P - Provider or R - Referring Provider |
| ExtMedHxStatus | char(1) | 1 | NULL allowed | ('U') | Medical History Status |
| ExtMedHxStatusChangedByID | [dbo].[uniqueid] | 9 | NULL allowed | | Medical History Changed by |
| ExtMedHxStatusChangedDTTM | datetime | 8 | NULL allowed | | Medical History changed when |
| MAIVer | varchar(35) | 35 | NOT NULL | ('') | MAIVer |
| MAIPatDesc | varchar(255) | 255 | NOT NULL | ('') | MAIPatDesc |
| MAIPatInd | char(15) | 15 | NOT NULL | ('') | MAIPatInd |
| BirthOrder | tinyint | 1 | NOT NULL | ((0)) | Birth order if the patient is from a multiple birth |
| EmpaneledToType | char(1) | 1 | NOT 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] | 9 | NOT NULL | ((0)) | Holds PCP ID or PCT ID |
![Foreign Keys FK_Patient_Member_AgencyDE_Agency_DE_ID: [dbo].[Agency_DE].AgencyDE Foreign Keys FK_Patient_Member_AgencyDE_Agency_DE_ID: [dbo].[Agency_DE].AgencyDE](../../../../Images/fk.png) | AgencyDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Agency. Link to Agency_DE |
![Foreign Keys FK_Patient_Member_BureauDE_Bureau_DE_ID: [dbo].[Bureau_DE].BureauDE Foreign Keys FK_Patient_Member_BureauDE_Bureau_DE_ID: [dbo].[Bureau_DE].BureauDE](../../../../Images/fk.png) | BureauDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Bureau. Link to Bureau_DE |
![Foreign Keys FK_Patient_Member_EmploymentTypeDE_Employment_Type_DE_ID: [dbo].[Employment_Type_DE].EmploymentTypeDE Foreign Keys FK_Patient_Member_EmploymentTypeDE_Employment_Type_DE_ID: [dbo].[Employment_Type_DE].EmploymentTypeDE](../../../../Images/fk.png) | EmploymentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Employment Type. Link to Employment_Type_DE |
| EmployeeType | char(1) | 1 | NOT NULL | ('') | Employee Type = E - Employee or D - Dependent |
![Foreign Keys FK_Patient_Member_JobTitleDE_Job_Title_DE_ID: [dbo].[Job_Title_DE].JobTitleDE Foreign Keys FK_Patient_Member_JobTitleDE_Job_Title_DE_ID: [dbo].[Job_Title_DE].JobTitleDE](../../../../Images/fk.png) | JobTitleDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Job Title. Link to Job_Title_DE |
![Foreign Keys FK_Patient_Member_PostDE_Post_DE_ID: [dbo].[Post_DE].PostDE Foreign Keys FK_Patient_Member_PostDE_Post_DE_ID: [dbo].[Post_DE].PostDE](../../../../Images/fk.png) | PostDE | [dbo].[dict_id] | 5 | NOT NULL | ((0)) | Post. Link to Post_DE |