Skip to content
Printer-friendly version

File Structure: Courses Taught Record

This table below contains the structure for the Class Section record. One record is created for every school, class, and class section that has students enrolled on Information Day.

File Name: ClassCourse.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 Web 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.
UC CSU Approved Numeric 1

Course designated as meeting the University of California (UC) / California State University (CSU) requirements for admission. This field is coded as follows:

  • Y = Yes
  • N = No
  • Blank = No response
NCLB Core Character 1

This field indicates whether or not this class is a core academic class under No Child Left Behind (NCLB). The field is coded as follows:

  • Y = Yes
  • N = No
  • Blank = Field is not relative to the assignment
NCLB HQT Character 1

This field indicates whether or not a teacher is NCLB compliant to teach the course. The field is coded as follows:

  • A = Compliant on the basis of passage of an approved exam
  • B = Compliant on the basis of coursework
  • C = Compliant on the basis of of national board certification
  • D = Compliant on the basis of High Objective Uniform State Standard Evaluation (HOUSSE)
  • G = Compliant on the basis of the Subject Matter Verification Process for Middle and High School Level Teachers in Special Settings (VPSS) option
  • N = Not NCLB compliant
  • Blank = Field is not relative to the assignment
DistanceLearning Character 1

This field indicates whether or not this class is taught through distance learning. The field is coded as follows:

  • Y = Yes
  • N = No
  • Blank = No/Not Applicable
IndependentStudy Character 1

This field indicates whether or not this class is an independent study class. The field is coded as follows:

  • Y = Yes
  • N = No
  • Blank = No/Not Applicable
MultipleTeacherCode Character 1

This field indicates whether or not this class is taught by an itinerant teacher. The field is coded as follows:

  • Y = Yes
  • N = No
  • Blank = No/Not Applicable
CTE_FundingProvider Character 1

The Career Technical Education course is provided by the Regional Occupational Center or Program (ROC/P).

The Career Technical Education course is provided by the district.

  • 1 = The Career Technical Education course is provided by the Regional Occupational Center or Program (ROC/P).
  • 2 = Career Technical Education course is provided by the district.
  • Blank = No/Not Applicable
Enrollment Numeric 4 Total enrollment in this class or course. For more detailed enrollment data (by gender and ethnicity), see the downloadable file for  Class Section Enrollment Record Data
SEID Indicator Character 1

This SEID (Statewide Educator Identifier) Indicator specifies whether or not there are staff-level data available for a specific class/course in the StaffDemographics, StaffAssignment, and StaffSchoolFTE data-sets.

  • Y = Yes, staff-level data are available for this class/course
  • N = No, staff-level data are not available for this class/course
  • Blank = Not Applicable

Note that LEAs are not required to submit demographic and FTE information for staff that do not have a Statewide Education Identifier (SEID). Following are examples of when this might occur:

  • Non-certificated charter school teachers.
  • Teachers delivering courses at a Regional Occupational Center.
  • College professors delivering college courses to high school students.
  • Teachers delivering online courses provided by a public or private agency.
  • New teachers who have not been issued a SEID.

Therefore course and course enrollment data will be available for these types of classes, but demographic and FTE data will not.

 

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