Multi-Year Project, Contract or Grant Activity Summary Report (GLR168)
-
Print
-
DarkLight
-
PDF
Multi-Year Project, Contract or Grant Activity Summary Report (GLR168)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that summarizes transaction amounts for a given date range of FLAIR and Florida PALM project, grant, or contract transactions from the General Ledger. This report will be based on a date range and will only include transactions if grant, contract, and/or project chart code are used for Florida PALM and/or FLAIR.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- FLP GL Reporter
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 |
|---|---|---|---|---|
Business Unit | N | WC_LEDGER_D.BUSINESS_UNIT | Y | Y |
Fiscal Year | N | W_MCAL_DAY_D.MCAL_YEAR | N | Y |
Grant | N | W_GL_ACCOUNT_D.ACCOUNT_SEG3_CODE | Y | Y |
Contract | N | W_GL_ACCOUNT_D.ACCOUNT_SEG11_CODE | Y | Y |
Project ID | N | W_GL_ACCOUNT_D.ACCOUNT_SEG7_CODE | Y | Y |
OA1 | N | W_GL_ACCOUNT_D.ACCOUNT_SEG4_CODE | Y | Y |
OA2 | N | W_GL_ACCOUNT_D.ACCOUNT_SEG13_CODE | Y | Y |
OLO | N | D_TRN_HIST.OLO_CD | N | Y |
FY_END | N | D_TRN_HIST.STFY_END_NBR | N | Y |
Grant NBR | N | D_TRN_HIST.GRNT_ID | N | Y |
Contract NBR | N | D_TRN_HIST.CTRT_ID | N | Y |
Project ID | N | D_TRN_HIST.PROJ_ID | N | Y |
OCA_CD | N | D_TRN_HIST.OCA_CD | N | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | WC_LEDGER_D.BUSINESS_UNIT |
Fund | WC_LEDGER_D.FUND_CODE |
Budget Entity | WC_LEDGER_D.BUDGET_REF |
Category | WC_LEDGER_D.PRODUCT |
Account | WC_LEDGER_D.ACCOUNT |
Grant | W_GL_ACCOUNT_D.ACCOUNT_SEG3_CODE |
Contract | W_GL_ACCOUNT_D.ACCOUNT_SEG11_CODE |
Project ID | W_GL_ACCOUNT_D.ACCOUNT_SEG7_CODE |
OA1 | W_GL_ACCOUNT_D.ACCOUNT_SEG4_CODE |
OA2 | W_GL_ACCOUNT_D.ACCOUNT_SEG13_CODE |
Amount | WC_LEDGER_D.POSTED_TOTAL_AMT |
FLAIR |
|
FY End | D_TRN_HIST.STFY_END_NBR |
As of Month Year | D_TRN_HIST.CMCY_NBR |
OLO | D_TRN_HIST.OLO_CD |
FID | D_TRN_HIST.ST_ID |
BE_CD | D_TRN_HIST.BE_STD_CD |
CAT | D_TRN_HIST.CTG_CD |
GL_CD | D_TRN_HIST.GLA_GAFR_TYPE_CD |
OCA | D_TRN_HIST.OCA_CD |
Grant_NBR | D_TRN_HIST.GRNT_ID |
Contract_NBR | D_TRN_HIST.CTRT_ID |
Project_ID | D_TRN_HIST.PROJ_ID |
Amount | D_TRN_HIST.TRN_AMT |
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/08/2025 | Added content to Report Sample Layout, Report Prompts, and Report Columns section. |
Was this article helpful?
