Configuration – Value set to get Grade Steps based on Worker Grade
Assignment DFF supports a number of parameters which can be used to get dynamic values based on Worker assignment.
List of supported parameters for a DFF can be found using below link:
In this example, we will create a value set to display list of Grade steps based on Worker’s assigned grade. Create a Table validated value set using below:
FROM Clause | PER_GRADE_STEPS_F_TL pgftl, PER_GRADE_STEPS_F pgsf,PER_GRADES_F pgf |
Value Attributes Table Alias | |
*Value Column Name | SUBSTR(pgftl.NAME,1,150) |
Value Column Type | VARCHAR2 |
Value Column Length | 150 |
Description Column Name | SUBSTR(pgftl.NAME,1,150) |
Description Column Type | VARCHAR2 |
Description Column Length | 150 |
ID Column Name | SUBSTR(pgftl.NAME,1,150) |
ID Column Type | VARCHAR2 |
ID Column Length | 150 |
Enabled Flag Column Name | |
Start Date Column Name | |
End Date Column Name | |
WHERE Clause | pgftl.GRADE_STEP_ID=pgsf.GRADE_STEP_ID AND pgftl.language=’US’ AND trunc(sysdate) between trunc(pgftl.effective_start_date) and trunc(pgftl.effective_end_date) AND pgsf.GRADE_ID=pgf.GRADE_ID AND trunc(sysdate) between trunc(pgsf.effective_start_date) and trunc(pgsf.effective_end_date) AND trunc(sysdate) between trunc(pgf.effective_start_date) and trunc(pgf.effective_end_date) AND pgf.grade_id = :{PARAMETER.GRADE_ID} |
ORDER BY Clause | SUBSTR(pgftl.NAME,1,150) |