Skip to main content
California Department of Education Logo

Alternative Form Data Readme File 2018–19

This is a readme file for the 2018–19 Charter School Unaudited Actuals Financial—Alternative Form Data.

For fiscal year 2018–19, 759 charter schools in California submitted their year-end unaudited actual (UA) financial data using the Charter School Unaudited Actuals Financial Report—Alternative Form, sometimes referred to as the “Charter Alt Form.”

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

For more information related to the Charter School Unaudited Actuals Financial Report—Alternative Form, visit the California Department of Education’s (CDE’s) Charter School Alternative Form web page. For more information related to the Standardized Account Code Structure (SACS), visit the CDE’s SACS web page.

The alt1819data.mdb Access database contains:

Two Financial Data Tables

  • Alternate_Form_Data
  • Alternate_Form_Totals

Two Look-up Description Tables

  • Object
  • Charters [includes charter schools’ K–12 average daily attendance (ADA)]
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

Decimal (18,2)

Restricted

Unrestricted

Number

Decimal (18,2)

Unrestricted

Total

Number

Decimal (18,2)

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

Decimal (18,2)

Restricted

Unrestricted

Number

Decimal (18,2)

Unrestricted

Total

Number

Decimal (18,2)

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 using either SACS or the Charter School Alternative Form (sometimes called the Charter Alt Form), as well as those that did not file year-end unaudited actual financial data for fiscal year 2018–19.

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

K12ADA

Number

Double

Average Daily Attendance


Charter School Reporting Record Counts
Report Type
Alternative Form SACS Total Reported Did not report
759
538
1297
25

Report Level
Report Level SACS Alternative Form Total
County Office of Education (COE)
43
0
43
District
302
0
310
School
192
724
916
State Board
1
35
36

Fund Used in SACS
Fund Used With Authorizer Separately Reported Total
General Fund/County School Service Fund (Fund 01)
156
31
187
Charter Schools Special Revenue Fund (Fund 09)
186
0
186
Charter Schools Enterprise Fund (Fund 62)
4
161
165


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.

Questions:   Financial Accountability & Information Services | sacsinfo@cde.ca.gov | 916-322-1770
Last Reviewed: Monday, June 24, 2024