File Modifications

18-Nov-2008 and subsequent postings

The following data were removed from the downloadable public schools files:

• ASM_DIST - Number of the California Assembly district in which this school is located.
• ASM_MEM - Name of the California Assembly member for the district in which this school is located.
• ASM_PRTY - Political party affiliation of this Assembly member.
• SEN_DIST - Number of the California Senate district in which this school is located.
• SEN_MEM - Name of the California Senate member for the district in which this school is located.
• SEN_PRTY - Political party affiliation of this Senate member.
• CON_DIST - Number of the U.S. congressional district in which this school is located.
• CON_MEM - Name of the U.S. congressional member for the district in which this school is located.
• CON_PRTY - Political party affiliation of this U. S. congressional member.

These fields will be replaced with a filler, so the file length will not change.

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.

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."