Expense and Revenue by ALN/CSFA Report (GMR001)
-
Print
-
DarkLight
-
PDF
Expense and Revenue by ALN/CSFA Report (GMR001)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that summarizes General Ledger activities for expenses and revenues by ALN/CSFA numbers. This report will be used by Agency and Enterprise users to review summarized grant expenditures and revenues related to ALN/CSFA numbers.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
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 | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Element Type | ALN | Variable Column | Y | Y |
Journal Date | N | Project – Grants Management – Revenue and Expense.FLP GRANT Details.Grant ID | Y | Y |
Business Unit | N | Project – Grants Management – Revenue and Expense.FLP GRANT Details.Business Unit | Y | Y |
ALN | N | Project – Grants Management – Revenue and Expense.FLP ALN Details.ALN | Y | Y |
CSFA | N | Project – Grants Management – Revenue and Expense.FLP CSFA Details.CSFA | Y | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | Project – Grants Management – Revenue and Expense.FLP GRANT Details.Business Unit |
ALN | Project – Grants Management – Revenue and Expense.FLP ALN Details.ALN |
ALN Name | Project – Grants Management – Revenue and Expense.FLP ALN Details.ALN Name |
CSFA | Project – Grants Management – Revenue and Expense.FLP CSFA Details.CSFA |
CFSA Name | Project – Grants Management – Revenue and Expense.FLP CSFA Details.CSFA Name |
Grant ID | Project – Grants Management – Revenue and Expense.FLP GRANT Details.Grant ID |
Grant Title | Project – Grants Management – Revenue and Expense.FLP GRANT Details.Grant Title |
Revenues | Project – Grants Management – Revenue and Expense.Fact GM Revenue Details.Monetary Amount |
Expenditures | Project – Grants Management – Revenue and Expense.Fact GM Revenue Details.Monetary Amount |
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 |
| 04/11/2025 | Added content to Report Sample Layout, Report Prompts, and Report Columns section. |
Was this article helpful?
