Using Compensation Default and Override Fast Formula to access Value Set information
Summary:
We are using a value set to fetch grade id of employees at different stages of a cycle (employees having several work relationships).
Content (required):
Query:
select paaf.grade_id
from per_all_assignments_f paaf
where 1=1
AND paaf.effective_latest_change = 'Y'
AND paaf.assignment_type IN ('E','C')
AND paaf.ASSIGNMENT_STATUS_TYPE = 'ACTIVE'
AND to_date(TO_CHAR(SYSDATE,'YYYY') || '0630' , 'YYYYMMDD') BETWEEN paaf.EFFECTIVE_START_DATE AND paaf.EFFECTIVE_END_DATE
and paaf.person_id=:{PARAMETER.PERSON_ID}
Now in Compensation module, we are using a Compensation Default and Override formula to pick up the grade id from this value set.
0