Federal Assistance Detail
Use the EMIS Federal Assistance Detail page to add and update information about a school or district's federal and governmental agency funding. You must populate this table manually.
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 Searching 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.
To download the information, select Download, then select Download PDF or Download as an Excel Document.
Field descriptions
The following table describes the fields on the EMIS Federal Assistance Detail form.
Field | Description |
|---|---|
Record Number | The system-generated record number unique for the financial record type, reporting period, and fiscal year. This field cannot be edited. |
Schedule Number | The state-specified schedule number. The valid value is FAD. This field cannot be edited. |
Record Status | The status of the record. The valid value is A - Add. This field cannot be edited. |
CFDA Number | The five-digit number from the grantor that identifies that program. It must be unique for each detail record. |
Sort Type | The sort type for the record. The valid value is QC. This field cannot be edited. |
Grant Title | The name of the federal program supplying federal funds. |
Fiscal Year | The EMIS fiscal year. The value is retrieved from the Financial Fiscal Year field on the EMIS Profile page. This field cannot be edited. |
Fund | The fund that receives the federal funds. The three-digit code is assigned by the State Auditor's Office to ensure money is spent for specified purposes. |
Reporting Period | The period of the fiscal year to report on. The value is retrieved from the Financial Reporting Period field on the EMIS Profile page. This field cannot be edited. |
Special Cost Center | The special cost center for the fund, if applicable. This four-digit code that tracks costs for temporary or specific needs when defining funds. State and federal mandates require this code to subdivide funds. |
District IRN | The six-digit state-assigned Information Retrieval Number (IRN). The value is retrieved from the District IRN field on the EMIS Profile page. This field cannot be edited. |
Federal Contribution Received | All monies received and available for expenditures during the current fiscal year. |
Schedule Sequence | The state-specified schedule sequence. The valid value is ZAZ. This field cannot be edited. |
Federal Expenditure | The amount of expenditures of federal funds. |
Schedule Frequency | The state-specified schedule frequency. The valid value is 1. This field cannot be edited after saving the record. |
Line Number | The state-specified line number. The valid values are 1 - 999. This field cannot be edited. |
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