Create Value Sets for Time and Labor

You create unfiltered value sets for your administrators to use during setup tasks, such as creating time categories or rules. And you can create separate, filtered value sets for individuals to use when they report time.

Use the Time and Labor Value Sets task in the Setup and Maintenance work area. It's part of the Workforce Deployment offering, Time and Labor functional area.

Caution: You'll get errors if you update an existing value set for a custom time attribute used on time card layouts. You need to create a new value set, new custom time attribute, and new layout component instead. Then, replace the existing layout component with the new component in the appropriate layouts.

1. On the Time and Labor Value Sets page, click the Create icon.
2. On the Create Value Set page, complete these steps:
   1. In the Module field, select Time and Labor Web Entry Configurations.
   2. Select one of these validation types: Format Only, Independent, or Table. Typically, you want to use a table-validated set as the filtered data source for a time card field.
   3. Select the appropriate data type for the values in the set.
   4. For a table-validated value set, use the SQL WHERE clause to add filter variables that limit the valid values to a subset of values. When you create time card fields, you map these filter variables to time attributes that limit drop-down lists to valid values for each individual.
   5. Save and close your configuration. The task maintains the values that you want to use in an application table.
3. Add values. How you add them to the value set depends on the validation type.
   • Independent validation: On the Create Value Sets page, click Manage Values to add values.
   • Table-validated: You don't have to define or maintain values because the reference view or table manages them.