Defining detail filter mapping

After you defined the detail filters, map the detail filters to each field in the Work Detail Field and Search Field that you want to search.

  1. From the homepage, select Maintenance > Payroll Settings > Advanced Payroll Settings > Timesheet Detail Filter Mapping.
  2. Click Create New Entry.
  3. In the The Timesheet Detail Filter Mapping - Details page, specify this information:
    Work Detail Field
    Specify the work detail field against which the system is to execute your search. For example, specify TCODE_ID to add a time code filter.
    Search Field
    Specify the field that you configured on the Timesheet Selection page. For example, specify TDF_FIELD1 if you are using the first timesheet detail filter.
  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.

When configuring the timesheet detail filter, ensure that the query is returning the corresponding data. For example, when mapping TCODE_ID, ensure that the query returns relevant data, such as: 
source='SELECT TCODE_ID, TCODE_NAME, TCODE_LOC_NAME FROM VL_TIME_CODE' sourceKeyField='TCODE_ID'

You can use the detail filter after you complete the detail filter configuration and mapping tasks. When a user includes detail data in their search, work details within the specified dates are shown.