Alternative Form Data Readme File 2014–15
This is a readme file for the 2014–15 Charter School Unaudited Actuals Financial Report-Alternative Form Data.For fiscal year 2014–15, 481 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 alt1415data.exe contains two files: this readme file (alt1415readme.doc) and a Microsoft Access database, alt1415data.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\charteralternativeform1415\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 alt1415data.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 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 |
Decimal (18,2) |
Restricted |
Unrestricted |
Number |
Decimal (18,2) |
Unrestricted |
Total |
Number |
Decimal (18,2) |
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 |
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 |
---|---|---|---|
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 2014–15.
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 |
K12ADA |
Number |
Double |
Average Daily Attendance |
Charter School Reporting Record Counts
Report Type
Alternative Form | SACS | Total Reported | Did not report |
---|---|---|---|
481 |
694 |
1,175 |
14 |
Report Level
County Office of Education (COE) | District | School | State Board |
---|---|---|---|
35 |
519 |
601 |
20 |
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 |
---|---|---|
187 |
189 |
318 |
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.