Data Export

Use the EMIS Data Export page to export EMIS data in accordance with the specifications in various sections, such as Staff Demographics and Financial Data. You can use combinations of filters to include and exclude different EMIS data points in the report.

From the EMIS menu, select EMIS Data Export.
Refer to the Field descriptions and enter or select valid values.
Select Create and then select Yes.
Save the EMIS Staff Export Validation Report.
Select Yes to save the emisdata.seq file to the local computer and the server directory.
Save the EMIS Data Export status log and select OK.
Save the emisdata.seq file.

For detailed information about the emisdata.seq file layout, refer to:

Field descriptions

This section describes the fields on the following:

Report Header Information section

The Report Header Information section on the EMIS Data Export page displays reference information from the EMIS Profile that identifies the export parameters. This section serves both informational and functional purposes:

The following table describes the fields in the Report Header Information section of the EMIS Data Export page.

Field	Description	Data source and Valid values
Report Date	The date to be included in the export file header. The default value is the current date.	Not applicable
Report Time	The time to be included in the export file header. This field is view-only.	The valid value is the time when you accessed the EMIS Data Export page.
Reporting Period	The current EMIS reporting period. This field has three columns: Staff Financial Forecast These fields are view-only.	Valid values: Staff: The value is retrieved from the Staff Reporting Period field on the EMIS Profile page. Financial: The value is retrieved from the Financial Reporting Period field on the EMIS Profile page. Forecast: The valid value is P.
Start Period	The start date of the current financial reporting period. This date marks the start of the financial data's date range in the export. This field has three columns: Staff Financial Forecast These fields are view-only.	Valid values: Staff: This field is blank. Financial: The value is retrieved from the Start Period field on the EMIS Profile page. Forecast: This field is blank.
End Period	The end date of the current financial reporting period. This date defines the end of the date range for financial data included in the export. This field has three columns: Staff Financial Forecast These fields are view-only.	Valid values: Staff: This field is blank. Financial: The value is retrieved from the End Period field on the EMIS Profile page. Forecast: This field is blank.
Fiscal Year	The current EMIS fiscal year. All exported records will be associated with the corresponding fiscal year. This field has three columns: Staff Financial Forecast These fields are view-only.	Valid values: Staff: The value is retrieved from the Staff Fiscal Year field on the EMIS Profile page. Financial: The value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. Forecast: The value is retrieved from the Forecast Fiscal Year field on the EMIS Profile page.
Reporting District	The district's six-digit Information Retrieval Number (IRN). This IRN identifies the district submitting the data and is included in all exported records. This field has three columns: Staff Financial Forecast These fields are view-only.	Valid values: Staff: The value is retrieved from the District IRN field on the EMIS Profile page. Financial: This field is blank. Forecast: This field is blank.

Staff Information tab

Use the Staff Information tab to select which staff-related record types to include in the emisdata.seq export file for submission to the Ohio Department of Education (ODE).

The following table describes the fields on the Staff Information tab of the EMIS Data Export page.

Field	Description
Export Staff Demographic Data	Indicates whether to include CI (Staff Demographic) records in the export file. Select Criteria to select, add, update, or delete advanced search queries. For more information on advanced search queries, refer to Advanced Search.
Export Staff Employment Data	Indicates whether to include CK (Staff Employment) records in the export file. Select Criteria to select, add, update, or delete advanced search queries. For more information on advanced search queries, refer to Advanced Search.
Export Contractor Staff Employment Data	Indicates whether to include CJ (Contractor Staff) records in the export file.
Export Contract Only Staff Data	Indicates whether to include CC (Contract Only) records in the export file.
Export Staff Summer Employment Separation Data	Indicates whether to include CL (Summer Employment Separation) records in the export file.
Use Employee ID	Indicates whether to use the district's internal employee number instead of the Ohio State Staff ID (EMIS Employee ID) when generating CI and CK export records. This option is useful for districts that need to cross-reference exported data with their internal employee numbering system.

Financial Information tab

Use the Financial Information tab to select which financial record types to include in the emisdata.seq export file for submission to the Ohio Department of Education (ODE).

The following table describes the fields on the Financial Information tab of the EMIS Data Export page.

