C1_AGEBDELG
This algorithm returns a list of eligible members for a membership for age based pricing rule type. It uses the relation matrix to identify the main subscriber , spouse and children, after which the main subscriber and spouse are added to the eligible list while the eligible children to be added are identified based on max age of dependent, max number of dependents and order priority i.e. whether to consider the eldest or the youngest children if the max number of dependents exceeds. And if one of the dependent is a new born and the gift days is applicable then after retrieving the no of gift days, the start date is pushed back by the no of gift days.
-
For Group Membership - The required values will be be fetched from the Characteristics attached on the Pricing Rule Type.
-
For Individual Membership
-
The required values like MAX_NUM_OF_DEP, MAX_AGE_LIMIT_OF_DEP, DEP_ORDER_PRIORITY_FLG etc. will be fetched from C1_BUS_RULE_PRC table for that business rule id.
-
The new born related values like GIFT_DAYS_APPL_SW, GIFT_DAYS will be fetched from C1_BUS_RULE_NEW_BORN table for that business rule id.
-