1. How do I set up salary sacrifice for Ireland?
  2. Create a Value Set

Create a Value Set

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

Fastpath: Home > My Enterprise > Setup and Maintenance > Search > Tasks > Manage Value Sets
  1. Select Actions > Create and select the Table validation type to define a value set that filters values from an existing table using a SQL statement.
  2. Enter the required values as shown here:
    FieldValue
    Value Set Code RG_TRAVEL_PASS_CHOICES
    Module User defined module, for example, Ireland 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 = 'RG_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.