Skip to main content
California Department of Education Logo

Alternative Form Data Readme File 2009–10

This is a readme file for the 2009–10 Charter School Unaudited Actuals Financial Report-Alternative Form Data.

For fiscal year 2009–10, 318 charter schools in California submitted their year-end unaudited actual (UA) financial data using the Charter School Unaudited Actuals Financial Report—Alternative Form.

The self-extracting zipped file alt0910data.exe contains two files: this readme file (alt0910readme.doc) and a Microsoft Access database, alt0910data.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\charteralternativeform0910\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 page.

The alt0910data.mdb access database contains:

Two Financial Data Tables

  • Alternate_Form_Data
  • Alternate_Form_Totals

Two Look-up Description Tables

  • Object
  • Charters [for fiscal year 2009–10 UA data, this table replaces the three formerly separate tables of charter school information. Charter schools’ Regular Education average daily attendance (ADA) and Special Education ADA are included in this table.]
File Layouts for the Access Database
Alternate_Form_Data

Charter schools information submitted by local educational agencies (LEAs) using the Charter School Alternative Form.

Field

Data Type

Width

Description

Ccode

Text

2

County Code

Dcode

Text

5

District Code

SchoolID

Text

7

School Code

ObjectCode

Text

255

Charter School Alternative Form Object Code

Restricted

Number

Double

Restricted

Unrestricted

Number

Double

Unrestricted

Total

Number

Double

Restricted + Unrestricted


Alternate_Form_Totals

Charter School Alternative Form totals by Object code.

Field

Data Type

Width

Description

Objectcode

Text

255

Charter School Alternative Form Object Code

Restricted

Number

Double

Restricted

Unrestricted

Number

Double

Unrestricted

Total

Number

Double

Restricted + Unrestricted


Look-up Description Tables
Object

SACS Object codes included in the Charter School Alternative Form data.

Field

Data Type

Width

Description

Object

Text

255

Object Code ID

Description

Text

255

Object Description


Charters  

The Charters table contains information about the Charter Schools that filed in SACS, that filed in the charter Alternative Form, and that did not file year-end unaudited actual financial data for fiscal year 2009–10.

Field Name

Data Type

Width

Description

Ccode

Text

2

County Code

Dcode

Text

5

District Code

SchoolID

Text

7

School Code

CharterNumber

Text

10

Charter Number

CharterName

Text

100

Charter Name

ReportType

Text

100

Report Type

ReportLevel

Text

30

Report Level

FundUsed

Text

30

Fund Used

RegularADA

Number

Double

Regular Education Average Daily Attendance

SpecialEdADA

Number

Double

Special Education Average Daily Attendance


Charter School Reporting Record Counts
Report Type

Alternative Form

SACS

Total Reported

Did not report

318

496

814

15

Report Level

County Office of Education (COE)

District

School

28

377

409

Fund Used in SACS

General Fund/County School Service Fund (Fund 01) Used

Charter Schools Special Revenue Fund (Fund 09) Used

Charter Schools Enterprise Fund (Fund 62) Used

98

189

209


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.

Questions:   Financial Accountability & Information Services| sacsinfo@cde.ca.gov | 916-322-1770
Last Reviewed: Friday, February 17, 2017
Recently Posted in Financial