Language Census File Layout 2008
The Language Census Data Entry Assistant software will accept a single file containing all four record types. The supported file formats are comma delimited, tab delimited, or fixed layout. Comma delimited files have a comma separating each field, and all character fields are enclosed in double quotes ("). Tab delimited files have a tab character separating each field, and all character fields are enclosed in double quotes (").
Note: To print the file layout, you should set your printer to landscape.
Changes to 2008: Fillers removed and fields renamed.
Record Types: The Language Census data layout includes four record types.
Record Type A – All data except for part 1 and part 5.A. One record for every school in the district.
Record Type B – Part 1 English learner (EL) and fluent-English-proficient (FEP) data. One record for every school, language, and EL or FEP combination where there are students.
Record Type C – Teachers providing primary language instruction and bilingual paraprofessionals (Part 5.A). One record for every school and language where there are teachers and/or paraprofessionals providing services to English learners.
Record Type D – District contact and certification data. One record for the district.
Record Type A – All data except for part 1 and part 5.A
Note: One record for every school in the district.
Item |
Field Name |
Type |
Width |
Position |
Description |
Source Location |
|---|---|---|---|---|---|---|
1 |
SOURCE |
Character |
4 |
1-4 |
Source of data. “LCEN” for Language Census. |
NA |
2 |
YEAR |
Character |
2 |
5-6 |
Year of data. “08” for 2008. |
NA |
3 |
REC_TYPE |
Character |
1 |
7 |
Record type A = All data except for part 1 and part 5.a. |
NA |
4 |
CDS_CODE |
Character |
14 |
8-21 |
County-District-School code assigned by the California Department of Education (CDE). |
Page 1 |
5 |
SUB_OPTION |
Character |
1 |
22 |
Submission options. “1” No EL/FEP in school, “2” EL and/or FEP in school. |
Page 1 |
6 |
SETENGIMM |
Numeric |
6 |
23-28 |
Count of students enrolled in structured English immersion. |
Page 3, Part 2.A, Row 3 |
| 7 | SRVELD |
Numeric |
6 |
29-34 |
Count of students receiving English language development (ELD). |
Page 3, Part 2.B, Row 4 |
| 8 | SRV_SANDE |
Numeric |
6 |
35-40 | Count of students receiving ELD & specially designed academic instruction in English (SDAIE). |
Page 3, Part 2.B, Row 5 |
| 9 | SRVP1SUP |
Numeric |
6 |
41-46 | Count of students receiving ELD & SDAIE with primary language support. |
Page 3, Part 2.B, Row 6 |
| 10 | SRVP1 |
Numeric |
6 |
47-52 | Count of students receiving ELD and academic subjects through the primary language. |
Page 3, Part 2.B, Row 7 |
| 11 | SRVOTH |
Numeric |
6 |
53-58 | Count of students receiving other instructional service. |
Page 3, Part 2.B, Row 8 |
| 12 | SRVNONE |
Numeric |
6 |
59-64 | Count of students not receiving EL services. |
Page 3, Part 2.B, Row 9 |
| 13 | REDESIG |
Numeric |
6 |
65-70 | Count of EL students reclassified as FEP. |
Page 3, Part 3, Row 11 |
| 14 | SDAIE_ELD |
Numeric |
6 |
71-76 | Count of teachers with California Commission on Teacher Credentialing (CCTC) Crosscultural Language and Academic Development (CLAD) or equivalent providing SDAIE and ELD. |
Page 4, Part 5.B, Row 23 |
| 15 | SDAIE_ONLY |
Numeric |
6 |
77-82 | Count of teachers with CCTC CLAD or equivalent providing SDAIE only. |
Page 4, Part 5.B, Row 24 |
| 16 | ELD_ONLY |
Numeric |
6 |
83-88 | Count of teachers with CCTC CLAD or equivalent providing ELD only. |
Page 4, Part 5.B, Row 25 |
| 17 | PARWAIVREQ |
Numeric |
6 |
89-94 | Parental exception waivers requested (granted or denied). |
Page 3, Part 4, Row 12 |
| 18 | PARWAIVGRNT |
Numeric |
6 |
95-100 | Parental exception waivers granted. |
Page 3, Part 4, Row 13 |
| 19 | TRAV_TEACH |
Logical |
1 |
101 | Teachers counted at another school, not at this school. |
Page 4, Part 5 |
| 20 | AUTH_NOTCH |
Logical |
1 |
102 | Teachers with EL authorizations, but not providing EL services. |
Page 4, Part 5 |
Record Type B – Part 1 English learner (EL) and fluent-English-proficient (FEP) data
Note: One record for every school, language, and EL or FEP combination where there are students. Internal field names are the same as indicated in the field name column for the following table.
Item |
Field Name |
Type |
Width |
Position |
Description |
Source Location |
|---|---|---|---|---|---|---|
1 |
SOURCE |
Character |
4 |
1-4 |
Source of data. “LCEN” for Language Census. |
NA |
2 |
YEAR |
Character |
2 |
5-6 |
Year of data. “08” for 2008. |
NA |
3 |
REC_TYPE |
Character |
1 |
7 |
Record type B = Part 1 EL and FEP data. |
NA |
4 |
CDS_CODE |
Character |
14 |
8-21 |
County-District-School code assigned by the CDE. |
Page 2 |
5 |
LC |
Character |
2 |
22-23 |
Language code – See R30-LC form for valid codes. |
Page 1, Part 1, Column b |
6 |
TYPE |
Character |
3 |
24-26 |
Type. “EL” for English learner or “FEP” for fluent-English-proficient. |
Page 1, Part 1, Column c |
7 |
KINDER |
Numeric |
6 |
27-32 |
Count of kindergarten students. |
Page 1, Part 1, Column d |
8 |
GRADE01 |
Numeric |
6 |
33-38 |
Count of grade one students. |
Page 1, Part 1, Column e |
9 |
GRADE02 |
Numeric |
6 |
39-44 |
Count of grade two students. |
Page 1, Part 1, Column f |
10 |
GRADE03 |
Numeric |
6 |
45-50 |
Count of grade three students. |
Page 1, Part 1, Column g |
11 |
GRADE04 |
Numeric |
6 |
51-56 |
Count of grade four students. |
Page 1, Part 1, Column h |
12 |
GRADE05 |
Numeric |
6 |
57-62 |
Count of grade five students. |
Page 1, Part 1, Column i |
13 |
GRADE06 |
Numeric |
6 |
63-68 |
Count of grade six students. |
Page 1, Part 1, Column j |
14 |
GRADE07 |
Numeric |
6 |
69-74 |
Count of grade seven students. |
Page 1, Part 1, Column k |
15 |
GRADE08 |
Numeric |
6 |
75-80 |
Count of grade eight students. |
Page 1, Part 1, Column l |
16 |
GRADE09 |
Numeric |
6 |
81-86 |
Count of grade nine students. |
Page 1, Part 1, Column m |
17 |
GRADE10 |
Numeric |
6 |
87-92 |
Count of grade ten students. |
Page 1, Part 1, Column n |
18 |
GRADE11 |
Numeric |
6 |
93-98 |
Count of grade eleven students. |
Page 1, Part 1, Column o |
19 |
GRADE12 |
Numeric |
6 |
99-104 |
Count of grade twelve students. |
Page 1, Part 1, Column p |
20 |
UNGRADED |
Numeric |
6 |
105-110 |
Count of ungraded students. |
Page 1, Part 1, Column q |
Record Type C – Teachers providing primary language instruction to ELs and bilingual paraprofessionals providing services to ELs (Part 5.A)
Note: One record for every school and language where there are teachers and/or paraprofessionals providing services to ELs.
Item |
Field Name |
Type |
Width |
Position |
Description |
Source Location |
|---|---|---|---|---|---|---|
1 |
SOURCE |
Character |
4 |
1-4 |
Source of data. “LCEN” for Language Census. |
NA |
2 |
YEAR |
Character |
2 |
5-6 |
Year of data. “08” for 2008. |
NA |
3 |
REC_TYPE |
Character |
1 |
7 |
Record type C = Part 5.A data. |
NA |
4 |
CDS_CODE |
Character |
14 |
8-21 |
County-District-School code assigned by the CDE. |
Page 4 |
5 |
LC |
Character |
2 |
22-23 |
Language Code – See R30-LC form for valid codes. |
Page 4. Part 5.A, Column a |
6 |
CTC |
Numeric |
6 |
24-29 |
Number of teachers providing primary language instruction with a CCTC bilingual authorization. |
Page 4. Part 5.A, Column b |
7 |
AIDES |
Numeric |
6 |
30-35 |
Number of paraprofessionals/aides providing services to English learners. |
Page 4. Part 5.A, Column d |
Record Type D – District contact and certification of data
Note: One record for the district. Internal field names are the same as indicated in the field name column for the following table.
Item |
Field Name |
Type |
Width |
Position |
Description |
Source Location |
|---|---|---|---|---|---|---|
1 |
SOURCE |
Character |
4 |
1-4 |
Source of data. “LCEN” for Language Census. |
NA |
2 |
YEAR |
Character |
2 |
5-6 |
Year of data. “08” for 2008. |
NA |
3 |
REC_TYPE |
Character |
1 |
7 |
Record type D = District-level contact and certification information one record per district. |
NA |
4 |
CD_CODE |
Character |
7 |
8-14 |
County and district code assigned by the CDE. |
Page 1 |
5 |
CON_NAME |
Character |
30 |
15-44 |
Contact name. |
Page 1 |
6 |
CON_PHONE |
Character |
14 |
45-58 |
Contact phone. |
Page 1 |
7 |
CERT_NAME |
Character |
30 |
59-88 |
Name of person certifying the data. |
Page 1 |
8 |
CERT_TITLE |
Character |
50 |
89-138 |
Title of person certifying the data. |
Page 1 |