1. Implementing Compensation
  2. Formula Type Is Compensation Default Access Level

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

Related Topics