SACS Readme File 2017–18

For fiscal year 2017–18, 1,679 local educational agencies (LEAs) (990 districts, 631 charter schools, and 58 county offices of education) in California submitted their year-end unaudited actual (UA) financial data using the standardized account code structure (SACS).

The self-extracting zipped file sacs1718.exe contains two files: this readme file (sacs1718readme.docx) and a Microsoft Access database, sacs1718.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\1718SACS\Data. (You can change the extract directory.)

For more information related to the SACS financial reporting software, visit the California Department of Education’s Standardized Accont Code Structure (SACS) web page.

Notes:

• The Charters table includes charter schools’ K–12 average daily attendance (ADA).
• The K–12 ADA in the LEAs table located within the SACS database do not include ADA for charter schools that filed UA data in their authorizing agency’s General Fund (Fund 01).
• The county and state totals are located in a separate table: UserGL_Totals.

File Layouts for the Access Database

UserGL

General ledger information submitted by LEAs that have a SACS based accounting system.

UserGL_Totals

General ledger information submitted by LEAs that have a SACS based accounting system. Totals are by counties and state. Ccode and Dcode (“999” + Ccode) identify the counties’ subtotals. Ccode of “99” and Dcode of “99999” identify the state totals.

Look-up Description Tables

LEAs

Information on county offices of education, common administrative districts, joint powers agencies, and elementary, high, and unified school districts that filed in SACS for fiscal year 2017–18.

Fund

SACS Fund codes included in the UserGL data.

Resource

SACS Resource codes included in the UserGL data.

Goal

SACS Goal codes included in the UserGL data.

Function

SACS Function codes included in the UserGL data.

Object

SACS Object codes included in the UserGL data.

Charters

The Charters table contains information about the Charter Schools that filed in SACS, that filed in the Charter School Alternative Form (sometimes referred to as the “Charter Alt Form”), and that did not file year-end unaudited actual financial data for fiscal year 2017–18.

Charter School Reporting Record Counts

Report Type

Report Level

Fund Used in SACS

If you have suggestions for what information we might add that would make your analyses easier to perform, please contact the Office of Financial Accountability and Information Services by email or by phone as listed below.