1. How do I set up payroll flows?
  2. Overview of Using Value Sets in Payroll Flows

Overview of Using Value Sets in Payroll Flows

A value set provides a dynamic list of values for an entry value. Use value sets to control and validate the data you use in payroll flow parameters.

Use the Payroll Value Sets task in the Setup and Maintenance area to create a value set and then use the value set as a parameter to run a payroll flow. The value set uses an SQL statement to filter values from an existing table, such as person name or number, location, legislative data group, or payroll statutory unit. Using value sets help maintain consistency and accuracy in your data.

Consider these points while creating value sets for payroll flows:
  • Use the Module field to specify the module for which you want to create the value set. For example, you can create a value set for payroll calculations, payroll checklists, payroll flows, and so on.
  • Use only the Table-Based type of value set for payroll flow parameters. Other value set types, such as Independent or Format Only, aren't supported.

  • Use Value Data Type of Character only. Value Data Type refers to the data type of the values that are filtered from the existing data tables and displayed on the payroll flow page.

  • While creating the value set definition, enter these details to build a query for the value set:
    • The From Clause defines the table name used for the query.
    • The Value Column Name is the attribute which is visible on the screen.
    • ID Column Name is the attribute used to store the value in the back end. The Column Type and Column Length pertain to the column in the database that stores the entered values.
  • Put the respective parameter name as bind value in the Where Clause when creating a value set for a flow parameter which is dependent upon another parameter value. For example, if the location parameter is dependent upon the payroll flow parameter while flow submission, bind the payroll flow ID value to the Where Clause as given here:
    Pf _flow_ id = {PARAMETER.LOCATION_IP}, where LOCATION_IP is the value name.

Value sets give you the flexibility to create your own list of values, without depending on other teams.