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.