-
Print
-
DarkLight
-
PDF
HR Accounting Line Report (PRR001)
-
Print
-
DarkLight
-
PDF
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 | |
Accounting Date | HR_ACCTG_LINE.ACCOUNTING_DT |
Budget Date | HR_ACCTG_LINE.BUDGET_DT |
Monetary Amount | |
Journal ID | HR_ACCTG_LINE.JOURNAL_ID |
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 | |
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 |