Participation and Rate Eligibility

Contexts

The following contexts are available to formulas of this type:

BUSINESS_GROUP_ID ( ENTERPRISE_ID)
EFFECTIVE_DATE
HR_ASSIGNMENT_ID
LER_ID
OPT_ID
ORGANIZATION_ID
PGM_ID
PL_ID
PL_TYP_ID
PERSON_ID

Database Items

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

All columns except attribute columns from tables:
- EN_CVG_AMT_CALC_MTHD_F
- BEN_LER_F
- BEN_OIPL_F
- BEN_OPT_F
- BEN_PGM_F
- BEN_PLIP_F
- BEN_PL_F
- BEN_PL_TYP_F
- BEN_PTIP_F
- BEN_YR_PERD
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 variables table

Return Value	Data Type	Required	Description
ELIGIBLE	Char	N	Returns Y or N

Erros

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

The formula BEN_PRTT_FTE_ELIG returned an invalid value.

Sample Formula 1:

FORMULA NAME: BEN_PRTT_FTE_ELIG

FORMULA TYPE: Participation and Rate Eligibility

DESCRIPTION: This sample formula determines if a person is eligible for a compensation object based on the FTE on the assignment.

/*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/
Default for PER_ASG_FTE is 0
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
l_fte = PER_ASG_FTE
ELIGIBLE = ‘N’
IF l_fte = 1 THEN
(ELIGIBLE = ‘Y’)
return ELIGIBLE
/*================ FORMULA SECTION END =======================*/

Sample Formula 2:

FORMULA NAME: BEN_PRTT_ASG_ELIG

FORMULA TYPE: Participation and Rate Eligibility

DESCRIPTION: This sample formula determines if a person is eligible for a compensation object based on his country of residence. Note: Needs PERSON_ID context to work.

Default for PER_PER_ADD_COUNTRY is 'X'
l_cntry = PER_PER_ADD_COUNTRY
ELIGIBLE = 'N'
IF (l_cntry = 'US') THEN
(ELIGIBLE = 'Y')
return ELIGIBLE

Sample Formula 3:

Formula Type: Participation and Rate Eligibility

Purpose: Return eligible if the participant has a dependent (child) whose age is less than 26 years by using DBI items (when there are custom user roles configured in the system).

DEFAULT_DATA_VALUE FOR PER_PER_CONT_REL_CONTACT_PERSON_ID is 0
DEFAULT_DATA_VALUE FOR PER_PER_CONT_REL_CONTACT_TYPE is 'NA'
DEFAULT FOR PER_PER_DATE_OF_BIRTH is '1951/01/01 00:00:00' (date)
l_eff_date = GET_CONTEXT(EFFECTIVE_DATE, to_date('1951/01/01 00:00:00'))
ELIGIBLE='N'
i=1
WHILE PER_PER_CONT_REL_CONTACT_PERSON_ID.EXISTS(i)
loop
(
if ( PER_PER_CONT_REL_CONTACT_TYPE[i]='C' ) then
(
CHANGE_CONTEXTS(PERSON_ID=PER_PER_CONT_REL_CONTACT_PERSON_ID[i])
(
l_dob = PER_PER_DATE_OF_BIRTH
if ( months_between(l_eff_date,l_dob) < 312 ) then
(
/* there is a child whose age is less than 26 years */
ELIGIBLE='Y'
EXIT
)
) /* end change_contexts */
) /* end contact_type = C */
i=i+1
) /* end loop on contacts */
return ELIGIBLE

Sample Formula 4:

FORMULA NAME: BEN_TOB_USE_DEP_ELIG_FF

FORMULA TYPE: Participation and Rate Eligibility

DESCRIPTION: Validating Tobacco Usage details for dependent.

DEFAULT for BEN_PHB_TOBACCO_TYPE_USAGE is 'xyz'

DEFAULT_DATA_VALUE for PER_EXT_CONT_PER_PERSON_ID is 0

/************FORMULA SECTION BEGIN*************/
ELIGIBLE= 'N'
i = 1
/*Checking for the TOBACCO_USER lookup code as 'Y' corresponding to the meaning as 'ANY'*/
while PER_EXT_CONT_PER_PERSON_ID.exists(i) loop
(
CHANGE_CONTEXTS(PERSON_ID = PER_EXT_CONT_PER_PERSON_ID[i])
(
If BEN_PHB_TOBACCO_TYPE_USAGE = 'Y' THEN
(ELIGIBLE = 'Y' )
i = i + 1
)
)
Return ELIGIBLE