Create Value Sets to Use with Custom Time Attributes

Create unfiltered value sets for your administrators to use during setup tasks, such as creating time categories. To limit drop-down lists to only valid values for each worker, also create filtered value sets for workers to use when reporting time.

If your list of values is the same for both setup tasks and time entry, you can create just one value set.

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. Go to Setup and Maintenance > Workforce Deployment > Time and Labor > Time and Labor Value Sets.
2. Create the value set.
   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.