Age Determination Date
This formula type can be used to determine the date from which age will be calculated for a person.
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 | Return variable |
Errors
If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.
Sample Formula 1:
FORMULA NAME: BEN_AGE_DET_DT
FORMULA TYPE: Age Determination Date
DESCRIPTION: The Age determination date is the start date of next month.
l_effective_date = GET_CONTEXT(EFFECTIVE_DATE, TO_DATE(’01-JAN-2012’))
l_last_day = last_day(l_effective_date)
l_output = add_days(l_last_day,1)
return l_outputSample Formula 2:
FORMULA NAME: BEN_AGE_DET_DT
FORMULA TYPE: Age Determination Date
DESCRIPTION: The Age determination date is based on person’s job.
DEFAULT for PER_ASG_JOB_NAME is 'XYZ'
l_job = PER_ASG_JOB_NAME
l_effective_date = GET_CONTEXT(EFFECTIVE_DATE, TO_DATE('01-JAN-2012'))
l_output = last_day(add_months(l_effective_date,-1))
if l_job = 'Remote Worker' then
( l_output = add_days(l_output,1) )
Else
( l_output = last_day(l_effective_date))
return l_output