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 | Data Type | Required | Description |
---|---|---|---|
CON_PERSON_ID | NUMBER | N |
Dependent personID |
Return Variables
Use predefined names for return variables.
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