Alternative Form Data Readme File 2023–24
This is a readme file for the 2023–24 Charter School Unaudited Actuals Financial—Alternative Form Data.For fiscal year 2023–24, 572 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 alt2324data.exe contains two files: this readme file (alt2324readme.docx) and a Microsoft Access database, alt2324data.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\charteralternativeform2324\data. (Can change the extract directory.)
For more information related to the Standardized Account Code Structure (SACS), visit the California Department of Education's (CDE) SACS web page.
The alt2324data.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’ financial data 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 |
| SchoolCode | Text | 7 | School Code |
| Fiscalyear | Text | 4 | Fiscal Year |
| 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 |
Alternative_form_Totals
Charter School Alternative Form totals by Object code.
| Field | Data Type | Width | Description |
|---|---|---|---|
| Fiscalyear | Text | 4 | Fiscal Year |
| 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 |
|---|---|---|---|
| FiscalYear | Text | 4 | Fiscal Year |
| 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 for fiscal year 2023–24.
| Field Name | Data Type | Width | Description |
|---|---|---|---|
| Ccode | Text | 2 | County Code |
| Dcode | Text | 5 | District Code |
| SchoolCode | 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 |
|---|---|---|---|
| 572 | 708 | 1280 | 5 |
Report Level
| Report Level | SACS | Alternative Form | Total |
|---|---|---|---|
| County Office of Education | 36 | 0 | 36 |
| District | 281 | 0 | 281 |
| School | 390 | 546 | 936 |
| State Board | 1 | 26 | 27 |
Fund Used in SACS
| Fund Used | With Authorizer | Separately Reported | Total |
|---|---|---|---|
| General Fund/County School Service Fund (Fund 01) | 148 | 36 | 184 |
| Charter Schools Special Revenue Fund (Fund 09) | 166 | 0 | 166 |
| Charter Schools Enterprise Fund (Fund 62) | 3 | 355 | 358 |