Standard AQ - Employee Deduction & Contribution List

Overview

Updated 07/19/2021

Report Description

This report gives detailed deduction/contribution information and can be useful when checking employee payroll deductions.

Parameters

Parameter Name	Options	Description
Branch (Employee)	All available branches	Employee’s Branch
Date Type	Check Date, Date Entered, Start Date, None
Start Date
End Date
Deduction/Contribution Name	All, 401K, AdvanceBank, Boots, etc.	Lists out all transaction types with IsDeduction = 1 and IsBenefit = 1

Report Fields

Field Name	Description
Employee Branch	Employee’s Branch
Employee Status	Employee’s Status
Employee ID	Employee’s ID
Bold Talent ID	Employee’s ID in the front office (BOLD)
Social Security Number	The employee's social security number.
First Name	Employee’s First Name
Middle Name	Employee’s Middle Name
Last Name	Employee’s Last Name
Deduction/Contribution Type	Deduction or Contribution
Deduction/Contribution Name	Deduction Type or Benefit Type
Amount	Deduction amount or Benefit Amount
Is Fixed Amount	IsFixedAmount from EmployeeDeduction or EmployeeBenefit (if yes then check-box checked)
Is Levy	IsLevy from EmployeeDeduction or EmployeeBenefit  (if yes then check-box checked)
Is Per Hour	IsPerHour from EmployeeDeduction or EmployeeBenefit  (if yes then check-box checked)
Sequence	Sequence from EmployeeDeduction or EmployeeBenefit
Active	Active Status of EmployeeDeduction or EmployeeBenefit  (if yes then check-box checked)
Percent of Gross	Percent Gross from EmployeeDeduction or EmployeeBenefit  (if yes then check-box checked)
Percent of Net	Percent Net from EmployeeDeduction or EmployeeBenefit  (if yes then check-box checked)
Agency Name	Agency’s Name
Agency Address	Agency’s Address
Agency Reference Number	Agency’s Reference Number
Deduction DI Percent	DI Percent of Deduction or Benefit
Start Date	Date of Start of Deduction or Benefit
End Date	Date of End of Deduction or Benefit
Pay Period Limit	Pay Period Limit of Deduction or Benefit
Monthly Limit	Monthly Limit of Deduction or Benefit
Yearly Limit	Yearly Limit of Deduction or Benefit
Lifetime Limit	Lifetime Limit of Deduction or Benefit
Deduction Amount MTD	Month to Date Amount of Deduction or Benefit
Deduction Amount YTD	Year to Date Amount of Deduction or Benefit
Deduction Amount LTD	Life to Date Amount of Deduction or Benefit
Deduction Balance	Balance Amount of Deduction or Benefit
Note	Note from EmployeeDeduction or EmployeeBenefit
Frequency	Displays choice codes of what the frequency is. Example like – Biweekly, Hourly, Monthly, Weekly, etc.
Deduction/Contribution Supplier	Supplier from EmployeeDeduction or EmployeeBenefit
Flag During Payroll	FlagDuringPayroll from EmployeeDeduction or EmployeeBenefit (check-box)
Entered By	Username of the user who entered
Date Entered	Date Entered of EmployeeDeduction or EmployeeBenefit
Last Check Date	Last Check Date of Employee
Employee Last Assignment End Date	End Date of Employee’s Last Assignment
Deduction Max Percent of Net	EmployeeDIPercent from Employee

Back to Top