Formula Type Is Compensation Default Access Level
To determine the access level for the selected workforce compensation plan hierarchy, you can create formulas using the Compensation Default Access Level formula type. You select formulas of this type on the Configure Hierarchies page.
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_EXTRACTION_DATE | Date | Y | Plan Extraction Date |
CMP_IV_HIERARCHY_TYPE | Char | Y | Hierarchy Type |
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 |
---|---|---|---|
UPDATABLE | Char | Y | Updatable |
READONLY | Char | Y | Read-only |
NOACCESS | Char | Y | No Access |
This sample formula determines if a person is selected for a workforce compensation plan based on their assignment_id.
/*******************************************************************
FORMULA NAME : Compensation Default Access Level
FORMULA TYPE : Compensation Default Access Level
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 =======================*/
l_hr_assign_id = get_context(HR_ASSIGNMENT_ID, -1)
L_DEFAULT_VALUE='UPDATABLE'
IF l_hr_assign_id = 100000016858755
THEN
(
L_DEFAULT_VALUE = 'UPDATABLE'
)
ELSE IF l_hr_assign_id = 100000016873381
THEN
(
L_DEFAULT_VALUE = 'NOACCESS'
)
ELSE IF l_hr_assign_id = 300100009424371
THEN
(
L_DEFAULT_VALUE = 'READONLY'
)
ELSE
(
L_DEFAULT_VALUE = 'READONLY'
)
RET=ESS_LOG_WRITE('L_DEFAULT_VALUE: '|| L_DEFAULT_VALUE)
return L_DEFAULT_VALUE
/*================ FORMULA SECTION END =======================*/