Skip to content
Printer-friendly version

File Structure: Class Course Enrollment Record

The table below contains the file structure for the Class Section Enrollment record. A record is created for ever class, class section, grade, and gender category that has student enrolled on Information Day.

File Name: ClassSectionEnroll12.txt

Field Name

Field Type

Width

Description

DistrictCode

Character

7

This 7-digit code is the official, unique identification of a school district or county office within California. The first two digits identify the county and the next five digits identify the school district.

SchoolCode
Character
7 This 7-digit code is the official, unique identification of a school within California.

CountyName

Character

15

County name.

DistrictName

Character

50

District name.

SchoolName

Character

50

School name.

ClassID

Character

20

A unique identifier for a Class assigned by a local educational agency. The Class ID must be unique within a school by Academic Year. A Class ID represents a unique class in a school for an academic year.

A Class is defined as a specific instance where one or more Course Sections are delivered to one or more students by one or more teachers. In most cases, a Class would represent a specific teacher teaching a specific Course Section to a set of students at a specific time at a specific location. In another scenario, a class could represent one teacher teaching multiple Course Sections to groups of students at the same time in the same location.

CourseCode

Character

4

This 4-digit code is from an extensive list of assignment code numbers for teaching assignments. For a list of all codes and course and assignment titles, use the assignment code file posted on the Staff Assignment and Course Data page.

ClassCourseID

Character

10

A unique identifier that identifies a unique instance of a state course code, meets UC/CSU requirements, NCLB Core, NCLB_HQT, Distance learning, special education, independent study, and itinerant teacher status being taught within one class.

GradeLevelCode

Numeric

2

Grade level for the course enrollment reported in this record The field is coded as follows:

  • KN = Kindergarten
  • 01 = 1st Grade
  • 02 = 2nd Grade
  • 03 = 3rd Grade
  • 04 = 4th Grade
  • 05 = 5th Grade
  • 06 = 6th Grade
  • 07 = 7th Grade
  • 08 = 8th Grade
  • 09 = 9th Grade
  • 10 = 10th Grade
  • 11 = 11th Grade
  • 12 = 12th Grade

GenderCode

Numeric

4

The gender for the course enrollment reported in this record The field is coded as follows:

  • M = Male
  • F = Female

EnrollNoEthRpt

Numeric

4

Count of students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE with no ethnicity/race reported.

EnrollAmind

Numeric

4

Count of American Indian or native Alaskan, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollAsian

Numeric

4

Count of Asian, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollPacIsl

Numeric

4

Count of Pacific Islander, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollFilipino

Numeric

4

Count of Filipino, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollHispanic

Numeric

4

Count of Hispanic or Latino students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollAfrAm

Numeric

4

Count of African American, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollWhite

Numeric

4

Count of white, not Hispanic, students enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollTwoOrMore

Numeric

4

Count of students reporting two or more races, not Hispanic, enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollTotal

Numeric

4

Count of all students, enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

EnrollEL

Numeric

4

Count of all English learner students, enrolled in the specified course for the gender specified in GENDER and the grade specified in GRADE.

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