1. Implementing Compensation
  2. Formula Type Is Compensation Hierarchy Determination

Formula Type Is Compensation Hierarchy Determination

To build your own management or reviewer hierarchy for use in a workforce compensation plan, you can create formulas using the Compensation Hierarchy Determination formula type. You select the formula when you configure hierarchies for the workforce compensation plan.

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

  • DATE_EARNED

  • EFFECTIVE_DATE

  • HR_ASSIGNMENT_ID

  • END_DATE

  • START_DATE

  • 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_ASSIGNMENT_ID Number Y Assignment ID
CMP_IV_PLAN_ID Number Y Plan ID
CMP_IV_PERIOD_ID Number Y Period ID
CMP_IV_COMPONENT_ID Number Y Component ID
CMP_IV_PERSON_ID Number Y Worker ID
CMP_IV_PLAN_START_DATE Date Y Plan Start Date
CMP_IV_PLAN_END_DATE Date Y Plan End Date
CMP_IV_PLAN_EXTRACTION_DATE Date Y Plan Extraction 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

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

Return Value Data Type Required Description
L_PERSON_ID Number Y Person ID of manager
L_ASSIGNMENT_ID Number Y Assignment ID of manager

Or

Return Value Data Type Required Description
L_PERSON_NUMBER Number Y Person number of manager

The Start Workforce Compensation Cycle and Refresh Workforce Compensation Data processes show this error when they can’t find the assignment ID:

  • Formula passed in an invalid person number <15465857>. Assignment ID couldn't be obtained.

This sample formula determines the manager of a person when the assignment_id is passed.

/***********************************************************
FORMULA NAME : Compensation Hierarchy Determination Formula 
FORMULA TYPE : Compensation Hierarchy Determination 
DESCRIPTION: Hierarchy determination fast formula which is based on assignment_id
************************************************************/
/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/
INPUTS ARE CMP_IV_ASSIGNMENT_ID (number), CMP_IV_PLAN_ID (number), CMP_IV_PERIOD_ID (number)/*=========== INPUT VALUES DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
DEFAULT FOR CMP_IV_ASSIGNMENT_ID IS 0 
L_PERSON_ID = '0' L_ASSIGNMENT_ID = '0'
 if (CMP_IV_ASSIGNMENT_ID = 100000008154060 ) THEN 
(
L_PERSON_ID = to_char(-999) //-999 indicates top level 
//Manager.
L_ASSIGNMENT_ID = to_char(-999)
)
ELSE 
(
L_PERSON_ID = to_char(100000008153756)
L_ASSIGNMENT_ID = to_char(100000008154060)
) 

RETURN L_PERSON_ID , L_ASSIGNMENT_ID

/*================ FORMULA SECTION END =======================*/

Related Topics