Beneficiary Certification Required
This formula type can be used to determine the conditions under which a person must provide certification for his or her designated beneficiaries.
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
- ORGANIZATION_ID
- JURISDICTION_CODE
- PGM_ID
- PL_ID
- PL_TYP_ID
- OPT_ID
- LER_ID
Database Items
Use only the following database items that are available to formulas of this type:
- All columns except attribute columns from tables: ben_ler_f, ben_pgm_f, ben_pl_f, ben_opt_f, ben_pl_typ_f
- Database items based on person’s assignment – HR_ASSIGNMENT_ID AND PERSON_ID
Input Variables
Input variables are not available to formulas of this type.
Return Variables
Use predefined names for return variables. The following return variables are available to formulas of this type.
Return Value | Data Type | Required | Description |
---|---|---|---|
L_OUTPUT | Char | Y | 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_BNFCR_CERT_REQD
FORMULA TYPE: Beneficiary Certification Required
DESCRIPTION: A Single person need to provide certificates for beneficiary.
DEFAULT for PER_PER_MARITAL_STATUS is ‘X’
l_output = ‘N’
l_mar_status = PER_PER_MARITAL_STATUS
if (l_mar_status = ‘S’)
then
(l_output = ‘Y’)
else
(l_output = ‘N’)
Return l_output
Sample Formula 2:
FORMULA NAME: BEN_BNFCR_CERT_REQD
FORMULA TYPE: Beneficiary Certification Required
DESCRIPTION: Person needs to provide certificates for plans which allow minors/trustees and organizations as beneficiaries.
DEFAULT for BEN_PLN_BNF_DSGE_MNR_TTEE_RQD_FLAG is 'X'
DEFAULT for BEN_PLN_BNF_MAY_DSGT_ORG_FLAG is 'X'
l_output = 'N'
l_minor_tte = BEN_PLN_BNF_DSGE_MNR_TTEE_RQD_FLAG
l_org_bnf = BEN_PLN_BNF_MAY_DSGT_ORG_FLAG
if (l_minor_tte = 'Y' or l_org_bnf = 'Y' )
then
(l_output = 'Y')
else
(l_output = 'N')
Return l_output