Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
PatientEligibilityInfoOID | int | NOT NULL | Object ID of PatientEligibilityInfo table |
PatientOID | int | NOT NULL | Foreign key to HPatient table |
CardHolderID | varchar(50) | NULL | Insurance Primary Card Holder ID |
CardHolderName | varchar(80) | NULL | Insurance Primary Card Holder Name |
PBMUniqueID | varchar(80) | Not NULL | Pharmacy Benefit Manager(PBM) Unique ID for a patient used for formulary |
PBMName | varchar(60) | Not NULL | PBM(Pharmacy Benefit Manager) Name |
PBMGroupID | varchar(50) | NULL | PBM(Pharmacy Benefit Manager)Group ID |
PharmacyPlanID | varchar(50) | NULL | Pharmacy Plan ID |
PharmacyPlanName | varchar(80) | NULL | Pharmacy Plan Name |
PharmacyPlanBIN | varchar(30) | NULL | Pharmacy Plan BIN Number used for a prescription |
PharmacyPlanPCN | varchar(80) | NULL | Pharmacy Control Number |
FormularyID | varchar(50) | NOT NULL | PBM(Pharmacy Benefit Manager) Plan Formulary ID |
CopayID | varchar(80) | NULL | PBM(Pharmacy Benefit Manager) Plan Copay ID |
CoverageID | varchar(80) | NULL | PBM(Pharmacy Benefit Manager)Plan Coverage ID |
AlternativeID | varchar(80) | NULL | PBM(Pharmacy Benefit Manager)Plan Alternative ID |
SubscriberID | varchar(80) | NULL | Sure Scripts assigned Subscriber ID |
SubscriberLastName | varchar(60) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber last name |
SubscriberFirstName | varchar(35) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager) subscriber first name |
SubscriberMiddleName | varchar(25) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber middle name |
SubscriberSuffix | varchar(10) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber suffix |
SubscriberAddress | varchar(110) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager) subscriber address |
SubscriberCity | varchar(30) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber city |
SubscriberState | varchar(2) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber state |
SubscriberZipCode | varchar(15) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber zip code |
SubscriberDOB | varchar(35) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber date of birth |
SubscriberGender | varchar(1) | NULL | Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber gender |
EligibilityRetailInd | smallint | NULL | Retail pharmacy coverage flag((Allowable Values: 0 - None, 1- Inactive, 2 Active ) |
RetailOutOfPocketAmount | varchar(18) | NULL | Retail out of pocket amount |
EligibilityMailOrderInd | smallint | NULL | Mailorder pharmacy coverage flag((Allowable Values: 0 - None, 1- Inactive, 2 Active ) |
MailOrderOutOfPocketAmount | varchar(18) | NULL | Mail order out of pocket amount |
PlanActiveInd | smallint | NOT NULL | Indicates plan is active or not(Allowable values 0 - No and 1 - Yes) |
EligibilityBenefitInd | smallint | NOT NULL | Benefit coverage flag. Bitmap to indicate benefit coverage(1st bit:LongTermCare, 2nd bit:Specialty) |
EligibilityTransactionId | varchar(35) | NULL | Surescripts generated the eligibility transaction id |
CreateDTime | datetime | NOT NULL | Created Date Time(wall clock) |
LastCheckedDTime | datetime | NOT NULL | Last Date time within last 24 hours when Eligibility Info was retrieved(wall clock) |
LastCngDTime | datetime | NOT NULL | Last Updated Date Time( EA/DSS(UTC) - Current Universal Time Coordinate or Greenwich Mean Time) |