The ‘Additions & Deductions’ data set is available when creating a Custom Report.
For more guidance, follow the steps in our article on creating and managing custom reports.
The ‘Additions & Deductions’ data set reports on all additions and deductions that are applied to Employees.
Filtering ‘0’ yearly values
Lines with ‘0’ yearly value can be filtered from the report view by filtering on the ‘Value (Yearly)’ column as follows:
Create a custom report using the Additions & Deductions data set.
Use the horizontal scroll bar to find the ‘Value (Yearly)’ column in the Additions & Deductions section.
Hover over the column header and click the three lines icon that appears to open the column options pane.
Click the three lines icon and click the Filter icon (three lines with different lengths) in the middle of the top of the column options pane.
Select ‘Does not equal’ in the drop down list of filter operators.
Type ‘0’ (zero) in the filter value. The report will automatically filter the rows to only show rows with a yearly value that is not zero.
Click anywhere on the report to close the column options pane.
If you would like to create a report that runs with this filter applied by default, you can click ‘Edit’ under the Options menu and follow the steps above, then click Save to save the column filter settings.
For more information, take a look at our article on editing custom reports.
Additions & Deductions data
Below is a list of all the available ‘Additions & Deductions' data that can be added when creating a custom report.
Identifiers
Primary Employment Number |
Employment Number |
NI number |
Teacher Number |
Status |
Employee Details
First Name |
Last Name |
Preferred Forename |
Previous Surname |
Full Name |
Username |
Gender |
Date of Birth |
Age (Years) |
Address |
Employee Contract Details
Division |
Section |
Sub-section |
Position |
Cost Codes |
Contract Basis |
Contract Type |
Continuous Service Date |
Date of First Employment |
Post Start Date |
Post End Date |
Termination Date |
Length of Service |
FTE Hours |
Contract Hours |
FTE |
FTE Percentage |
Weeks Per Year |
Worked Fraction |
Total FT Fraction |
Contract Days |
Tax Details
Tax Code |
Tronc Number |
Tronc Rate |
Payroll Details
Ext Payroll Number |
Payroll Post Reference |
Pay Details
Payroll |
Payment Type |
Pay Type |
Negotiating Body |
Lower Grade (pertaining to post) |
Upper Grade (pertaining to post) |
Lower Payscale (name) |
Lower Payscale (value) |
Upper Payscale (name) |
Upper Payscale (value) |
Grade |
Payscale |
FTE Salary |
Actual Salary |
Daily Rate |
Hourly Rate |
Additions & Deductions
Type |
Source |
Start Date |
End Date |
Pay Element |
Pay Element Basis |
Units |
Grade |
Payscale Name |
Payscale Value |
Value (Yearly) |
Comment |