Field	Description
Export DN Financial Data	Indicates whether to include DN (Organization Building) records in the export file.
Export QC Financial Data	Indicates whether to include QC (Financial) records in the export file.
Cash Selection Criteria	Displays a criteria selection page to filter which cash balance records are included in the QC financial export. Allows users to specify parameters, such as fund codes, account ranges, and other attributes, to limit the cash data exported. For more information on advanced search queries, refer to Advanced Search.
Expenditure Selection Criteria	Displays a criteria selection page to filter which expenditure records are included in the QC financial export. Allows users to specify parameters, such as fund codes, function codes, object codes, or account ranges, to limit the exported expenditure data. For more information on advanced search queries, refer to Advanced Search.
Receipt Selection Criteria	Displays a criteria selection page to filter which receipt/revenue records are included in the QC financial export. Allows users to specify parameters, such as fund codes, revenue source codes, or account ranges, to limit the exported receipt data. For more information on advanced search queries, refer to Advanced Search.
Operational Unit Selection Criteria	Displays a criteria selection page to filter which operational unit records are included in the QC financial export. Allows users to specify parameters to limit the operational unit data exported for cost center or program reporting. For more information on advanced search queries, refer to Advanced Search.
Exhibit 1 Selection Criteria	Displays a criteria selection page to filter which Exhibit 1 records are included in the QC financial export. Exhibit 1 contains supplemental financial schedule data required by the Ohio Department of Education. For more information on advanced search queries, refer to Advanced Search.
Federal Assistance Summary Selection Criteria	Displays a criteria selection page to filter which federal assistance summary records are included in the QC financial export. These records summarize federal grant funding received by the district at an aggregate level. For more information on advanced search queries, refer to Advanced Search. This field is displayed when the Financial Fiscal Year on the EMIS Profile page is 2023 or earlier.
Federal Assistance Detail Selection Criteria	Displays a criteria selection page to filter which federal assistance detail records are included in the QC financial export. These records provide line-item detail of federal grant expenditures and funding sources. For more information on advanced search queries, refer to Advanced Search. This field is displayed when the Financial Fiscal Year on the EMIS Profile page is 2023 or earlier.
Statement R Detail Selection Criteria	Displays a criteria selection page to filter which Statement R detail records are included in the QC financial export. Statement R contains detailed information about specific financial transactions or balances required for state reporting. For more information on advanced search queries, refer to Advanced Search.
Statement R Description Selection Criteria	Displays a criteria selection page to filter which Statement R description records are included in the QC financial export. These records provide descriptive text or narrative information accompanying Statement R detail data. For more information on advanced search queries, refer to Advanced Search.
Capital Assets Selection Criteria	Displays a criteria selection page to filter which capital assets records are included in the QC financial export. These records contain information about the district's fixed assets, including land, buildings, equipment, and infrastructure, for financial reporting purposes. For more information on advanced search queries, refer to Advanced Search.

Miscellaneous Information tab

Use the Miscellaneous Information tab to select Five Year Forecast record types to include in the emisdata.seq export file for submission to the Ohio Department of Education (ODE).

The following table describes the fields on the Miscellaneous Information tab of the EMIS Data Export page.

Field

Description

Export QF Financial Data

Indicates whether to include QF (Five Year Forecast) and QN (Five Year Forecast Notes) records in the export file. QF records contain the district's projected financial data for the current year and the four following years, including anticipated revenues, expenditures, and fund balances. QN records contain the required explanatory notes that accompany the forecast.

Five Year Forecast Selection Criteria

Displays a criteria selection page to filter which five-year forecast records are included in the QF export. Allows users to specify parameters such as forecast version, fund codes, line item categories, or fiscal years to limit the forecast data exported for state submission.

For more information on advanced search queries, refer to Advanced Search.

Five Year Notes Selection Criteria

Displays a criteria selection page to filter which five-year forecast notes records are included in the QN export. Allows users to specify parameters to limit which explanatory notes and assumptions are exported. These notes provide context and justification for the projected figures in the five-year forecast, as required by the Ohio Department of Education.

For more information on advanced search queries, refer to Advanced Search.