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 =======================*/