GR Service Charge Report (IUR002)
-
Print
-
DarkLight
-
PDF
GR Service Charge Report (IUR002)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A Data Warehouse report outlining the General Revenue Service Charge and related transaction details. It includes two tabs:
The first tab summarizes revenue collection and the applicable GR Service Charge, categorized by Fund, Budget Entity, and Category for each Agency.
The second tab details individual transactions, including the associated ChartFields, which support the summary provided in the first tab.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
Report Frequency
Periodic
Monthly
Quarterly
Annually
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 |
|---|---|---|---|---|
Journal Date | N | WC_JRNL_LN_D.JOURNAL_DATE | Y | Y |
Business Unit | N | WC_JRNL_LN_D.BUSINESS_UNIT | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Tab 1 | |
Business Unit | WC_JRNL_LN_D.BUSINESS_UNIT |
Fund Code | WC_JRNL_LN_D.FUND_CODE |
Budget Entity | WC_JRNL_LN_D.BUDGET_REF |
GR Service Charge Percentage | WC_JRNL_LN_D.GRSC_PERCENT_VALUE |
Category | WC_JRNL_LN_D.PRODUCT |
Revenue Collected | WC_GL_JRNL_F.REVENUE_COLLECTED |
Revenue Applicable to GR Service Charge | WC_GL_JRNL_F.REVENUE_APPLICABLE |
GR Service Charge Due | WC_GL_JRNL_F.GRSC_DUE |
Tab 2 | |
Business Unit | WC_JRNL_LN_D.BUSINESS_UNIT |
Fund Code | WC_JRNL_LN_D.FUND_CODE |
Budget Entity | WC_JRNL_LN_D.BUDGET_REF |
Journal ID | WC_JRNL_HDR_D.JOURNAL_ID |
Journal Line | WC_JRNL_LN_D.JOURNAL_LINE |
Journal Date | WC_JRNL_LN_D.JOURNAL_DATE |
Fiscal Year | WC_JRNL_HDR_D.FISCAL_YEAR |
Accounting Period | WC_JRNL_HDR_D.ACCOUNTING_PERIOD |
Organization | WC_JRNL_LN_D.DEPTID |
Account | WC_JRNL_LN_D.ACCOUNT |
Fund Code | WC_JRNL_LN_D.FUND_CODE |
Fund Description | WC_JRNL_LN_D.FUND_DESC |
GR Service Charge Percentage | WC_JRNL_LN_D.GRSC_PERCENT_VALUE |
Budget Entity | WC_JRNL_LN_D.BUDGET_REF |
Category | WC_JRNL_LN_D.PRODUCT |
GR Service Charge Exempt Value | WC_JRNL_LN_D.GRSC_EXEMPT_VALUE |
State Program | WC_JRNL_LN_D.CHARTFIELD2 |
Grant | WC_JRNL_LN_D.PROGRAM_CODE |
Contract | WC_JRNL_LN_D.CHARTFIELD1 |
OA1 | WC_JRNL_LN_D.CLASS_FLD |
OA2 | WC_JRNL_LN_D.CHARTFIELD3 |
Project ID | WC_JRNL_LN_D.PROJECT_ID |
Monetary Amount | WC_GL_JRNL_F.MONETARY_AMOUNT |
Budget Date | WC_JRNL_LN_D.BUDGET_DT |
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/07/2025 | Added content to Report Sample Report, Report Prompts, Report Columns section. |
Was this article helpful?
