EFS Report - File Layout and Data Mapping
The default file name for the EFS report is efsect.csv.
The following table shows the columns, column names, descriptions, lengths, data sources or valid values, and usage for the EFS report.
Column | Column Name | Description | Length | Data Source or Valid Values | Usage |
---|---|---|---|---|---|
A | EFS Funding Source Code | The EFS Funding Source code. | 2 | For a list of valid values, refer to section 4.2 - EFS Funding Source Code in the Education Financial System User Guide. Retrieved from the Fund Source field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
B | EFS Function Code | The EFS Function code. | 4 | For a list of valid values, refer to section 4.3 - EFS Function Code in the Education Financial System User Guide. Retrieved from the Function Code field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
C | EFS Object Code | The EFS Object code. | 3 | For a list of valid values, refer to section 4.4 - EFS Object Code in the Education Financial System User Guide. Retrieved from the Object Code field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
D | EFS Education Type Code | The EFS Education Type code. | 1 | For a list of valid values, refer to section 4.5 - EFS Education Type Code in the Education Financial System User Guide. Retrieved from the Education Type field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
E | EFS PreK Code | The EFS Pre-Kindergarten code. | 1 | For a list of valid values, refer to section 4.6 - EFS PreK Code in the Education Financial System User Guide. Retrieved from the Pre K Code field on the Education Finance System Data form of the CT EFS Report page. | Optional |
F | EFS Allocation Code | The EFS Allocation code. | 1 | For a list of valid values, refer to section 4.7 - EFS Allocation Code in the Education Financial System User Guide. Retrieved from the Allocation Code field on the Education Finance System Data form of the CT EFS Report page. | Conditional |
G | CSDE Location Code | The CSDE Location code. | 7 | For a list of valid values, refer to section 4.8 - CSDE Location Code in the Education Financial System User Guide. Retrieved from the Location Code field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
H | Expenditure | The total amount of expenditures associated with the expenditure account. | 10.2 | Retrieved from the Amount field on the Education Finance System Data form of the CT EFS Report page. | Mandatory |
I | Local Account Code | The budget unit (low organization). | 200 | Retrieved from the *Budget Unit* field on the Education Finance System Data form of the CT EFS Report page. | Recommended |
J | Local Account Description | The budget unit (low organization) description. | 200 | Retrieved from the Description field on the Education Finance System Data form of the CT EFS Report page. | Recommended |
For the latest file layout information, search for and refer to the current file specification document on Connecticut’s Official State website.