Payroll Period Compare Report (PRR021)

Updated on 18 Oct 2024
2 Minutes to read

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Report Description

The Payroll Period Compare Report is a report that provides information generated during the preliminary and final payroll run that compares the current payroll to the prior payroll period and identifies variances based on defined criteria.

Report Navigation: Main Menu > Florida PALM > Payroll > Reports > Payroll Period Compare Report

Click below to view the sample report layout.

User Roles

The following business roles have access to this report:

Batch Scheduler
BOSP Payroll Maintainer
BOSP Payroll Processor
BOSP Payroll Reporter
Agency Payroll Processor
Agency Payroll Reporter

Business Process Models

This report can be found in the following business processes:

100.3.2 Calculate Payroll

Selection Criteria

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

Data Field	Data Field Details
Current Pay Run ID	Required
Previous Pay Run ID	Required
Business Unit	Optional
Department ID	Optional

Report Layout

The layout of the report is listed below.

Data Field	Florida PALM RECORD.FIELD Mapping
Distinct Number of Employees in Payroll	PAY_CHECK.EMPLID - The number of employees that are being paid in the given Pay Run ID
Distinct Number of Active Employees	JOB.EMPL_STATUS - The number of employees with an Active status that are being paid in the given Pay Run ID
Total Number of Paychecks	PAY_CHECK - The number of records on the paycheck table that are being processed in the given Pay Run ID
Total Number of Warrants	PAY_CHECK.FORM_ID where FORM_ID = FLPCHK - The number of records on the paycheck table that are being processed as a paper warrant in the given Pay Run ID
Total Number of Pay Advices	PAY_CHECK.FORM_ID where FORM_ID = FLPADV - The number of records on the paycheck table that are being processed as a direct deposit in the given Pay Run ID
Total Earnings	The record counts to indicate the number of times the earning code was used and the corresponding total amount paid for the earnings code. Count: Number of records generated for earning code (ERNCD) on PAY_OTH_ERNS. Amount: Sum of earnings amount field (REG_EARNS) on the pay earnings table (PAY _EARNINGS) and earnings amount field (OTH_EARNS) on the pay other earnings table (PAY_OTH_ERNS) for each time the earning code is used.
Total Deductions	The record counts to indicate the number of times a deduction code was used and the corresponding total amount deducted for the deduction code. Count: Number of records generated for deduction code (DEDCD) on the pay deductions table (PAY_DEDUCTIONS). Amount: Sum of deduction amount (DED_CUR) taken across all time the deduction code was used on the pay deductions table (PAY_DEDUCTIONS).
Total Garnishments	The record counts to indicate the number of times a garnishment type was used and the corresponding total amount garnished for the garnishment type. Count: Number of records generated for garnishment type, given by the garnishment ID (GARNID) on the pay garnishment table (PAY_GARNISH). Amount: Sum garnishment amount field (DEDUCT_AMT) taken for all rows the garnishment type is used on the pay garnishment table (PAY_GARNISH).
Total Taxes	The record counts to indicate the number of times a tax class was used and the corresponding total amount withheld for the tax class. Count: Number of records generated for tax class (TAX_CLASS) on the pay tax table (PS_PAY_TAX). Amount: Sum of tax amount (TAX_CUR) taken for all rows with the tax class/state on the pay tax table (PS_PAY_TAX).
Total Net Pay	PAY_CHECK.NET_PAY - The total net pay in the given Pay Run ID
Total Gross Salary Charge	The total gross salary charge broken down by total gross pay and total employer cost in the given Pay Run ID Total Gross Pay: Sum of all rows of the total gross field (TOTAL_GROSS) on the paycheck table (PAY_CHECK) for all rows in the given Pay Run ID. Total Employer Cost: Sum of all deduction amounts (DED_CUR) for deductions that are employer costs (DED_CLASS = N) and sum of all tax amounts (TAX_CUR) for tax classes that are employer costs (TAX_CLASS=)

Version History

Date	Revision Description
10/18/2024	Original Version

Was this article helpful?

What's Next

Appropriations Budget vs. Project Budget (PCR015)

Table of contents

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