Skip to main content
California Department of Education Logo

Alternative Form Data Readme File 2004–05

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

In fiscal year 2004–05, 164 charter schools in California submitted their unaudited actual financial data using the Charter School Unaudited Actuals Financial Report-Alternative Form.

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

The alt0405data.mdb access database contains:

Two Data Tables

  • alternative_form_data
  • alternative_form_totals

Four Look-up Description Tables

  • Object
  • CharterFilingAlternativeForm
  • CharterFilingSACS
  • CharterNotFiling
File layouts for the Access database
Alternative_Form_Data

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

Field

Data Type

Width

Description

Ccode

Character

255

County Code

Dcode

Character

255

District Code

Schoolid

Character

255

School Code

Objectcode

Character

255

Charter School Alternative Form Object Code

Restricted

Double

4

Restricted

Unrestricted

Double

4

Unrestricted

Total

Double

4

Restricted + Unrestricted


Alternative_Form_Totals

Charter School Alternative Form totals by object code.

Field

Data Type

Width

Description

Objectcode

Character

255

Charter School Alternative Form Object Code

Restricted

Double

4

Restricted

Unrestricted

Double

4

Unrestricted

Total

Double

4

Restricted + Unrestricted


Look-up Description Tables
Object

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

Field

Data Type

Width

Description

Object

Character

255

Object Code ID

Description

Character

255

Object Description


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.

Field Name

Data Type

Width

Description

Ccode

Character

2

County Code

Dcode

Character

5

District Code

SchoolID

Character

7

School Code

CharterNumber

Character

10

Charter Number

CharterName

Character

50

Charter Name

ReportLevel

Character

30

Report Level


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.

Field Name

Data Type

Width

Description

Ccode

Character

2

County Code

Dcode

Character

5

District Code

SchoolID

Character

7

School Code

CharterNumber

Character

10

Charter Number

CharterName

Character

50

Charter Name

ReportLevel

Character

30

Report Level

FundUsed

Character

30

Fund Used


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 Not Filing (82 rows)

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

Field Name

Data Type

Width

Description

Ccode

Character

2

County Code

Dcode

Character

5

District Code

SchoolID

Character

7

School Code

CharterNumber

Character

10

Charter Number

CharterName

Character

50

Charter Name



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