Census Bureau Detailed Expenditures and Revenues Report (GLR163)
-
Print
-
DarkLight
-
PDF
Census Bureau Detailed Expenditures and Revenues Report (GLR163)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A custom report containing detailed expenditure and revenue totals by Account value provided to the US Census Bureau.
Report containing summarized detailed expenditure and revenue totals by Account value, and titles provided to the US Census Bureau in 3 text files.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- FLP_GL_Reporter (at Enterprise Level)
Suggested Report Frequency
- Annually
Business Process Models
This report can be found in the following business processes:
- N/A
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 | Y | WC_LEDGER_D.FISCAL_YEAR | Y | Y |
Accounting Period | N | WC_LEDGER_D.ACCOUNTING_PERIOD | N | Y |
Report Columns
The layout of the report is listed below.
| Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Expense Tab |
|
Business Unit | WC_LEDGER_D.BUSINESS_UNIT |
GAAFR | WC_CF_ATTRIB_TBL_D.CF_ATTRIB_VALUE WHERE FIELDNAME LIKE ‘FUND_CODE’ AND CF_ATTRIBUTE LIKE ‘GAAFR’ |
SF | WC_CF_ATTRIB_TBL_D.CF_ATTRIB_VALUE WHERE FIELDNAME LIKE ‘FUND_CODE’ AND CF_ATTRIBUTE LIKE ‘SF INDICATOR’ |
Fund | WC_LEDGER_D.FUND_CODE |
Budget Entity | WC_LEDGER_D.BUDGET_REF |
Account | WC.LEDGER_D.ACCOUNT |
Posted Total Amount | WC_GL_LEDGER_F.POSTED_TOTAL_AMT |
Business Unit Title | WC_BUS_UNIT_FS_D.DESCR |
Budget Entity Title | WC_BUD_REF_D.DESCR |
Account Title | WC_GL_ACCOUNT_TBL_D.DESCR |
Fund Title | WC_LEDER_D.DESCR |
Revenue Tab |
|
Business Unit | WC_LEDGER_D.BUSINESS_UNIT |
GAAFR | WC_CF_ATTRIB_TBL_D.CF_ATTRIB_VALUE WHERE FIELDNAME LIKE ‘FUND_CODE’ AND CF_ATTRIBUTE LIKE ‘GAAFR’ |
SF | WC_CF_ATTRIB_TBL_D.CF_ATTRIB_VALUE WHERE FIELDNAME LIKE ‘FUND_CODE’ AND CF_ATTRIBUTE LIKE ‘SF INDICATOR’ |
Fund | WC_LEDGER_D.FUND_CODE |
Budget Entity | WC_LEDGER_D.BUDGET_REF |
Account | WC.LEDGER_D.ACCOUNT |
Posted Total Amount | WC_GL_LEDGER_F.POSTED_TOTAL_AMT * -1 |
Business Unit Title | WC_BUS_UNIT_FS_D.DESCR |
Budget Entity Title | WC_BUD_REF_D.DESCR |
Account Title | WC_GL_ACCOUNT_TBL_D.DESCR |
Fund Title | WC_LEDER_D.DESCR |
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/13/2025 | Added
|
Was this article helpful?
