|
Every row in EDI_EligResponseMembers represents a single Member of Dependent. Every row in EDI_EligResponseBenefits stores a single Benefit in its entirety. The Benefit itself is identified by its Service Type Code and MemberID, tying to a specific member; there will be a single row for each Benefit (Service Type Code), of which many can be linked to a single Member or Dependent. This allows us to fully represent any Member's or Dependent's Eligibility and Benefit information in a database as compactly as possible without losing information.
|