Create a Value Set

You need to create a value set to reference the user-defined table.

Navigation: Home > My Enterprise > Setup and Maintenance > Search > Tasks > Manage Value Sets

1. Select Actions > Create.
2. Select the Table validation type to define a value set that filters values from an existing table using a SQL statement.
3. Enter the required values as shown here:

   Field	Value
   Value Set Code	XX_TRAVEL_PASS_CHOICES
   Module	User defined module, for example, Global Payroll
   Validation Type	Table
   Value Data Type	Character
   FROM Clause	ff_user_rows_vl
   Value Column Name	row_name
   ID Column Name	row_name
   WHERE Clause	user_table_id = (select user_table_id from ff_user_tables_tl where user_table_name = 'XX_TRAVEL_PASS_CHOICES' and language = 'US')and trunc(sysdate)between effective_start_Date and effective_end_date

   Note: To enable the Value Set field on the Manage Elements page, select Character as the Unit of Measure for the input value.