Skip to main content
California Department of Education Logo

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.

Questions:   Financial Accountability & Information Services | sacsinfo@cde.ca.gov | 916-322-1770
Last Reviewed: Thursday, October 10, 2019