1. Administering Fast Formulas
  2. Formula Type Is Compensation Person Selection

Formula Type Is Compensation Person Selection

To determine the person selected for an associated workforce compensation plan, you can create formulas using the Compensation Person Selection formula type. You select the formula when you run these batch processes:

  • Start Workforce Compensation Cycle
  • Refresh Workforce Compensation Data
  • Transfer Workforce Compensation Data to HR

Here's a comprehensive list of the contexts available to this type of formula:

  • DATE_EARNED
  • EFFECTIVE_DATE
  • END_DATE
  • START_DATE
  • HR_ASSIGNMENT_ID
  • HR_TERM_ID
  • JOB_ID
  • LEGISLATIVE_DATA_GROUP_ID
  • COMPENSATION_RECORD_TYPE
  • ORGANIZATION_ID
  • PAYROLL_ASSIGNMENT_ID
  • PAYROLL_RELATIONSHIP_ID
  • PAYROLL_TERM_ID
  • PERSON_ID

The database items available for this type of formula are related to Person, Assignment, Salary, Element Entries, Compensation Record, and From and End Dates.

These are the input variables available to this type of formula:

Input Value Data Type Required Description
CMP_IV_PLAN_ID Number Y Plan ID
CMP_IV_PERIOD_ID Number Y Period ID
CMP_IV_PLAN_START_DATE Date Y Plan Start Date
CMP_IV_PLAN_END_DATE Date Y Plan End Date
CMP_IV_PLAN_ELIG_DATE Date Y Plan Eligibility Date
CMP_IV_PERFORMANCE_EFF_DATE Date Y Performance Effective Date
CMP_IV_PROMOTION_EFF_DATE Date Y Promotion Effective Date
CMP_IV_XCHG_RATE_DATE Date Y Currency Conversion Date
CMP_IV_ASSIGNMENT_ID Number Y Assignment ID
CMP_IV_PERSON_ID Number Y Worker ID

These are the return variables available to this type of formula:

Return Value Data Type Required Description
L_SELECTED Char N Y or N

This sample formula determines if a person is selected for a workforce compensation plan based on their assignment_id.

/******************************************************************
FORMULA NAME : Compensation Selection Formula 
FORMULA TYPE : Compensation Person Selection 
DESCRIPTION: Assignment_id based selection fast formula
*******************************************************************/
/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/
INPUTS ARE CMP_IV_ASSIGNMENT_ID (number), CMP_IV_PLAN_ID (number)
/*=========== INPUT VALUES DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
DEFAULT FOR CMP_IV_ASSIGNMENT_ID IS 0 
l_selected = 'Y'
/* 100000008154095 - Ariel.Aimar@oracle.com - GBI data*/
if (CMP_IV_ASSIGNMENT_ID = 100000008154095) THEN 
(
l_selected = 'N'
) 
else 
(
l_selected = 'Y'
) 
RETURN l_selected
/*================ FORMULA SECTION END =======================*/

Related Topics