SACS Readme File 2004–05

In fiscal year 2004–05, 1,439 local educational agencies (LEAs) (1,036 districts, 345 charter schools, and 58 county offices of education) in California submitted their financial data using the standardized account code structure.

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

For more information related to the Standardized Account Code Structure (SACS) financial reporting software, visit the SACS Web site.

Notes:

• We rolled the data in Fund 03 (General Fund Unrestricted) and Fund 06 (General Fund Restricted) into Fund 01 (General Fund/County School Service Fund). 
• We have the county and state totals in a separate table: UserGL_Totals.
• There are three tables for Charter School information: CharterFilingSACS, CharterFilingAlternativeForm, and CharterNotFiling.
  
  

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 who filed in SACS in 2004–05.

FUND

SACS Funds 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.

Charter Schools Filing in SACS   (345 rows)

The CharterFilingSACS table contains information about the Charter Schools who filed in the SACS software in 2004–05.

Report Level: County Office of Education (COE), District, School, State Board

Fund Used: Fund 62, Charter Schools Enterprise Fund; Fund 09, Charter Schools Special Revenue Fund; and Fund 01, General Fund/County School Service Fund

Charter Schools Filing in the Alternative Form  (164 rows)

The CharterFilingAlternativeForm table contains information about the Charter Schools who filed in the Charter Schools Alternative Form in 2004–05.

Charter Schools Not Filing (82 rows)

The CharterNotFiling table contains information about the Charter Schools who did not file unaudited actual financial data in 2004–05.

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 e-mail or by phone as listed below.