You are here:
Fetch Group Class Contribution Records for Premium Calculation
During enrollment, fetch all the valid group class contribution records for the group class associated with each member.
Valid records are group class contributions with a start date on or before the contract start date, an end date on or after the contract end date, and a type that's not blank or null.
The logic used to select the group class contribution record from the fetched list to calculate premium for a specific census member and plan combination are described in the later sections. For each of the below mentioned cases, if there are multiple group class contribution records, the most recently modified group class contribution record is picked up to calculate premium.
With Member Level Premium For Subscriber
-
ContractGroupPlanID+MemberType=Subscriber -
ContractGroupPlanID -
ProductID+MemberType=Subscriber -
ProductID -
ProductCategory+MemberType=Subscriber -
ProductCategory
With Member Level Premium for Dependent
-
ContractGroupPlanID+MemberType=Dependent -
ContractGroupPlanID+MemberType=Subscriber -
ContractGroupPlanID -
ProductID+MemberType=Dependent -
ProductID+MemberType=Subscriber -
ProductID -
ProductCategory+MemberType=Dependent -
ProductCategory+MemberType=Subscriber -
ProductCategory
Without Member Level Premium for Primary and Dependent
-
ContractGroupPlanID+MemberType=Subscriber -
ContractGroupPlanID -
ProductID+MemberType=Subscriber -
ProductID -
ProductCategory+MemberType=Subscriber -
ProductCategory
