1. Administering Payroll Flows
  2. Introduction

Introduction

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

Use the Payroll Value Sets task in the Setup and Maintenance area to create a value set. Once you create a value set, it uses a SQL statement to filter values from an existing table, such as person name or number, location, legislative data group, or payroll statutory unit. You can then use the value set as a parameter to run a payroll flow. You don't have to create and maintain a lookup type. 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 and displayed on the payroll flow page.

  • Enter these details while creating the value set definition, 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 below:

    • 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.