Alternative Form Data Readme File 2008–09
This is a readme file for the 2008–09 Charter School Unaudited Actuals Financial Report-Alternative Form Data.In fiscal year 2008–09, 290 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 alt0809data.exe contains two files: this readme file (alt0809readme.doc) and a Microsoft Access database, alt0809data.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\charteralternativeform0809\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 alt0809data.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 |
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 |
Alternative_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 |
Charter Schools Filing in the Alternative Form (290 rows)
The CharterFilingAlternativeForm table contains information about the Charter Schools who filed in the Charter Schools Alternative Form in 2008–09.
| 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 |
ReportLevel |
Text |
30 |
Report Level |
FundUsed |
Text |
30 |
Fund Used |
Charter Schools Filing in SACS (453 rows)
The CharterFilingSACS table contains information about the Charter Schools who filed in the SACS software in 2008–09.
| 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 |
ReportLevel |
Text |
30 |
Report Level |
FundUsed |
Text |
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 (27 rows)
The CharterNotFiling table contains information about the Charter Schools who did not file unaudited actual financial data in 2008–09.
| 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 |
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.