Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
PatientEligibilityInfo This table holds information about prescription plans. This information is used during the prescription writing process.
Column Name Column Datatype Column Null Option Column Comment
PatientEligibilityInfoOIDintNOT NULL Object ID of PatientEligibilityInfo table
PatientOIDintNOT NULL Foreign key to HPatient table
CardHolderIDvarchar(50)NULL Insurance Primary Card Holder ID
CardHolderNamevarchar(80)NULL Insurance Primary Card Holder Name
PBMUniqueIDvarchar(80)Not NULL Pharmacy Benefit Manager(PBM) Unique ID for a patient used for formulary
PBMNamevarchar(60)Not NULL PBM(Pharmacy Benefit Manager) Name
PBMGroupIDvarchar(50)NULL PBM(Pharmacy Benefit Manager)Group ID
PharmacyPlanIDvarchar(50)NULL Pharmacy Plan ID
PharmacyPlanNamevarchar(80)NULL Pharmacy Plan Name
PharmacyPlanBINvarchar(30)NULL Pharmacy Plan BIN Number used for a prescription
PharmacyPlanPCNvarchar(80)NULL Pharmacy Control Number
FormularyIDvarchar(50)NOT NULL PBM(Pharmacy Benefit Manager) Plan Formulary ID
CopayIDvarchar(80)NULL PBM(Pharmacy Benefit Manager) Plan Copay ID
CoverageIDvarchar(80)NULL PBM(Pharmacy Benefit Manager)Plan Coverage ID
AlternativeIDvarchar(80)NULL PBM(Pharmacy Benefit Manager)Plan Alternative ID
SubscriberIDvarchar(80)NULL Sure Scripts assigned Subscriber ID
SubscriberLastNamevarchar(60)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber last name
SubscriberFirstNamevarchar(35)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager) subscriber first name
SubscriberMiddleNamevarchar(25)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber middle name
SubscriberSuffixvarchar(10)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber suffix
SubscriberAddressvarchar(110)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager) subscriber address
SubscriberCityvarchar(30)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber city
SubscriberStatevarchar(2)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber state
SubscriberZipCodevarchar(15)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber zip code
SubscriberDOBvarchar(35)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber date of birth
SubscriberGendervarchar(1)NULL Sure Scripts returned subscriber info PBM(Pharmacy Benefit Manager)subscriber gender
EligibilityRetailIndsmallintNULL Retail pharmacy coverage flag((Allowable Values: 0 - None, 1- Inactive, 2 Active )
RetailOutOfPocketAmountvarchar(18)NULL Retail out of pocket amount
EligibilityMailOrderIndsmallintNULL Mailorder pharmacy coverage flag((Allowable Values: 0 - None, 1- Inactive, 2 Active )
MailOrderOutOfPocketAmountvarchar(18)NULL Mail order out of pocket amount
PlanActiveIndsmallintNOT NULL Indicates plan is active or not(Allowable values 0 - No and 1 - Yes)
EligibilityBenefitIndsmallintNOT NULL Benefit coverage flag. Bitmap to indicate benefit coverage(1st bit:LongTermCare, 2nd bit:Specialty)
EligibilityTransactionIdvarchar(35)NULL Surescripts generated the eligibility transaction id
CreateDTimedatetimeNOT NULL Created Date Time(wall clock)
LastCheckedDTimedatetimeNOT NULL Last Date time within last 24 hours when Eligibility Info was retrieved(wall clock)
LastCngDTimedatetimeNOT NULLLast Updated Date Time( EA/DSS(UTC) - Current Universal Time Coordinate or Greenwich Mean Time)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates