Filters

Four levels of filters exist: payee, process, segment, and input.

• Payee Filter

  This SQL parameter is used to filter the population. It is applied when the selection is based on a specific record or employment table.

• Process Filter

  This SQL parameter is used to filter the entire process in the original segments only. It can be based on any field in the payee process status or payee segment status tables. For example, "and COUNTRY = 'USA'" selects only U.S. absence results.

• Segment Filter

  This field parameter is used to create a filter for every step of the process in every segment. It can be based on any field in the payee process status, the payee segment status, or the segment writable array table (if defined in the setup). For example, COMPANY 'GBI' makes a selection on the company GBI if COMPANY is stored in a segment writable array.

• Input Filter

  This SQL filter is defined in the setup for each step used to filter the primary input table, the additional input table joined with the primary input table (the link table), or the worktable. Input filters can be used as a filter or as an additional join condition. For example, "and PRI.CALC_RSLT_VAL>0" selects only the positive results.