- 23 Sep 2024
- 5 Minutes to read
-
Print
-
DarkLight
-
PDF
Schedule of Allotment Balance Report (KKR008)
- Updated on 23 Sep 2024
- 5 Minutes to read
-
Print
-
DarkLight
-
PDF
Report Description
The Schedule of Allotment Balances Report allows users with security access to run a report to reflect recorded Allotments, Encumbrance, expenditures, and associated remaining balances for designated time periods grouped by designated ChartField and ChartField combinations.
Report Navigation: Main Menu > Florida PALM > Reports> KK > Schedule of Allotment Balances Report
See the sample layout report below.
Business Roles
The following business roles have access to this report:
Business Process Models
This report can be found in the following business processes:
- 10.3.1 Perform Month-End Close
- 20.1.2 Manage Agency Allotments
- 20.1.4 Agency Estimated Revenue
- 90.2.3 Monitor and Closeout Grant
- 90.3.2 Monitor and Closeout Contracts
Selection Criteria
The report data can be filtered by the following selection criteria:
Data Field | Data Field Details |
Report Request Parameters | |
Business Unit (BU) |
Required |
Date From |
Required |
Date To |
Required |
ChartField (CF) Selection | |
Organization |
Optional |
Account |
Optional |
Fund |
Optional |
Budget Entity |
Optional |
Category |
Optional |
State Program |
Optional |
Grant |
Optional |
Contract |
Optional |
OA1 |
Optional |
OA2 |
Optional |
PC Business Unit |
Optional |
Project |
Optional |
Activity |
Optional |
PC Source Type |
Optional |
Report Layout
The layout of the report is listed below. Description of data fields can be found in the .
Data Field | Florida PALM RECORD.FIELD mapping |
Report Header | |
Business Unit | Run Control Page value |
Date From | Run Control Page value |
Date To | Run Control Page value |
Organization | Run Control Page value |
Account | Run Control Page value |
Fund | Run Control Page value |
Budget Entity | Run Control Page value |
Category | Run Control Page value |
State Program | Run Control Page value |
Grant | Run Control Page value |
Contract | Run Control Page value |
OA1 | Run Control Page value |
OA2 | Run Control Page value |
PC Business Unit | Run Control Page value |
Project | Run Control Page value |
Activity | Run Control Page value |
PC Source Type | Run Control Page value |
Report Sub-Header Section | |
Business Unit | Run Control Page value |
Organization | Run Control Page value |
Fund | Run Control Page value |
Budget Entity | Run Control Page value |
Report Detail | |
Organization | KK_ACTIVITY_LOG.DEPTID |
Account | KK_ACTIVITY_LOG.ACCOUNT |
Account Description | Account ChartField description |
Fund | KK_ACTIVITY_LOG.FUND_CODE |
Budget Entity | KK_ACTIVITY_LOG.BUDGET_REF |
Category | KK_ACTIVITY_LOG.PRODUCT |
State Program | KK_ACTIVITY_LOG.CHARTFIELD2 |
Grant | KK_ACTIVITY_LOG.PROGRAM_CODE |
Contract | KK_ACTIVITY_LOG.CHARTFIELD1 |
OA1 | KK_ACTIVITY_LOG.CLASS_FLD |
OA2 | KK_ACTIVITY_LOG.CHARTFIELD3 |
PC Business Unit | KK_ACTIVITY_LOG.BUSINESS_UNIT_PC |
Project | KK_ACTIVITY_LOG.PROJECT_ID |
Activity | KK_ACTIVITY_LOG.ACTIVITY_ID |
PC Source Type | KK_ACTIVITY_LOG.RESOURCE_TYPE |
Allotments |
|
Expenditures (MTD) |
|
Expenditures (YTD) |
|
Encumbrances |
|
Allotment Balances | (Allotment - Expenditures (YTD) – Encumbrance) * -1 |
Version History
Date | Revision Description |
12/01/2023 | Original Version |