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