Criteria Selection on Reports

Most reports contain a prompt page that allows the user to customize the report output by selecting a few report parameters such as organization code, fiscal year and fiscal period. Standard reports have the output options of HTML or EXCEL formats.

The organizational level codes are commonly used for selecting specific criteria for financial reports. The Input columns on example tables below display the field codes that are entered as reporting criteria before the reports are run. Complexity of criteria selection vary among reports.

It should be noted that, VCU ODS (Operational Data Store) gets updated every night, as a result, the reports that are run during business hours do not reflect real-time production Banner (most current data). The data that is retrieved by these reports are current through the previous business day's transactions.

Fiscal Year: Unless otherwise stated on the report, all fiscal year entries must be made in the form of four digit (YYYY) year. Ex: 2008

Fiscal Period / Posting Period: All fiscal period or posting period entries must be made in the form of two digit (MM) month. Ex: 08 for February

It should be taken into account that the fiscal year at VCU starts on July 1st and ends on June 30th of each year. Two digit numeric representation of each month as follows;

Organizational Level Codes:  These codes will help business users to determine the scope of the reports. Organizational hierarchy and associated organizational code structure must be known and entered to utilize most of the financial reports. Tables below are examples for the organizational level codes. The full list of these codes can be obtained by using the report called Chart of Accounts. This report is located under the finance folder of Banner Reporting Center and can be accessed via VCU portal.

Organizational Level Codes - Example Purposes Only!

Executive Level Codes 

 Senior Mgmt.  Level Codes

MBU Level Codes