The formula is intended to determine whether a life event (e.g., the transition from full-time to part-time employment) should be created based on the change in normal working hours. It looks at the employee’s old and new normal working hours to check for a specific condition.
/*****************************************************************************
FORMULA NAME: BEN_FT_TO_PT
FORMULA TYPE: Person Change Causes Life Event
DESCRIPTION: FullTime to PartTime LifeEvent
Change History:
Name Date Comments
-----------------------------------------------
*******************************************************************************/
INPUTS ARE BEN_ASG_IO_NORMAL_HOURS(text), BEN_ASG_IN_NORMAL_HOURS(text)
DEFAULT for BEN_ASG_IO_NORMAL_HOURS is '0'
DEFAULT for BEN_ASG_IN_NORMAL_HOURS is '0'
l_create_ptnl = 'N'
l_old = TO_NUMBER(BEN_ASG_IO_NORMAL_HOURS)
l_new = TO_NUMBER(BEN_ASG_IN_NORMAL_HOURS)
IF l_old => 30 and l_new <30 and l_new >=20
THEN
l_create_ptnl = 'Y'
RETURN l_create_ptnl
