Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (9)![Foreign Keys FK_Patient_PBM_PatientID_Person_ID: [dbo].[Person].PatientID Foreign Keys FK_Patient_PBM_PatientID_Person_ID: [dbo].[Person].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Person.ID |
  ![Foreign Keys FK_Patient_PBM_PBMDE_PBM_DE_ID: [dbo].[PBM_DE].PBMDE Foreign Keys FK_Patient_PBM_PBMDE_PBM_DE_ID: [dbo].[PBM_DE].PBMDE](../../../../Images/fk.png) | PBMDE | [dbo].[dict_id] | 5 | NOT NULL | | PBM. Link to PBM_DE.ID |
 | PBMProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | Rx Benefit plan provider ID |
 | GroupNumber | varchar(50) | 50 | NULL allowed | | Group policy identification number |
 | InsOrgID | varchar(20) | 20 | NOT NULL | | Insurance Organization ID |
(2) | MemberNumber | varchar(50) | 50 | NULL allowed | | Member Number of Insurance policy |
(2)![Foreign Keys FK_Patient_PBM_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE Foreign Keys FK_Patient_PBM_RelationshipDE_Relationship_DE_ID: [dbo].[Relationship_DE].RelationshipDE](../../../../Images/fk.png) | RelationshipDE | [dbo].[dict_id] | 5 | NOT NULL | | Relationship. Link to Relationship_DE.ID |
 | MailServiceFLAG | char(1) | 1 | NULL allowed | | Flag to indicate Mail Service |
| PBMConsentDT | datetime | 8 | NULL allowed | | Concent Date for PBM |
 | PBMLastUpdateDTTM | datetime | 8 | NULL allowed | | Last Updated Date and Time |
![Check Constraints EligibilityState : ([EligibilityState]='F' OR [EligibilityState]='N' OR [EligibilityState]='Y') Check Constraints EligibilityState : ([EligibilityState]='F' OR [EligibilityState]='N' OR [EligibilityState]='Y')](../../../../Images/c-constraint.png) | EligibilityState | char(1) | 1 | NOT NULL | ('N') | Flag for Eligibility State |
 | Org_Pat_ID | varchar(80) | 80 | NOT NULL | | Composite PK with PBMDE and PatientID |
| Formu_ID | varchar(80) | 80 | NULL allowed | | Formulary ID of the insurance plan for the patient |
| Alt_ID | varchar(80) | 80 | NULL allowed | | Alternative ID |
 | Mail_Ord_NABP | char(7) | 7 | NULL allowed | | Mail Order NABP Detail |
 | Last_Elig_Check | datetime | 8 | NULL allowed | | Last Eligibility Check on date |
 | Source | varchar(30) | 30 | NOT NULL | ('') | Data source which updated the record. Ex : Touchworks , Registration Interface, Eligibility Check etc. |
| CreateDTTM | datetime | 8 | NOT NULL | (getdate()) | Record created date time. |
 ![Check Constraints CK_Patient_PBM_DefaultFLAG_Yes_Or_No : ([DefaultFLAG]='N' OR [DefaultFLAG]='Y') Check Constraints CK_Patient_PBM_DefaultFLAG_Yes_Or_No : ([DefaultFLAG]='N' OR [DefaultFLAG]='Y')](../../../../Images/c-constraint.png) | DefaultFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('Y') | Defalut PBM for the patient indicator |
 | LastDefaultedDTTM | datetime | 8 | NOT NULL | (getdate()) | Last Updated Date and Time |
| RetailBenefitFlag | char(1) | 1 | NULL allowed | | Flag to indicate Retail Benefit |
| CoverageID | varchar(80) | 80 | NULL allowed | | Coverage ID of the policy |
| BIN | varchar(50) | 50 | NULL allowed | | BIN |
| PCN | varchar(30) | 30 | NULL allowed | | PCN |
| CoPayID | varchar(80) | 80 | NULL allowed | | Co Pay Policy ID |
| InsTypPharm | char(3) | 3 | NULL allowed | | Insurance Type Pharmacy |
| PlanDescPharm | varchar(50) | 50 | NULL allowed | | Plan Description |
| OOPPharm | varchar(18) | 18 | NULL allowed | | Out of Pocket Pharmacy |
| InsTypMOB | char(3) | 3 | NULL allowed | | Mail Order Benefit Insurance Type |
| PlanDescMOB | varchar(50) | 50 | NULL allowed | | Mail Order Benefit Plan Description |
| OOPMOB | varchar(18) | 18 | NULL allowed | | Out of Pocket Mail Order Benefit |
| PayerIdentCd | char(3) | 3 | NULL allowed | | Payer Identification Code |
| PayerIdentCdDesc | varchar(35) | 35 | NULL allowed | | Payer Identification Code Description |
| BenefitSpecialty | char(1) | 1 | NULL allowed | | Specialty Benefit |
| PlanNameSpecialty | varchar(50) | 50 | NULL allowed | | Specialty Plan Name |
| BenefitLTC | char(1) | 1 | NULL allowed | | Long Term Care Benefit |
| PlanNameLTC | varchar(50) | 50 | NULL allowed | | Long Term Care Plan Name |