Exhibit 1
Use the EMIS Exhibit 1 page to add, update, delete, search, and print fund balance records for Ohio EMIS state reporting. This page allows users to manage Exhibit 1 (EX1) schedule records that report fund balances organized by fund class categories, including Governmental Fund Balance (General, Special Revenue, Debt Service, Capital Projects, Permanent), Proprietary Fund Balance (Enterprise, Internal Service), and Fiduciary Fund Balance (Trust, Agency). The data is used to generate the EMIS Exhibit 1 Report (QC record type with schedule number EX1) for submission to the Ohio Department of Education.
The Exhibit 1 Load process populates this table with predetermined information.
Maintain data
On the start page, select EMIS.
From the EMIS Financial Tables menu, select Exhibit 1.
Filter records using the filter criteria. To enter filter criteria:
Select an option in the first field.
Select or enter a value.
Select Add if the button is enabled.
Refer to Search for Records for more information.To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, then Yes.
To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
Field descriptions
The following table describes the fields on the EMIS Exhibit 1 form of the EMIS Exhibit 1 page.
Field | Description | Data source and Valid values |
|---|---|---|
Record Number | A system-generated unique identifier for the Exhibit 1 record. This field is view-only. | Calculated during the data load process. The calculated value represents the next sequential record number. The system retrieves the maximum existing Record Number from the EMIS Exhibit 1 table for the selected Fiscal Year and Reporting Period, then increments it by 1 for each new record created during the load. |
Record Status | The status of the record for EMIS reporting. This field is view-only. | The valid value is A - Add. Populated during the data load process. The field value is set to the default A - Add for all records created during the load process. |
Sort Type | The record type identifier for EMIS. This field is view-only. | The valid value is QC. Populated during the data load process. The field is set to the default value QC for all records created during the load process. |
Fiscal Year | The fiscal year for the Exhibit 1 record. This field is view-only. | Populated during the data load process. The value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. |
Reporting Period | The EMIS reporting period. This field is view-only. | Valid values:
Populated during the data load process. The value is retrieved from the Financial Reporting Period field on the EMIS Profile page. |
District IRN | The district's six-digit state-assigned Information Retrieval Number (IRN). This field is view-only. | Populated during the data load process. The value is retrieved from the District IRN field on the EMIS Profile page. |
Schedule Sequence | The schedule sequence identifier for EMIS. This field is view-only. | The valid value is AAZ. Populated during the data load process. The field is set to the default value AAZ for all records created during the load process. |
Schedule Frequency | The schedule frequency code for EMIS. This field is view-only. | The valid value is 001. Populated during the data load process. The field is set to the default value 001 for all records created during the load process. |
Line Number | A numeric line identifier that determines the fund category. | The valid value depends on the value in the Depository Type field. Populated during the data load process. The field value is assigned based on the fund type being loaded:
|
Schedule Number | The schedule number identifier for EMIS. This field is view-only. | The valid value is EX1. Populated during the data load process. The field is set to the default value EX1 for all records created during the load process. |
Depository Name | The name of the fund or depository. | Valid values:
Populated during the data load process. The field value is assigned based on the fund type being loaded:
|
Depository Type | The category type of the fund balance. | Valid values:
Populated during the data load process. The field value is assigned based on the fund category:
|
Amount | The fund balance amount summed up from the EMIS Cash Table page. For more information, refer to Amount field calculation. | Calculated during the data load process. The calculated value represents the sum of fund balances from the EMIS Cash Table. For individual fund lines (114-118, 120-121, 123-124), the Amount is calculated by summing the Current Fund Balance field from all records on the EMIS Cash Table page that match the Fiscal Year, Reporting Period, and Fund Class code:
|
Amount field calculation
The following table shows how the value in the Amount column of the EMIS Exhibit 1 report is calculated based on the values in the Line Number, Depository Name, and Depository Type fields on the EMIS Exhibit 1 form.
Line Number | Depository Name | Depository Type | Amount |
|---|---|---|---|
114 | Governmental Fund Balance | General | csh_fundclass = 'G' |
115 | Governmental Fund Balance | Special Revenue | csh_fundclass = 'S' |
116 | Governmental Fund Balance | Debt Services | csh_fundclass = 'D' |
117 | Governmental Fund Balance | Capital Projects | csh_fundclass = 'C' |
118 | Governmental Fund Balance | Permanent | csh_fundclass='P' |
119 | Governmental Fund Balance | Total Governmental Fund Bal | The sum of the values for lines 114-118. |
120 | Propriety Fund Balance | Enterprise | csh_fundclass = 'E' |
121 | Propriety Fund Balance | Internal Service | csh_fundclass = 'I' |
122 | Propriety Fund Balance | Total Proprietary Fund Balance | The sum of the values for lines 120 and 121. |
123 | Fiduciary Fund Balance | Trust | csh_fundclass = 'R','V','W' |
124 | Fiduciary Fund Balance | Agency | csh_fundclass = 'A' |
125 | Fiduciary Fund Balance | Total Fiduciary Fund Balance | The sum of the values for lines 123 and 124. |
126 | Total Balances, All Funds | Total Balances All Funds | The sum of the values for lines 119, 122, and 125. |
Exhibit 1 Load
The EMIS Financial Load process must run before the Exhibit 1 load process, as the Exhibit 1 load process uses the cash records generated by the Financial Load process.
The field values on the EMIS Exhibit 1 Fund Load page are retrieved from the EMIS Profile page. If this information is incorrect, enter the correct information on the EMIS Profile page. After this, you can perform the Exhibit 1 fund load process.
On the EMIS Exhibit 1 page, select Exhibit 1 Load.
Select Load.
If data for the selected criteria is loaded, select Yes to delete and reload the data.
Select OK.
Create file
On the EMIS Exhibit 1 page, select Report.
Select the Reporting Period and Fiscal Year.
Select Create, and then Yes.
Save the file and select OK.
Navigate to the folder containing the report file.
Inspect the file. Update data if needed.
Repeat these steps until all the required data is included.
The default file name is EMIS Exhibit 1 Report_<MMDDYYYY>_<hhmmss>.pdf
For detailed information about the report’s file layout, refer to EMIS Exhibit 1 Report - File Layout and Data Mapping.