File Modifications
File modifications for the California Longitudinal Pupil Achievement Data System (CALPADS), California Basic Educational Data System (CBEDS), and the Public Schools downloadable data files.| Date Modified and Posted | Files | Description of Change |
|---|---|---|
| 21-Jul-2014 | cohort13.txt | 2012–13 cohort outcome data were updated. |
| 13-Mar-2013 | enr09.txt | Minor updates were made to the 2009–10 enrollment data. |
| 12-Mar-2103 | cohort10.txt | 2010–11 cohort outcome data were updated. |
| 19-Dec-2012 | elsch12.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 |
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." |
| 7-May-2010 | pubschls.dbf |
These files were modified significantly. Many elements have been removed or changed, and new elements have been added. For details on specific changes, please refer to the Changes to the Public Schools File web page. |
| 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-Nov-2008 and subsequent postings |
pubschls.txt pubschls.dfb pubschls.xls |
The following data were removed from the downloadable public schools files:
These fields will be replaced with a filler, so the file length will not change. |
| 18-Jul-2008 | elsch07.dbf | The 2007 Language Census certified file was updated due to a California Department of Education (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. |
| 31-Dec-2002 |
paifc01.exe |
(12/31/02)
Missing records were added to file. |
| 31-Dec-2002 |
paift01.exe |
(12/31/02)
Missing records were added to file. |
| 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. |
| 1-June-2001 and subsequent postings |
pubschls.exe |
The grade span field no longer represents the range of grades that each school supports. The grade span field is now the lowest grade and the highest grade in which student enrollment was reported in the most recent certified CBEDS data. The grade span field name has changed from "gr_span" to "grd_span." |
| 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." |