1. Implementing Compensation
  2. Formula Type Is Compensation Default and Override

Formula Type Is Compensation Default and Override

To determine the default values for a worksheet column in a workforce compensation plan, you can create formulas using the Compensation Default and Override 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 Unique numeric identifier for the workforce compensation plan
CMP_IV_PERIOD_ID Number Y Unique numeric identifier for the fiscal calendar period
CMP_IV_COMPONENT_ID Number Y Unique numeric identifier for the workforce compensation plan component
CMP_IV_ITEM_NAME Char Y Name for the workforce compensation plan item
CMP_IV_PERSON_ID Number Y Unique numeric identifier for the individual associated with the workforce compensation plan
CMP_IV_PLAN_START_DATE Date Y Date when the workforce compensation plan becomes active
CMP_IV_PLAN_END_DATE Date Y Date when the workforce compensation plan becomes inactive
CMP_IV_PLAN_ELIG_DATE Date Y Date when the workforce compensation plan becomes eligible
CMP_IV_PERFORMANCE_EFF_DATE Date Y Date to use for compensation performance ratings
CMP_IV_PROMOTION_EFF_DATE Date Y Date on which job, grade, and position changes take effect
CMP_IV_XCHG_RATE_DATE Date Y Date when the Start Workforce Compensation Cycle and Refresh Workforce Compensation Data processes obtain conversion rates from the general ledger daily rates table.
CMP_IV_ASSIGNMENT_ID Number Y Date to use for assignments

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

Return Value Data Type Required Description
L_DEFAULT_VALUE Number/Char/Date Y Default value from the formula. The date should be in yyyy/mm/dd format
L_DATA_TYPE Char Y Data type of the column

This sample formula determines the value of a column based on its item name.

/***********************************************************
FORMULA NAME : Compensation Default and Override Formula
FORMULA TYPE : Compensation Default and Override
DESCRIPTION  : Defaults the value of a column based on its item_name
*************************************************************/ 
/*=========== INPUT VALUES DEFAULTS BEGIN =====================*/
INPUTS ARE CMP_IV_PLAN_ID (number), CMP_IV_PERIOD_ID (number), CMP_IV_COMPONENT_ID (number), CMP_IV_ITEM_NAME (text)
/*=========== INPUT VALUES DEFAULTS ENDS======================*/
/*================ FORMULA SECTION BEGIN =======================*/

DEFAULT FOR CMP_IV_ITEM_NAME IS 'YYYYYYY' 
L_DEFAULT_VALUE = to_char(0) 
IF (CMP_IV_ITEM_NAME = 'AmountComp1') THEN 
(
L_DEFAULT_VALUE = to_char(3333)
)
ELSE IF (CMP_IV_ITEM_NAME = 'AmountComp2') THEN 
(
L_DEFAULT_VALUE = to_char(7777)
)
ELSE
(
L_DEFAULT_VALUE = to_char(-999)
)
RETURN L_DEFAULT_VALUE

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

Related Topics