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.