Dependent Eligibility
This formula type can be used to determine whether a contact is eligible to be covered as a dependent in a compensation object.
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 available to formulas of this type.
Input | Data Type | Required | Description |
---|---|---|---|
CON_PERSON_ID | Number | Contact person id |
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_DPNT_ELIG
FORMULA TYPE: Dependent Eligibility
DESCRIPTION: One son or daughter are eligible. This formula relies upon benefits seeded formula function - ben_fn_get_char_value.
default for l_sons is 0
default for l_daughters is 0
l_output = 'N'
l_sons_t = ben_fn_get_char_value(
' PER_CONTACT_RELSHIPS_F' ,'SON_COUNT'
,' ' ,' '
,'LEGISLATION_CODE' ,'US'
)
l_sons = to_num(l_sons_t)
l_daughters_t = ben_fn_get_char_value(
'PER_CONTACT_RELSHIPS_F'
,'DAUGHTER_COUNT'
,' '
,' '
,'LEGISLATION_CODE'
,'US'
)
l_daughters = to_num(l_daughters_t)
if ( l_sons <= 1 and l_daughters = 1 ) then
(l_output = 'Y')
if (l_sons= 1 and l_daughters <= 1) then
(l_output = 'Y' )
return l_output
Sample Formula 2:
FORMULA NAME: BEN_DPNT_ELIG2
FORMULA TYPE: Dependent Eligibility
DESCRIPTION: Dependents of persons above 60 yrs are ineligible.
DEFAULT for PER_PER_DATE_OF_BIRTH is '01-JAN-1951' (date)
l_output = 'N'
l_dob = PER_PER_DATE_OF_BIRTH
l_eff_date = GET_CONTEXT(EFFECTIVE_DATE,to_date('01-JAN-2012'))
if ( add_months (l_dob,720) > l_eff_date ) then
(l_output = 'N')
else
(l_output = 'Y' )
return l_output
Sample Formula 3:
FORMULA NAME: BEN_DPNT_ELIG2
FORMULA TYPE: Dependent Eligibility
DESCRIPTION: Dependents of persons based on age and address, relationship.
DEFAULT_DATA_VALUE for PER_EXT_CONT_CONTACT_TYPE is 'NA'
DEFAULT_DATA_VALUE FOR PER_EXT_CONT_DATE_OF_BIRTH IS '1951-01-01' (DATE)
DEFAULT_DATA_VALUE FOR PER_EXT_CONT_PER_PERSON_ID IS 0 DEFAULT FOR PER_ASG_ADD_REGION2 IS 'NA'
INPUTS ARE CON_PERSON_ID
ELIGIBLE = 'N'
l_lf_evt_dt_char = ben_fn_get_char_value('BEN_PER_IN_LER','LF_EVT_OCRD_DT'
,' '
,' '
,'BENEFIT_RELATION_NAME'
,'DFLT')
l_lf_evt_ocrd_dt = TO_DATE(l_lf_evt_dt_char)
i=1
WHILE PER_EXT_CONT_CONTACT_TYPE.exists(i)
LOOP
(
IF (PER_EXT_CONT_PER_PERSON_ID[i] = CON_PERSON_ID) AND
(PER_EXT_CONT_CONTACT_TYPE[i]='SAME_SEX_DOMESTIC_PARTNER_CHIL' OR
PER_EXT_CONT_CONTACT_TYPE[i]='C' OR
PER_EXT_CONT_CONTACT_TYPE[i]='O' OR
PER_EXT_CONT_CONTACT_TYPE[i]='A' OR
PER_EXT_CONT_CONTACT_TYPE[i]='T') AND
(PER_ASG_ADD_REGION2 = 'OH' or upper(PER_ASG_ADD_REGION2) = 'OHIO') AND
(MONTHS_BETWEEN(l_lf_evt_ocrd_dt, PER_EXT_CONT_DATE_OF_BIRTH[i])) < 336 THEN
(
ELIGIBLE = 'Y'
)
i=i+1
)
RETURN ELIGIBLE