Payroll Deduction Report (PRR016)
-
Print
-
DarkLight
-
PDF
Payroll Deduction Report (PRR016)
-
Print
-
DarkLight
-
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
- Deduction Amount
- Deduction Not Taken
- Reason Not Taken
- Year To-Date (YTD) balances
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.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business processes:
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 End Date | PAY_CALENDAR.PAY_END_DATE Run Control Page Value |
Pay Run ID | PAY_CALENDAR.RUN_ID Run Control Value |
Pay Group | PAY_CALENDAR.PAYGROUP |
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 YTD | DEDUCTION_BAL.DED_YTD |
Version History
Date | Revision Description |
|---|---|
03/12/2024 | Original Version |
| 02/04/2025 | Updated per Version History: |
Was this article helpful?
