Payroll Summary Report (PRR012)
  • 29 May 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

Payroll Summary Report (PRR012)

  • Dark
    Light
  • PDF

Article summary

Report Description

PRR012 Payroll Summary Report contains employee paycheck total information. This report provides summary payroll data for agencies during the Florida PALM payroll calculation and confirm process to help validate the payroll and identify any potential issues requiring further investigation.

This report will also help agencies and enterprise users perform data analysis, reconciliation, and support external reporting as needed.

Report Navigation: Main Menu > Florida PALM > Payroll > Payroll Processing > PRR012 Payroll Summary Report

Click below to view the sample report layout.

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.4 Confirm Payroll
  • 100.4.1 Off-Cycle Processing

Selection Criteria

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

Data Field

Data Field Details

Pay Run ID

Required

Business Unit

Optional

Company

Optional

Pay End Date

Optional

Pay Group

Optional

Pay Cycle

Required

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_DT

Pay Group

PAY_CALENDAR.PAY_GROUP

Off Cycle

PAY_CALENDAR.OFF_CYCLE

Page Number

PAY_CHECK.PAGE_NUM

Line Number

PAY_CHECK.LINE_NUM

Separate Check

PAY_CHECK.SEPCHK

OLO

PAY_CHECK.BUSINESS_UNIT

Organization

PAY_CHECK.DEPTID

Employee ID

PAY_CHECK.EMPLID

Last Name

NAMES.LAST_NAME

First Name

NAMES.FIRST_NAME

Middle Name

NAMES.MIDDLE_NAME

Employee Type

JOB.EMPL_TYPE

Position Number

JOB.POSITION_NBR

Pay Plan

JOB.JOBCODE (first two characters)

Class Code

JOB.JOBCODE (last three characters)

FTE

JOB.FTE

Retirement Code

RTRMNT_PLAN.BENEFIT_PLAN

Appointment Type

JOB.EMPL_CLASS

Federal Form Version

FED_TAX_DATA.FWT_FORM_VERSION

Special FWT Status

FED_TAX_DATA.SPECIAL_FWT_STATUS

Tax Martial Status

FED_TAX_DATA.FWT_MAR_STATUS

Multiple Jobs

FED_TAX_DATA.FWT_MULTI_JOBS

Withholding Allowances

FED_TAX_DATA.FWT_ALLOWANCES

Other Income

FED_TAX_DATA.FWT_OTH_INCOME

FWT Deductions

FED_TAX_DATA.FWT_DED_ADJ

Extra Withholdings

FED_TAX_DATA.FWT_ADDL_AMT

Pay Begin Date

PAY.CALENDAR.PAY_BEGIN_DT

Check Date

PAY_CHECK.CHECK_DT

Paycheck Number

PAY_CHECK.PAYCHECK_NBR

Begin Rate of Pay

JOB.COMPRATE

End Rate of Pay

JOB.COMPRATE (if there is a change in comp rate)

Contract Hours

PAY_OTH_EARNS.VC_PLAN_ID

Hours

Sum of PAY_OTH_EARNS.OTH_HRS

Total Gross

PAY_CHECK.TOTAL_GROSS

Tax Gross

PAY_TAX.TXGRS_CUR

Retirement Gross

PAY_SPCL_EARNS.SPCL_EARNS

Total Deductions

PAY_CHECK.TOTAL_DEDUCTIONS

Total Taxes

PAY_CHECK.TOTAL_TAXES

Net Pay

PAY_CHECK.NET_PAY

Version History

Date

Revision Description

03/12/2024

Original Version


Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.