Spend Plan Report (KKR010)
-
Print
-
DarkLight
-
PDF
Spend Plan Report (KKR010)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report displaying appropriations balances, encumbrances, expenditures (actuals and scheduled payments), and available balances.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Coming Soon!
Report Navigation
Coming Soon!
Report Audience
Suggested Report Frequency
- Ad Hoc
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
| Parameter Name | Data Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Budget Period | N | WC_LEDGER_KK_D. FISCAL_YEAR | Y | Y |
Business Unit | N | WC_LEDGER_KK_D. BUSINESS_UNIT | Y | Y |
Budget Entity | N | WC_LEDGER_KK_D. BUDGET_REF | N | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
| Business Unit Table | |
Business Unit | WC_LEDGER_KK_D. BUSINESS_UNIT WC_LEDGER_D. BUSINESS_UNIT |
Category Description | WC_LEDGER_KK_D.PRODUCT || ' ' || W_GL_SEGMENT_D_TL.SEGMENT_VAL_DESCR |
Fund | W_BALANCING_SEGMENT_D.BALANCING_SEGMENT_VAL_CODE || ' - ' || W_GL_SEGMENT_D_TL.SEGMENT_VAL_DESCR |
Appropriations | NVL(SUM(CASE WHEN WC_LEDGER_KK_D.LEDGER = 'C_APPR_BD' THEN WC_GL_LEDGER_KK_F.POSTED_TOTAL_AMT END), 0) |
Year-To-Date Disbursements | NVL(SUM(CASE WHEN WC_LEDGER_D.LEDGER = 'CASH_BASIS' THEN WC_GL_LEDGER_F.POSTED_TOTAL_AMT END), 0) |
Commitments | NVL(SUM(CASE WHEN WC_LEDGER_KK_D.LEDGER = 'C_APPR_ENC' THEN WC_GL_LEDGER_KK_F.POSTED_TOTAL_AMT END), 0) |
Unobligated Balance | Calculation = Appropriations – (Commitments + Year-To-Date Disbursements) |
Projections | NULL |
Projected Balance (Surplus/Deficit) | NVL(SUM(CASE WHEN WC_LEDGER_D.LEDGER = 'CASH_BASIS' THEN WC_GL_LEDGER_F.POSTED_TOTAL_AMT END), 0) |
Comments | NULL |
Budget Entity Table | |
Business Unit | WC_LEDGER_KK_D. BUSINESS_UNIT |
Budget Entity | WC_LEDGER_KK_D. BUDGET_REF |
Category Description | WC_LEDGER_KK_D.PRODUCT || ' ' || W_GL_SEGMENT_D_TL.SEGMENT_VAL_DESCR |
Fund | W_BALANCING_SEGMENT_D.BALANCING_SEGMENT_VAL_CODE || ' - ' || W_GL_SEGMENT_D_TL.SEGMENT_VAL_DESCR |
Appropriations | NVL(SUM(CASE WHEN WC_LEDGER_KK_D.LEDGER = 'C_APPR_BD' THEN WC_GL_LEDGER_KK_F.POSTED_TOTAL_AMT END), 0) |
Year-To-Date Disbursements | NVL(SUM(CASE WHEN WC_LEDGER_D.LEDGER = 'CASH_BASIS' THEN WC_GL_LEDGER_F.POSTED_TOTAL_AMT END), 0) |
Commitments | NVL(SUM(CASE WHEN WC_LEDGER_KK_D.LEDGER = 'C_APPR_ENC' THEN WC_GL_LEDGER_KK_F.POSTED_TOTAL_AMT END), 0) |
Unobligated Balance | Calculation = Appropriations – (Commitments + Year-To-Date Disbursements) |
Projections | NULL |
Projected Balance (Surplus/Deficit) | NVL(SUM(CASE WHEN WC_LEDGER_D.LEDGER = 'CASH_BASIS' THEN WC_GL_LEDGER_F.POSTED_TOTAL_AMT END), 0) |
Comments | NULL |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configuration Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
| 01/31/2025 | Original Version |
| 04/18/2025 | Added content to Report Prompts and Report Columns sections. |
Was this article helpful?
