Waiting Period Value and UOM
Participants need to complete a waiting period before they can gain eligibility to a benefits object. Sometimes employees have to wait for six months to get eligibility to a benefits object. Use the waiting period value formula type if the waiting period varies from employee to employee based on their organization or for rehired employees.
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
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_pl_f, ben_pgm_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 |
---|---|---|---|
WAIT_PERD_VAL | Number | Y | Waiting period value |
WAIT_PERD_UOM | Char | Y |
Return value should be one of the codes: DY, WK, MO, QTR, YR |
Errors
If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.
Sample Formula 1:
FORMULA NAME: BEN_WAIT_VAL_UOM
FORMULA TYPE: Waiting period value and UOM
DESCRIPTION: Determine waiting periods based on org and country of birth.
default for PER_ASG_COUNTRY_OF_BIRTH is 'XX' default for PER_ASG_JOB_NAME is 'ABC'
l_cntry = PER_ASG_COUNTRY_OF_BIRTH
l_job = PER_ASG_JOB_NAME
if ( l_cntry <> 'US' and l_job = 'Content Writer' ) then
(WAIT_PERD_VAL = 6
WAIT_PERD_UOM = 'MO' )
Else
(WAIT_PERD_VAL = 1
WAIT_PERD_UOM = 'MO' )
return WAIT_PERD_VAL, WAIT_PERD_UOM