DBI Actual Revenues

Menu Path

Fund Accounting > State > State - OR > DBI Actual Revenues

Submission Period

Yearly (fiscal year)

Selection Rule

Extracts the DBI actual revenue records from actual revenue files for the selected fiscal year based on the reporting structure and the other reference tables setup (Crosswalk, this means the regular areas, functions, etc, and translations).

Setup

1. Select Setup > Reporting Structure.

2. To edit a record, click the ellipsis in the Actions column, and select Edit.

3. Click Save.

Load Data

You can load data based on the Fiscal Year.

1. On the navigation bar, select Load.

2. Select the Fiscal Year.

3. Click Load, then Yes. The following pdf files are created:

   • OR DBI Actual Revenues_Error Report_<timestamp> (if errors were encountered)

   • OR DBI Actual Revenues_Load Summary Report_<timestamp>

     

     Depending on the browser type, the files are displayed within the browser, or you are prompted to select a download location.

4. Save the files, then click OK.

5. Navigate to the folder containing the files.

6. Inspect the files. Update data, if needed.

7. Repeat steps 1 to 6 until all required data is loaded.

Maintain Data

You can correct loaded data before submitting the report. However, any changes made here must be duplicated in the source data.

1. On the OR DBI Actual Revenues page, you can filter records to display by the following criteria:

   • Fund

   • Source

   • Amount

2. To specify filter criteria, select an option from the list, enter a keyword or select an option in the following field, and click Add. The filter is added.

3. To add a record, click Add Record. Specify valid information in the Required fields and click Save. Click Yes.

   • To edit a record, click the ellipsis in the Actions column, and select Edit.

   • To delete a record, click the ellipsis in the Actions column, and select Delete. Click Yes.

4. To download the information, click Download, then select Download PDF or Download as an Excel Document.

Create File

1. On the navigation bar, select Report.

2. Select the Fiscal Year.

3. Create a hard copy of the report to verify data before you create the electronic file:

   1. Under File Type, select Hard Copy.

   2. Under File Format, select PDF or Excel.

   3. Click Create, then click Yes.
      The DBI Actual Revenues report is created. If report creation encounters any errors, an error message appears. Click OK.

      

      Depending on the browser type, the report file is displayed within the browser, or you are prompted to select a download location.

4. Save the files and navigate to the folder containing the report file.

5. Inspect the files. Update data, if needed.

6. Repeat steps 1 to 5 until all required data is included.

7. Create the electronic file:

   1. Under File Type, select Electronic File.

   2. Click Create, then click Yes.

Depending on the browser type, the report file is displayed within the browser, or you are prompted to select a download location.

Follow the state's submission procedures.

Purge Data

If you need to correct setups or data, first purge the existing records, then reload the data.

1. On the navigation bar, select Purge.

2. Select a Fiscal Year.

3. Click Submit.

4. Click Yes, then OK.