S40 - Filtered Adjustment Number (Payroll Report Generator variable)
From Catalyst
Syntax
S40{C/H, 1-14/16, C/Y, A/-T/+T/-N/+N, A/Z}
Description
This variable can be used to filter out adjustments that are not in use, for passing to other variables relating to adjustments, such as E23 Adjustment Amount (current) and H11 Adjustment Amount (historic). Those variables already have parameters for doing similar filtering, but using S40 offers more flexibility, and future adjustment-related variables can now be simpler, leaving the filtering to S40.
 | E23{$S40{C,1,C,+T,Z},Y} - uses S40 to determine the first used post-tax adjustment based on this period, but then retrieves the year-to-date total for that adjustment. Note the use of the dollar sign ($) to insert a variable into the parameters of another.
H11{$S40{H,1,C,+T,Z},Y} - similar to above, except using the employee's historic values. H11{$S40{H,5,C,+T,Z |
- a simpler one; retrieves the amount for the fifth used historical post-tax adjustment, and is exactly equivalent to H11{5,H,+T,Z}.
}}
Parameters
- C/H
- A text parameter that can be omitted (it defaults to "C").
- C
- Current (the value currently in effect).
- H
- Historic (the value as at the time of the historic transaction). This will only be applicable if you have based a report on the 'H' variables.
- 1-14/16
- A numeric parameter that can be omitted (it defaults to "1").
- 1-14
- The adjustment number to retrieve.
- 16
- The Holiday Credit adjustment.
- C/Y
- A text parameter that can be omitted (it defaults to "C").
- C
- Current (the value for this period).
- Y
- Year (the value for the payroll year including this period).
- A/-T/+T/-N/+N
- A text parameter that can be omitted (it defaults to "A").
- A
- All adjustments.
- -T
- Pre-Tax adjustments only.
- +T
- Post-Tax adjustments only.
- -N
- Pre-NI adjustments only.
- +N
- Post-NI adjustments only.
- A/Z
- A text parameter that can be omitted (it defaults to "A").
- A
- All adjustments, regardless of the value.
- Z
- Only get adjustments with values. (Zero filter).
Returns
A numeric value whose typical size is 2 digits.
