Defining detail filter mapping

After the detail filters have been defined, map the detail filters to each field in the work detail table to be searched. Following the preciding example, map TDF_FIELD1 to the TCODE_ID field of the work detail table.

To create an entry for your new detail filter:

  1. Select Maintenance > Payroll Settings > Advanced Payroll Settings > Timesheet Detail Filter Mapping.
  2. Click Create New Entry.
    The Timesheet Detail Filter Mapping - Details page is displayed.
  3. Specify this information:
    Work Detail Field
    Specify the work detail field against which the system is to execute your search.
    Search Field
    Specify the field that you configured on the Timesheet Selection page.
  4. Click Save.

If you have defined a detail filter's lookup to point to a custom table, then map the filter field to the defined work detail UDF field in which you are storing the custom table's ID.

After you have completed the detail filter configuration and mapping tasks, the detail filter is ready for use. When detail data is included in a user’s search, the system searches for work details within the specified dates.