This formula checks for specific life events (such as marriage, birth, adoption, etc.), verifies if the employee is enrolled in the relevant benefits plan, and triggers a certification requirement if necessary. If a self-assigned life event occurs, it determines whether the employee is enrolled in the plan and if certification is needed.
/**************************************************************
Formula Name: SELF_ASSIGNED_CER_ENROLLMENT
Formula Type: Enrollment Certification Required
Purpose: Triggers certification for self-assigned life events
Change History:
/*************************************************************/
DEFAULT FOR BEN_PLN_NAME IS 'A'
DEFAULT FOR BEN_OPT_NAME IS 'A'
DEFAULT FOR BEN_LER_NAME is 'BBB'
l_return='Y'
l_emp_enrd='N'
l_lf_evt_ocrd_dt = GET_CONTEXT(EFFECTIVE_DATE,to_date('1951/01/01 00:00:00') )
l_self_assign_event = 'N'
l_first_event = 'N'
l_ler_name = BEN_LER_NAME
l_pl_name = BEN_PLN_NAME
l_opt_name = BEN_OPT_NAME
IF
(
l_ler_name = 'Marriage' OR
l_ler_name = 'Child Birth' OR
l_ler_name = 'Adoption' OR
l_ler_name = 'Separation or Divorce' OR
l_ler_name = 'Change Beneficiary' OR
l_ler_name = 'Death of Dependent'
) THEN (l_self_assign_event = 'Y')
l_day_before = add_days(l_lf_evt_ocrd_dt,-1)
change_contexts(EFFECTIVE_DATE=l_day_before)
(
l_emp_enrd = ben_fn_get_char_value('BEN_PRTT_ENRT_RSLT','ENROLLED',l_pl_name,l_opt_name)
)
if ( (l_emp_enrd = 'Y')
or (l_ler_name like '%System Implementation%')
or (l_self_assign_event = 'N' )
) then
(
l_return = 'N'
)
return l_return
ravi
Great Job
Prostokva__espr
Hello! I hope you’re having a great day. Good luck 🙂