Actuals Funding Report (PRR030)

Print
Share
Dark

Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

Report Description

The Actuals Funding Report is a custom Florida PALM report that will run by agency payroll users and BOSP to view actuals funding after Payroll Calculation. The report will read from the earnings, deduction, and tax distribution tables and combine results from all three into one spreadsheet for easier review. Some fields will be specific to the type of distribution.

Report Navigation: Main Menu > Payroll for North America > Payroll Distribution > Commitment Accounting USA > Actuals Funding Report

Click below to view the sample report layout.

PRR030_Actuals_Funding_Sample_Report_Layout.xlsx

Business Roles

The following business roles have access to this report:

Business Process Models

This report can be found in the following business processes:

100.7.2 Generate Payroll Accounting Distributions

Selection Criteria

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

Data Field	Data Field Details
Pay Run ID	Required
Pay End Date	Required
Pay Group	Required
Business Unit	Optional
Department	Optional
Emplid	Optional

Report Layout

The layout of the report is listed below.

Data Field	Florida PALM RECORD.FIELD Mapping
Pay End Date	PAY_CHECK.PAY_END_DT
Pay Group	PAY_CHECK.PAY_GROUP
Business Unit	PAY_CHECK.BUSINESS_UNIT
Department	PAY_CHECK.DEPTID
Emplid	PAY_CHECK.EMPLID
Empl Rcd	PAY_CHECK.EMPL_RCD
Position Nbr	JOB.POSITION_NBR
Warrant Number	PAY_CHECK.PAYCHECK_NBR
Warrant Date	PAY_CHECK.CHECK_DT
Net Pay	PAY_CHECK.NET_PAY
Distribution Type	N/A
Fiscal Year	PAY_ERN_DIST.FISCAL_YEAR PAY_DED_DIST.FISCAL_YEAR PAY_TAX_DIST.FISCAL_YEAR
Accounting Period	PAY_ERN_DIST.ACCOUNTING_PERIOD PAY_DED_DIST.ACCOUNTING_PERIOD PAY_TAX_DIST. ACCOUNTING_PERIOD
Earnings End Date	PAY_ERN_DIST.EARNS_END_DT PAY_DED_DIST.EARNS_END_DT PAY_TAX_DIST.EARNS_END_DT
Monetary Amount	PAY_ERN_DIST.EARNINGS PAY_DED_DIST.DED_CUR PAY_TAX_DIST.TAX_CUR
SpeedKey	PAY_ERN_DIST.ACCT_CD PAY_DED_DIST.ACCT_CD PAY_TAX_DIST.ACCT_CD
GL Business Unit	ACCT_CD_TBL.BUSINESS_UNIT_PC
Organization	ACCT_CD_TBL.DEPTID_CF
Account	ACCT_CD_TBL.ACCOUNT
Fund	ACCT_CD_TBL.FUND_CODE
Budget Entity	ACCT_CD_TBL.BUDGET_REF
Category	ACCT_CD_TBL.PRODUCT
State Program	ACCT_CD_TBL.CHARTFIELD2
Grant	ACCT_CD_TBL.PROGRAM
Contract	ACCT_CD_TBL.CHARTFIELD1
OA1	ACCT_CD_TBL.CLASS_FLD
OA2	ACCT_CD_TBL.CHARTFIELD3
Project	ACCT_CD_TBL.PROJECT_ID
Activity	ACCT_CD_TBL.ACTIVITY_ID
PC Source Type	ACCT_CD_TBL.RESOURCE_TYPE
PC Source Category	ACCT_CD_TBL.RESOURCE_CATEGORY
PC Subcategory	ACCT_CT_TBL.RESOURCE_SUB_CAT
Earnings Code	PAY_ERN_DIST.ERN_CD
Earnings Descr	EARNINGS_TBL.DESCR
Plan Type	PAY_DED_DIST.PLAN_TYPE
Benefit Plan	PAY_DED_DIST.BENEFIT_PLAN
Plan Descr	BENEF_PLAN_TBL.DESCR
Deduction Code	PAY_DED_DIST.DED_CD
Deduction Descr	DEDUCTION_TBL.DESCR
Deduction Class	PAY_DED_DIST.DED_CLASS
State	PAY_TAX_DIST.STATE
Locality	LOCAL_TAX_TBL.LOCALITY_NAME
Tax Class	PAY_TAX_DIST.TAX_CLASS

Version History

Date	Revision Description
5/21/2024	Original Version

Was this article helpful?

What's Next

Deductions Register (PRR062)

Table of contents

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