HR Accounting Line Report (PRR001)
  • Dark
    Light
  • PDF

HR Accounting Line Report (PRR001)

  • Dark
    Light
  • PDF

Article summary

Report Description

After a Payroll is confirmed in Florida PALM, the Actuals Distribution process will distribute earnings, employer deductions, and employer taxes across established position funding sources. Then the GL Interface Process (PAYGL02) will load this information to the HR Accounting Line and post it to the GL.

Agency users and BOSP will be able to use PRR001 HR Accounting Line Report to view Payroll payment data from the GL HR Accounting Line in FIN. This report will include employee data, warrant number, and distribution information. It can be run as a query or output as an Excel file and filtered as necessary.

Report Navigation: Main Menu > Reporting Tools > Query Viewer > HR Accounting Line 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

From Acctg Date

Required

To Acctg Date

Required

Business Unit

Optional

Department ID

Optional

Position Nbr

Optional

Emplid

Optional

Fund

Optional

Category

Optional

Budget Entity

Optional

Report Layout

The layout of the report is listed below. 

Data Field

Florida PALM RECORD.FIELD Mapping

Business Unit

JOB.BUSINESS_UNIT

Department ID

JOB.DEPTID

Emplid

HR_ACCTG_LINE.EMPLID

Empl Rcd

HR_ACCTG_LINE.EMPL_RCD

First Name

PERSONAL_DATA.FIRST_NAME

Middle Name

PERSONAL_DATA.MIDDLE_NAME

Last Name

PERSONAL_DATA.LAST_NAME

Position Nbr

HR_ACCTG_LINE.POSITION_NBR

Warrant Number

HR_ACCTG_LINE.JRNL_LN_REF

Warrant Date

HR_ACCTG_LINE.JOURNAL_LINE_DATE

Run Date

HR_ACCTG_LINE.RUN_DT

Accounting Date

HR_ACCTG_LINE.ACCOUNTING_DT

Budget Date

HR_ACCTG_LINE.BUDGET_DT

Monetary Amount

HR_ACCTG_LINE.MONETARY_AMOUNT

Journal ID

HR_ACCTG_LINE.JOURNAL_ID

Journal Date

HR_ACCTG_LINE.JOURNAL_DATE

Journal Line

HR_ACCTG_LINE.JOURNAL_LINE

Line Descr

HR_ACCTG_LINE.LINE_DESCR

GL Business Unit

HR_ACCTG_LINE.BUSINESS_UNIT_PC

Organization

HR_ACCTG_LINE.DEPTID_CF

Account

HR_ACCTG_LINE.ACCOUNT

Fund

HR_ACCTG_LINE.FUND_CODE

Budget Entity

HR_ACCTG_LINE.BUDGET_REF

Category

HR_ACCTG_LINE.PRODUCT

State Program

HR_ACCTG_LINE.CHARTFIELD2

Grant

HR_ACCTG_LINE.PROGRAM

Contract

HR_ACCTG_LINE.CHARTFIELD1

OA1

HR_ACCTG_LINE.CLASS_FLD

OA2

HR_ACCTG_LINE.CHARTFIELD3

Project

HR_ACCTG_LINE.PROJECT_ID

Activity

HR_ACCTG_LINE.ACTIVITY_ID

PC Source Type

HR_ACCTG_LINE.RESOURCE_TYPE

PC Category

HR_ACCTG_LINE.RESOURCE_CATEGORY

PC Subcategory

HR_ACCTG_LINE.RESOURCE_SUB_CAT

Process Instance

HR_ACCTG_LINE.PROCESS_INSTANCE

User ID

HR_ACCTG_LINE.OPRID

Version History

Date

Revision Description

06/04/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.