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) |