Revenue CAP Report (GLR086)
  • Dark
    Light
  • PDF

Revenue CAP Report (GLR086)

  • Dark
    Light
  • PDF

Article summary

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

Coming Soon!

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/2025Added report columns, report prompts, and file sample layout

Design Document(s)



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.