SACS Readme File 2006–07
This is a readme file for the 2006–07 Standardized Account Code Structure (SACS) Unaudited Actual Financial Data.In fiscal year 2006–07, 1,469 local educational agencies (LEAs) (1,026 districts, 385 charter schools, and 58 county offices of education) in California submitted their financial data using the standardized account code structure.
The self-extracting zipped file sacs0607.exe contains two files: this readme file and a Microsoft Access database, sacs0607.mdb. When executed, the files are extracted onto your PC into the default subdirectory C:\0607SACS\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.
Notes:
- We rolled the data in Fund 03 (General Fund Unrestricted) and Fund 06 (General Fund Restricted) into Fund 01 (General Fund/County School Service Fund).
- We have the county and state totals in a separate table: UserGL_Totals.
- There are three tables for Charter School information: CharterFilingSACS, CharterFilingAlternativeForm, and CharterNotFiling.
File layouts for the Access database
USERGL
General ledger information submitted by LEAs that have a SACS based accounting system.
| Field | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
SchoolCode |
Character |
7 |
School Code |
Fiscalyear |
Character |
4 |
Fiscal Year |
Period |
Character |
4 |
Report Period Identifier (‘A’) = Unaudited Actual |
Colcode |
Character |
4 |
Column Code Identifier ('BA') = Unaudited Actual |
Account |
Character |
19 |
SACS Account Code |
Fund |
Character |
2 |
SACS Fund Code |
Resource |
Character |
4 |
SACS Resource Code |
Projectyear |
Character |
1 |
Project Year (for federally funded projects) |
Goal |
Character |
4 |
SACS Goal |
Function |
Character |
4 |
SACS Function |
Object |
Character |
4 |
SACS Object Code |
Value |
Double |
N/A |
Amount |
USERGL_TOTALS
General ledger information submitted by LEAs that have a SACS based accounting system. Totals are by counties and state. Ccode and Dcode (“999” + Ccode) identify the counties subtotals. Ccode of “99” and Dcode of “99999” identify the state totals.
| Field | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
Fiscalyear |
Character |
4 |
Fiscal Year |
| Period | Character | 4 | Report Period Identifier ('A') = Unaudited Actual |
Colcode |
Character |
4 |
Column Code Identifier ('BA') = Unaudited Actual |
| Account | Character | 19 | SACS Account Code |
| Fund | Character | 2 | SACS Fund Code |
Resource |
Character |
4 |
SACS Resource Code |
Projectyear |
Character |
1 |
Project Year (for federally funded projects) |
Goal |
Character |
4 |
SACS Goal |
Function |
Character |
4 |
SACS Function |
Object |
Character |
4 |
SACS Object Code |
Value |
Double |
N/A |
Amount |
Look-up Description Tables
LEAs
Information on county offices of education, common administrative districts, joint powers agencies, and elementary, high, and unified school districts who filed in SACS in 2006–07.
| Field Name | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
Dname |
Character |
55 |
District Name |
Dtype |
Character |
15 |
District Type |
RegularADA |
Number |
N/A |
Regular Average Daily Attendance |
SpecialEdADA |
Number |
N/A |
Special Education Average Daily Attendance |
ROCPADA |
Number |
N/A |
Regional Occupation Center/Program Average Daily Attendance |
AdultEdADA |
Number |
N/A |
Adult Education Average Daily Attendance |
FUND
SACS Funds included in the USERGL data.
| Field | Data Type | Width | Description |
|---|---|---|---|
Code |
Character |
4 |
Fund Code ID |
Title |
Character |
250 |
Fund Description |
RESOURCE
SACS Resource codes included in the USERGL data.
| Field | Data Type | Width | Description |
|---|---|---|---|
Code |
Character |
4 |
Resource Code ID |
Title |
Character |
250 |
Resource Description |
GOAL
SACS Goal codes included in the USERGL data.
| Field | Data Type | Width | Description |
|---|---|---|---|
Code |
Character |
4 |
Goal Code ID |
Title |
Character |
250 |
Goal Description |
FUNCTION
SACS Function codes included in the USERGL data.
| Field | Data Type | Width | Description |
|---|---|---|---|
Code |
Character |
4 |
Function Code ID |
Title |
Character |
250 |
Function Description |
OBJECT
SACS Object codes included in the USERGL data.
| Field | Data Type | Width | Description |
|---|---|---|---|
Code |
Character |
4 |
Object Code ID |
Title |
Character |
250 |
Object Description |
Charter Schools Filing in SACS (385 rows)
The CharterFilingSACS table contains information about the Charter Schools who filed in the SACS software in 2006–07.
| Field Name | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
SchoolID |
Character |
7 |
School Code |
CharterNumber |
Character |
10 |
Charter Number |
CharterName |
Character |
100 |
Charter Name |
ReportLevel |
Character |
30 |
Report Level |
FundUsed |
Character |
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 Filing in the Alternative Form (232 rows)
The CharterFilingAlternativeForm table contains information about the Charter Schools who filed in the Charter Schools Alternative Form in 2006–07.
| Field Name | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
SchoolID |
Character |
7 |
School Code |
CharterNumber |
Character |
10 |
Charter Number |
CharterName |
Character |
100 |
Charter Name |
ReportLevel |
Character |
30 |
Report Level |
FundUsed |
Character |
30 |
Fund Used |
Charter Schools Not Filing (13 rows)
The CharterNotFiling table contains information about the Charter Schools who did not file unaudited actual financial data in 2006–07.
| Field Name | Data Type | Width | Description |
|---|---|---|---|
Ccode |
Character |
2 |
County Code |
Dcode |
Character |
5 |
District Code |
SchoolID |
Character |
7 |
School Code |
CharterNumber |
Character |
10 |
Charter Number |
CharterName |
Character |
100 |
Charter Name |
ReportLevel |
Character |
30 |
Report Level |
FundUsed |
Character |
30 |
Fund Used |
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.