The formula evaluates an employee’s marital status, job role, and whether they work from home. If all of the conditions are met, it sets the output to 'Y', otherwise, it returns 'N'.
/**************************************************************
Formula Name: PER_SEL_Formula
Formula Type: Person Selection
Purpose: This formula selects employees based on marital status, job, and work from home status.
Change History:
/*************************************************************//*=========== DATABASE ITEM DEFAULTS BEGIN =====================*/ DEFAULT for PER_PER_MARITAL_STATUS IS 'S'
DEFAULT for PER_ASG_JOB_NAME IS 'abc'
DEFAULT for PER_ASG_WORK_AT_HOME IS 'N'
/*=========== DATABASE ITEM DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/ l_output = 'N'
l_mar_status = PER_PER_MARITAL_STATUS
l_job_name = PER_ASG_JOB_NAME
l_wrk_home = PER_ASG_WORK_AT_HOME
if ( l_mar_status = 'M'
and ( l_job_name = 'Senior Manager' or l_job_name = 'Senior Consultant' )
and l_wrk_home = 'Y' )
then
( l_output = 'Y' )
return l_outputRelated Posts
How to Create Eligibility Profiles
Posted on
Create a Goal Plan
Posted on