EMIS Federal Assistance Detail Report - File Layout and Data Mapping
The default file names for the EMIS Federal Assistance Detail report are:
PDF:
EMIS Federal Assistance Detail Report_<MMDDYYYY>_<hhmmss>.pdfExcel:
EMIS Federal Assistance Detail Report_<MMDDYYYY>_<hhmmss>.csv
The following table shows the columns, fields, descriptions, and data source or valid values for the EMIS Federal Assistance Detail report.
Column in PDF | Column in CSV | Field | Description | Data Source or Valid Values |
---|---|---|---|---|
1 | A | CFDA | The five-digit number from the grantor that identifies that program. It must be unique for each detail record. | Retrieved from the CFDA Number field on the EMIS Federal Assistance Detail form. |
2 | B | GRANT TITLE | The name of the federal program supplying federal funds. | Retrieved from the Grant Title field on the EMIS Federal Assistance Detail form. |
3 | C | 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. | Retrieved from the Fund field on the EMIS Federal Assistance Detail form. |
4 | D | 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. | Retrieved from the Special Cost Center field on the EMIS Federal Assistance Detail form. |
5 | E | RECEIVED | All monies received and available for expenditures during the current fiscal year. | Retrieved from the Federal Contribution Received field on the EMIS Federal Assistance Detail form. |
6 | F | EXPENDITURE | The amount of expenditures of federal funds. | Retrieved from the Federal Expenditure field on the EMIS Federal Assistance Detail form. |