Use a Value Set for an Element Input Value
You can use value sets to provide a dynamic list of values for an element input value. Use a value set for lists containing values that already exist in tables.
For example, person name or number, legislative data group, or payroll statutoryunit. The benefit of this approach is that you don't have to create and maintain a lookup type. Using value sets helpsmaintain consistency and accuracy in your data.
The only type of value set supported for element input values is the table-based value set. Oracle Fusion Global Payroll doesn't support other value set types, such as Independent or Format Only.
Use the Manage Value Sets task in the Setup and Maintenance work area.
Create value sets using the Manage Value Sets task. You select the Table validation type to define a value set that filters values from an existing table using a SQL statement.
This table provides the required values that you enter when you create a value set for use on the Manage Elements page.
Field |
Value |
---|---|
Module |
Global Payroll |
Validation Type |
Table |
Value Data Type |
Character |
To enable the Value Set field on the Manage Elements page you must select Character as the Unit of Measure for the input value.
To improve the performance of your value set queries, use these contexts to filter the value set records:
-
PayrollRelationshipId
-
PersonId
-
PayrollTermId
-
PayrollAssignmentId
-
LegDataGroupId
-
LegCode
-
SysEffectiveDate
WHERE Clause example: pay_pay_relationships_dn.payroll_relationship_id
= :{PARAMETER.PayrollRelationshipId}
If you use these contexts in your value set SQL, make sure the WHERE clause parameter name matches the context name.
In this example, an element contains input values for legislative data group and element name. The list of values for element name is dependent on the selected legislative data group. As part of setup, you can select a default legislative data group for the element, or for a specific element eligibility record.
In summary, here are the steps:
-
Create a value set to return a list of all legislative data groups
-
Create a value set that returns all elements in the legislative data group
-
Add the value set codes to the Manage Elements page
Create a Value Set to Return a List of all Legislative Data Groups
-
From the Setup and Maintenance work area, search for and select the Manage Value Sets task.
-
Click Create.
-
Complete the fields, as shown in this table.
Field
Value
Value Set Code
LDG_VS
Description
Retrieve Legislative Data Groups
Module
Global Payroll
Validation Type
Table
Value Data Type
Character
FROM Clause
PER_LEGISLATIVE_DATA_GROUPS_vl
Value Column Name
NAME
ID Column Name
LEGISLATIVE_DATA_GROUP_ID
WHERE Clause
business_group_id=202
Tip:To avoid failure of the value set, use IDs instead of names in case the display name changes in the future.
ORDER BY Clause
NAME
-
Click Save.
Create a Value Set that Returns all Elements in the Legislative Data Group
-
On the Manage Value Sets page, click Create.
-
Complete the fields, as shown in this table.
Field
Value
Value Set Code
ELE_VS
Description
Elements
Module
Global Payroll
Validation Type
Table
Value Data Type
Character
FROM Clause
pay_element_types_f
Value Column Name
base_element_name
ID Column Name
element_type_id
WHERE Clause
LEGISLATIVE_DATA_GROUP_id=:{PARAMETER.LDG_IP}
Note:LDG_IP is the input value name.
ORDER BY Clause
base_element_name
-
Click Save.
Add the Value Set Codes to the Elements Page
-
On the Home page, click the Elements quick action under the My Clients Groups tab.
-
Create a new element to meet your requirements and then click Submit.
-
When the Element Summary page displays, click the Input Values folder.
-
Click Actions and then select Create Input Values.
-
Enter the name LDG_IP and the display sequence for the input value.
-
Select Character as the Unit of Measure.
-
Enter LDG_VS in the Value Set field.
-
Go to the Default field and select a legislative data group.
-
Click Save.
-
Click Submit.
-
Repeat these steps to create an element input value using the ELE_VS value set.
You can override the default values on the Element Eligibility - Input Values page for a specific eligibility record.