1. Implementing Compensation
  2. Formula Type Is Compensation Currency Selection

Formula Type Is Compensation Currency Selection

To determine the local currency for a workforce compensation component, you can create formulas using the Compensation Currency Selection formula type.

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_ASSIGNMENT_ID Number Y Assignment ID
CMP_IV_PERIOD_ID Number Y Period ID
CMP_IV_COMPONENT_ID Number Y Component 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
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_CURR_CODE Char N Currency code from the formula

This sample formula determines the currency for a plan based on the component ID.

/*****************************************************************
FORMULA NAME : Compensation Currency Selection Formula 
FORMULA TYPE : Compensation Currency Selection 
DESCRIPTION: It returns the currency code based on component_id.
******************************************************************/
/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/
INPUTS ARE CMP_IV_ASSIGNMENT_ID (number), CMP_IV_PLAN_ID (number), CMP_IV_PERIOD_ID (number), CMP_IV_COMPONENT_ID (number)
/*=========== INPUT VALUES DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/
DEFAULT FOR CMP_IV_COMPONENT_ID IS 0
l_curr_code = 'XXX' 
IF (CMP_IV_COMPONENT_ID = 489) THEN 
(
l_curr_code = 'USD'
) 
ELSE IF (CMP_IV_COMPONENT_ID = 490THEN 
(
l_curr_code = 'GBP'
) 
RETURN l_curr_code  
/*================ FORMULA SECTION END =======================*/

Related Topics