Federal Assistance Detail
Use the EMIS Federal Assistance Detail page to add, update, delete, search, and print federal grant assistance records for Ohio EMIS state reporting. This page allows users to manage FAD (Federal Assistance Detail) schedule records that track federal grant funding received and expended, organized by CFDA (Catalog of Federal Domestic Assistance) number, grant title, fund, and special cost center. The data is used to generate the EMIS Federal Assistance Detail Report (QC record type with schedule number FAD) for submission to the Ohio Department of Education.
Maintain data
On the start page, select EMIS.
From the EMIS Financial Tables menu, select Federal Assistance Detail.
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 Federal Assistance Detail form of the EMIS Federal Assistance Detail page.
Field | Description | Data source and Valid values |
|---|---|---|
Record Number | A system-generated sequential number that uniquely identifies each federal assistance detail record. This field is view-only. | The field value is system-generated. The value is calculated by retrieving the maximum existing record number from the database and incrementing it by 1. |
Schedule Number | The EMIS schedule identifier for this record type. This field is view-only. | The valid value is FAD. |
Record Status | Indicates the status of the record for EMIS submission. This field is view-only. | The valid value is A - Add. |
CFDA Number | The Catalog of Federal Domestic Assistance (CFDA) number identifying the federal program. This is a five-character code that serves as the unique identifier for each federal assistance detail record within a fiscal year, reporting period, and schedule frequency combination. | Not applicable |
Sort Type | The EMIS record type identifier. This field is view-only. | The valid value is QC. |
Grant Title | The title or name of the federal grant program. | Not applicable |
Fiscal Year | The fiscal year for which the federal assistance is being reported. This field is view-only. | The field value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. |
Fund | The three-character fund code associated with the federal grant. This identifies the district fund where federal revenues and expenditures are recorded. | Not applicable |
Reporting Period | The EMIS reporting period for this record. This field is view-only. | Valid values:
The field value is retrieved from the Financial Reporting Period field on the EMIS Profile page. |
Special Cost Center | The four-character special cost center code that further categorizes the federal assistance. Used to identify specific programs or projects within a fund. | Not applicable |
District IRN | The six-digit state-assigned Information Retrieval Number (IRN) assigned to the school district. This field is view-only. | The field value is retrieved from the District IRN field on the EMIS Profile page. |
Federal Contribution Received | The dollar amount of federal contributions received for this grant during the reporting period. | Not applicable |
Schedule Sequence | The three-character sequence code for the schedule. This field is view-only. | The valid value is ZAZ. |
Federal Expenditure | The dollar amount of federal expenditures for this grant during the reporting period. | Not applicable |
Schedule Frequency | The schedule frequency code indicating how often this record is reported. Used in combination with CFDA Number, Fiscal Year, and Reporting Period to determine record uniqueness. This field cannot be updated after saving the record. | The valid value is 1. |
Line Number | A sequential line number within the schedule. This field is view-only. | The valid values are 1-999. |
Create file
On the EMIS Federal Assistance Detail page, select Report.
Select the Reporting Period and Fiscal Year.
Select PDF or Excel.
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 names are:PDF:
EMIS Federal Assistance Detail Report_<MMDDYYYY>_<hhmmss>.pdfExcel:
EMIS Federal Assistance Detail Report_<MMDDYYYY>_<hhmmss>.csv
For detailed information about the report’s file layout, refer to EMIS Federal Assistance Detail Report - File Layout and Data Mapping.