Skip to main content
Skip table of contents

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.