Configure Flexfield Parameters in Value Sets for Worker Assignments

You want to use assignment or work relationship attributes as input parameters when creating a value set for a flexfield segment.

Using parameters, you have the flexibility to control the list of values in the assignment descriptive flexfields (DFF) based on the assignment or work relationship attributes. Consider the following use case:

The Vision India company wants to capture the job and the job specialty at the worker's assignment and filter the job specialty value based on the selected job. To achieve this, the company does these things:

Defines the job specialty using the job extensible flexfield (EFF) and provides a one-to-many relationship between the job and the job specialty.
Allows the user to select from the list of job specialties at the worker's assignment. The job specialties are defined using the job EFF for the selected assignment job.

Summary of Tasks

Set up the job EFF.
Set up the assignment DFF.

Set up Job EFF

Define a multi-row EFF at the job level using these values:
- Name: Job Specialty
- Type: Multi-Row EFF
- Data Type: Character
- Table Column: JEI_INFORMATION1 (You can use any available column)
After you define the EFF, populate it with the value you want for different jobs.

Set Up Assignment DFF

Create the value set to be used in the assignment DFF by using the job as the parameter.
1. Go to the task Manage Value Set.
2. In the Create Value Set page, enter these values:
  - Value Set Code: Job Speciality
  - Module: Search and select Employment
  - Validation Type: Table
  - Value Data Type: Character
3. In the FROM Clause field, enter the following syntax:
```
PER_JOB_EXTRA_INFO_F
```
4. In the Value Column Name field, enter JEI_INFORMATION1 (or the column which is defined while creating the job EFF).
5. In the WHERE Clause field, enter the following syntax:
```
Job_ID = :{PARAMETER.JOB_ID}
AND JEI_INFORMATION_CATEGORY = 'Job Speciality'
and INFORMATION_TYPE = 'EIT'
```
Create the assignment DFF by using the value set defined in the previous step.
1. In the Setup and Maintenance work area, go to the following:
  - Functional Area: Workforce Information
  - Task: Manage Employment Descriptive Flexfields
2. On the Manage Employment Descriptive Flexfields page, select the PER_ASG_DF row and click Edit on the Actions menu.
3. Select the Assignment Attributes row and click Edit on the Actions menu.
4. Click the Create (+) icon in the Global Segments area and create a segment by entering these values:
  - Name: Job Speciality
  - Data Type: Character
5. Use the value set defined in the previous step.
6. Deploy the flexfield.
In the assignment section of the employment flows, verify that the values in the newly defined flexfield are filtered based on the selected job and job specialty values defined in the job setup.