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 e-mail or by phone as listed below.
