J-200 Readme File 1995–04
This is a readme file for the 1995–04 J-Series Data Files (J-200 Unaudited Actual).The self extracting zip file j200archive.exe contains one file: A Microsoft Access Database, j200archive.accdb. When executed, the file is extracted onto your PC into the default directory c:\j200archive.(You can change the extract directory.)
File Layouts for the Access Database
Funds
| Field | Data Type | Width | Description |
|---|---|---|---|
FundCode |
Text |
3 |
Fund Code |
FiscalYear |
Text |
4 |
Fiscal Year |
FundDescription |
Text |
43 |
Fund Description |
J200
| Field | Data Type | Width | Description |
|---|---|---|---|
FiscalYear |
Text |
4 |
Fiscal Year |
LEAID |
Text |
5 |
LEA ID |
SchoolID |
Text |
7 |
School ID |
fund_num |
Text |
3 |
Fund Number |
obj_code |
Text |
4 |
Object Code |
unrestricted |
Text |
11 |
Unrestricted |
restricted |
Text |
11 |
Restricted |
tot_fund |
Text |
11 |
Total Fund |
LEA
| Field Name | Data Type | Width | Description |
|---|---|---|---|
LEAID |
Text |
5 |
LEA ID |
FiscalYear |
Text |
4 |
Fiscal Year |
CCode |
Text |
2 |
County Code |
LEAName |
Text |
41 |
LEA Name |
| LEAType | Text | 13 | LEA Type |
| regADA | Number | 6 | Regular ADA |
| specED | Number | 5 | Special Education ADA |
| ROCP | Number | 5 | Regional Occupation Center Program ADA |
| AdultED | Number | 5 | Adult Education ADA |
Object Codes
| Field | Data Type | Width | Description |
|---|---|---|---|
ObjectCode |
Text |
4 |
Object Code |
FiscalYear |
Text |
4 |
Fiscal Year |
| ObjectDescription | Text | 62 | Object Description |
School
| Field | Data Type | Width | Description |
|---|---|---|---|
ccode |
Text |
2 |
County Code |
leaid |
Text |
5 |
LEA ID |
| schoolID | Text | 7 | School ID |
| schoolName | Text | 39 | School 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 email or by phone as listed below.