Skip to content
Printer-friendly version

File Modifications

File modifications for data files pertaining to student demographics, data about schools and districts, and staffing data.

Date Modified and Posted

Files

Description of Change

19-Dec-2012

elsch12.txt
fepsch12.txt

Removed extra columns (KGDN1 and KGDN2), renamed the column headings to match the file layout, added a county column, and updated the District column to include the district name for some charter schools, which previously listed the charter's name. The total counts did not change.

12-Dec-2012

elsch02.txt

Combined data for a duplicate row of data for one school. Totals did not change. Also posted as a text file rather than an executable. file.

04-Oct-2012

cbedsora11b.txt

File was modified to roll up the counts of Estimated Teacher Hires to the district level. Originally the file contained one row for the district and one row for independently reporting charter schools (if applicable).

17-Aug-2012

grad02.txt
gradaf02.txt

Data were modified after certification.

16-Mar-2012

assign10.txt

File was updated to include the distance learning, special education, independent study, and itinerant teacher fields.

13-Mar-2012

cohort09.txt

Original file did not include district level summaries by gender for all subgroups.

18-Jan-2012

elsch11.txt

Data were revised to remove some uncertified independently reporting charter school's data from state totals.

18-Mar-2011

grad06.txt
gradaf06.txt
grad04.txt
gradaf04.txt
grad03.txt
gradaf03.txt

Data were modified after certification.

15-Mar-2011

grad05.txt
gradaf05.txt

The original files contained the 2004-05 data, rather than the 2005-06 data. Also, data were modified after certification.

5-Nov-2010

paif09.txt

In the original file, records that did not indicate a race were included in the race category "Code 8 - Two or More Races, Not Hispanic." Now these records are reported separately under the category "Code 0 - Not Reported."

25-Feb-2010

elsch09.dbf

Due to a processing error with one district, data were corrected and re-posted.

25-Feb-2010

fepsch09.dbf

Due to a processing error with one district, data were corrected and re-posted.

25-Feb-2010

lc09p2_4.dbf

Due to a processing error with one district, data were corrected and re-posted.

5-Feb-2010

prcert08.txt

Corrections were made to the credential information.

5-Feb-2010

tchcrd08.txt

Corrections were made to the credential information.

2-Feb-2010

assign08.dbf

Corrections were made to the credential information.

2-Feb-2010

paif08.dbf

Corrections were made to the credential information.

3-Dec-2009

cbedsopus08a.txt

The original file was generated incorrectly and missing records.

11-May-2009

lc07p2_4.dbf

The original file was generated incorrectly and missing records.

6-May-2009

lcstf07s.dbf

This file was originally generated incorrectly. In regenerating the file, it was also discovered that data for nonpublic nonsectarian schools were reported for three districts and should not have been. As a result of removing this data, the statewide count of English learner teachers was reduced by two and the count of bilingual paraprofessionals was reduced by nine.

2-Mar-2009

paif06.dbf

The "TEACH" field was originally posted as a logical type field, when it should have been posted as a character type field.

27-Jan-2009

assign07.dbf

The original file was posted with some limited number of records having invalid values in the "NCLB_CORE" and "NCLB_HQT" fields. These values were adjusted to reflect valid values.

18-Jul-2008

elsch07.dbf

The 2007 Language Census certified file was updated due to a CDE data processing error for data reported by San Francisco County Office of Education. The 2007 Language Census data files were also incorrectly generated.

18-Jul-2008

fepsch07.dbf

The 2007 Language Census certified file was updated due to a CDE data processing error for data reported by San Francisco County Office of Education. The 2007 Language Census data files were also incorrectly generated.

4-Aug-2005

paif04.exe

Resolved Rec_Id duplication issue. This file modification has resulted in five fewer teachers (statewide).

4-Aug-2005

assign04.exe

Resolved Rec_Id duplication issue. Only the Rec_Id field was modified from the prior release of this file.

29-July-2003

paifa02.exe

One hundred and nine records were added as a result of the records being identified as teaching assignments of staff that were reported in the Professional Assignment Information Form (they were initially mislabeled as distance learning courses).

31-Dec-2002

paifa01.exe

(12/31/02) Missing records were added to file.
(08/02/02) The "Rec_Id" field was renumbered to rid duplicate numbers.

31-Dec-2002

paifc01.exe

(12/31/02) Missing records were added to file.
(08/02/02) The "ctype" field was removed. All records are teaching assignments.

31-Dec-2002

paift01.exe

(12/31/02) Missing records were added to file.
(09/27/02) Data in the ethnic designations fields were updated. The update reduced the number of individuals who reported multiple ethnicities in the following school districts (identified by County-District Code): 1563529; 1964840; 1973445; 3066522; 3367249; 3768338; 4369369; and 4369666.
(08/02/02) The "rec_id" field was renumbered to rid duplicate numbers. "FTE_T", "FTE_A", and "FTE_P" were corrected as well.

31-Dec-2002

All 2001 Language Census Files

The 2001 Language Census Data files have been updated. Unedited data from some of California Youth Authority (CYA) schools were inadvertently included in the 2001 data. According to legal advice, we are not collecting language census data from CYA schools. Therefore, we have removed the partial data for these schools and have reposted the Language Census data.

26-Dec-2001

lc01p2_4.exe

The number of English Learners (EL) redesignated as Fluent-English Proficient (FEP) students has been updated.

2-Aug-2001

paif0001.exe

"7" has been replaced with " " (empty string) in the ED_LEVEL field. An unpopulated cell (formerly "7" in the ED_LEVEL) represents unreported data.

24-Jan-2001

sifg_k99.exe

Added two columns of data for each school - school-based health center and school-linked health center. These two columns of data represent Section K of the School Information Form (SIF). Accordingly, the file name was changed from "sifg_j99.exe" to "sifg_k99.exe."

24-Jan-2001

sifg_k99.exe

Changed schools that did not indicate type of calendar year to "traditional calendar year." This is consistent with instructions for completing the form that indicate "If your school does not complete this section, we will assume that your school is on a traditional calendar."

Questions: Data Reporting Office | dro@cde.ca.gov | 916-327-0219 
Download Free Readers