1. Administering Fast Formulas
  2. Dependent Certification Required

Dependent Certification Required

This formula can be used to determine the conditions under which a person must provide certification for his or her designated dependents.

Contexts

The following contexts are available to formulas of this type:

  • BUSINESS_GROUP_ID ( ENTERPRISE_ID)
  • EFFECTIVE_DATE
  • HR_ASSIGNMENT_ID
  • PERSON_ID
  • LER_ID
  • PGM_ID
  • PL_ID
  • PL_TYP_ID

Database Items

Use only the following database items that are available to formulas of this type:

  • Database items based on person’s assignment:HR_ASSIGNMENT_ID AND PERSON_ID

Input Variables

The following input variable is available.

Input variables table

Input Data Type Required Description
CON_PERSON_ID NUMBER N

Dependent personID

Return Variables

Use predefined names for return variables.

Return variables table

Out Variable name Data Type Remarks
L_OUTPUT Varchar2 Y or N

Errors

If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.

Sample Formula 1:

FORMULA NAME: BEN_DPNT_CERT

FORMULA TYPE: Dependent Certification Required

Returned Value: Returned l_return is a Y/N value.

/
inputs are CON_PERSON_ID(number)
default for BEN_LER_NAME is 'NA'
l_ler_name=BEN_LER_NAME
l_dpnt_id=CON_PERSON_ID
l_return='Y'
l_chk_dpnt_ctfn='N'
l_chk_dpnt_ctfn2='N'
l_eff_date='1951/01/01 00:00:00'(date)
l_context_date='1951/01/01 00:00:00'(date)
l_eff_date = GET_CONTEXT(EFFECTIVE_DATE,to_date('1951/01/01 00:00:00') )
l_context_date=add_days(l_eff_date,-1)
change_contexts(EFFECTIVE_DATE=l_context_date)
(
if (l_ler_name = 'Open') then
(
l_chk_dpnt_ctfn=BEN_FN_GET_CHAR_VALUE(
'BEN_CVRD_DPNT_CTFN_PRVDD'
,'PROVIDED'
,'PlanA'
,'OptionA'
,to_char(l_dpnt_id)
,'Birth certificate'
)
l_chk_dpnt_ctfn2=BEN_FN_GET_CHAR_VALUE(
'BEN_CVRD_DPNT_CTFN_PRVDD'
,'PROVIDED'
,'PlanB'
,'OptionB'
,to_char(l_dpnt_id)
,'Birth certificate'
)
if (l_chk_dpnt_ctfn='Y' or l_chk_dpnt_ctfn2='Y' ) then (l_return='N')
)
)
return l_return

Sample Formula 2:

FORMULA TYPE: Dependent Certification Required

DEFAULT FOR BEN_LER_NAME is 'Default'
l_ler_name = BEN_LER_NAME
l_cert_rqrd = 'Y'
/* Do not trigger certifications for Open/Salary Change life events
*/
IF ( l_ler_name = 'Open'
or l_ler_name = 'Salary Change'
)
then
(
l_cert_rqrd = 'N'
)
return l_cert_rqrd

Sample Formula 3:

FORMULA TYPE: Dependent Certification Required

inputs are CON_PERSON_ID(number)
l_dpnt_id=CON_PERSON_ID
l_return='Y'
l_chk_dpnt_ctfn='N'
/* Check if the certificate is already provided in the past.
Possible values for the certificates are
1. Adoption certificate
2. Birth certificate
3. Domestic partner certificate
4. Legal custody certificate
5. Marriage certificate
*/
l_chk_dpnt_ctfn=BEN_FN_GET_CHAR_VALUE(
'BEN_CVRD_DPNT_CTFN_PRVDD'
,'PROVIDED'
,'NA_CHECK_ONCE'
,'NA'
,to_char(l_dpnt_id)
,'Marriage certificate'
)
if (l_chk_dpnt_ctfn='Y') then
(l_return='N')
return l_return