-
Print
-
DarkLight
-
PDF
Revenue CAP Report (GLR086)
-
Print
-
DarkLight
-
PDF
Report Description
A custom report providing balances by BU for specified categories (i.e., revenue and refund) for the fiscal year. Report that summarizes revenues collected by Business Unit and Category reflecting an attribute of "YES" for Revenue Cap. Agencies use this report to review revenue collected by categories.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Report Audience
- Florida PALM SME’s
- Key enterprise partners
Suggested Report Frequency
- Annually end of year
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 | Default Value | Column in Subject Area | Required (Y/N) | User Input |
---|---|---|---|---|
Fiscal Year | N | Financials – GL Balance Sheet.Time.Fiscal Year | Y | Y |
Business Unit | N | Financials – GL Balance Sheet.GL Fund Details.Business Unit | Y | Y |
Transactional Fund | N | Financials – GL Balance Sheet.GL Fund Details.Transactional Fund | N | Y |
Category | N | Financials – GL Balance Sheet.GL Fund Details.Category | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
---|---|
Fiscal Year | Financials – GL Balance Sheet.Time.Fiscal Year |
Business Unit | Financials – GL Balance Sheet.GL Fund Details.Business Unit |
GAAFR | Financials – GL Balance Sheet.GL CF Attribute Details.GAAFR |
SF Indicator | Financials – GL Balance Sheet.GL CF Attribute Details.SF Indicator |
Transactional Fund | Financials – GL Balance Sheet.GL Fund Details.Transactional Fund |
Budget Entity | Financials – GL Balance Sheet.GL Fund Details.Budget Entity |
Category | Financials – GL Balance Sheet.GL Fund Details.Category |
Revenue Cap | Financials – GL Balance Sheet.GL CF Attribute Details.Revenue Cap |
Posted Total Amount | Financials – GL Balance Sheet.Fact – Financials GL Ledger Transactions.Posted Total Amount (sum) |
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: Configured 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 |
02/04/2025 | Added report columns, report prompts, and file sample layout |
Design Document(s)