Create Value Sets for Custom Time Attributes

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

If your list values are 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. Instead, create another value set, custom time attribute, and layout component. 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 for the Time and Labor Web Entry Configurations module.
   1. 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.
   2. Select the appropriate data type for the values in the set.
   3. 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.
   4. Save and close your configuration. The task maintains the values that you want to use in an application table.
3. Add values according to 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.