-
Print
-
DarkLight
-
PDF
Payroll Summary Report (PRR012)
-
Print
-
DarkLight
-
PDF
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:
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 | 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 |
08/21/2024 | Removed 100.4.1 BPM |