Payroll Deduction Report (PRR016)

Updated on 29 May 2024
1 Minute to read

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Report Description

The PRR016 Payroll Deduction Report identifies deductions taken during payroll calculation and after payroll confirmation. This report can be run for one agency or all agencies. This report has the following fields:

Pay End Date
Pay Group
Business Unit/Agency
Employee ID
Name
Amount Taken
Amount Not Taken
Reason Not Taken
Month To-Date (MTD) Balances
Quarter To-Date (QTD) Balances
Year To-Date (YTD) balances
Goal Amount

This report will provide deduction details by employee and will be pulled from precalculated deduction data and/or post confirmed deduction data. Users have the option to run this report by Pay Run ID, Business Unit, Deduction Code or Period End Date, Paygroup, Deduction Code and Department. This report is used to help agencies and enterprise users perform data analysis, reconciliation, and support external reporting as needed.

Report Navigation: Main Menu > Reporting Tools > Query > Query Viewer

Query Name: Payroll

Click below to view the sample report layout.

PRR016 - Payroll Deduction Report_Payroll(1).xlsx

Business Roles

The following business roles have access to this report:

Agency Payroll Processor
BOSP Payroll Processor
BOSP Payroll Maintainer

Business Process Models

This report can be found in the following business processes:

100.3.2 Calculate Payroll
100.3.3 Updating Paysheets
100.3.4 Confirm Payroll

Selection Criteria

The report data can be filtered by the following selection criteria:

Data Field	Data Field Details
Pay Run ID	Pay Run ID is optional and will default to ‘Blank.’ If a user tries to insert a Pay Run ID, a lookup will be referenced to only pull those Pay Run IDs created by BOSP.
Business Unit	User can select a specific BU (Business Unit). If a Business Unit is selected that an agency does not have access to. The Report will be blank.
Deduction Code	A lookup field into the deduction code table. Should be optional and default ‘%’ for all deduction codes.
Pay End Date	Defaulted to Blank. Users can select specific Period.
Pay Group	Default to ‘%’ Wildcard. Users can select specific values.
Department (Begin)	Defaulted to Blank. User can select specific or range of Department/ Organization values
Department (End)	Defaulted to Blank. Users can select specific or range of Department/Organization values.

Report Layout

The layout of the report is listed below.

Data Field	Florida PALM RECORD.FIELD Mapping
Company	PAY_CALENDAR.COMPANY
Pay Period End	PAY_CALENDAR.PAY_END_DATE Run Control Page Value
Pay Run ID	PAY_CALENDAR.RUN_ID Run control Value
Pay Group	PAY_CALENDAR.PAYGROUP Run Control Page Value
Plan Type	PAY_DEDUCTION.PLAN_TYPE Run Control Page Value
Check Date	PAY_CALENDAR.CHECK_DT
Business Unit	PAY_CHECK.BUSINESS_UNIT
Dept ID	PAY_CHECK.DEPTID Run Control Page Value
Employee ID	PAY_CHECK.EMPLID
Empl Record	PAY_CHECK.EMPL_RCD
First Name	NAMES.FIRST_NAME
Last Name	NAMES.LAST_NAME
Check Nbr	PAY_CHECK.PAYCHECK_NBR
Benefit Plan	PAY_DEDUCTION.BENEFIT_PLAN
DEDCD	PAY_DEDUCTION.DEDCD
DED Class	PAY_DEDUCTION.DED_CLASS
Deduction Amount	PAY_DEDUCTION.DED_CUR
Deduction Refund	PAY_DEDUCTION.DED_CUR_REFUND
Deduction Not Taken	PAY_DEDUCTION.DED_NOT_TAKEN
Reason Not Taken	PAY_DEDUCTION.REASON_NOT_TAKEN
Ded MTD	DEDUCTION_BAL.DED_MTD
Ded QTD	DEDUCTION_BAL.DED_QTD
DED YTD	DEDUCTION_BAL.DED_YTD

Version History

Date	Revision Description
03/12/2024	Original Version

Was this article helpful?

What's Next

Payroll Error Messages - Query (PRR061)

Table of contents

Report Description
Business Roles
Business Process Models
Selection Criteria
Report Layout
Version History