Alternative Form Data Readme File 2012–13
This is a readme file for the 2012–13 Charter School Unaudited Actuals Financial Report-Alternative Form Data.For fiscal year 2012–13, 431 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 alt1213data.exe contains two files: this readme file (alt1213readme.doc) and a Microsoft Access database, alt1213data.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\charteralternativeform1213\data. (You can change the extract directory.)
For more information related to the Standardized Account Code Structure (SACS) financial software, visit the SACS Web page.
The alt1213data.mdb Access database contains:
Two Financial Data Tables
- Alternate_Form_Data
- Alternate_Form_Totals
Two Look-up Description Tables
- Object
- Charters [includes charter schools’ Regular Education average daily attendance (ADA) and Special Education 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 |
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 School Alternative Form, and that did not file year-end unaudited actual financial data for fiscal year 2012–13.
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 |
---|---|---|---|
431 |
639 |
1070 |
26 |
Report Level
County Office of Education (COE) | District | School | State Board |
---|---|---|---|
33 |
487 |
518 |
32 |
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 |
---|---|---|
170 |
185 |
284 |
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.