Course Section Records Report

Field

Description

School Group

Choose a school group to run the report for a previously defined group of schools. The extract includes course section records associated with the selected schools that meet the selection criteria.

Note: This parameter overwrites the Select Schools parameter.

Select Schools

If run at the district level, choose one of the following:

• Select Multiple Schools – Select schools to include in the report. To select a single school, click that school. To select multiple schools, use Ctrl+Click and select each school to be included. Select schools to include in the report

• All Schools – Run the report for the entire district.

If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.

Submission

Choose one of the following from the pop-up menu:

• Fall 2 – The extract includes course section records that meet the Fall 2 Course Section Enrollment Submission selection criteria.

• End of Year 1 – The extract includes course section records that meet the End of Year 1 Course Section Enrollment Submission selection criteria.

District Uses Tracks (Fall 2)

If the district uses tracks, select Yes.

Census Date (Fall 2)

Enter the census date. Typically this is the first Wednesday in October.

Start Date (EOY 1)

Enter the report start date. It is recommended to enter the first day of the current school year, as defined in the Years & Terms, as the start date.

End Date (EOY 1)

Enter the report end date. It is recommended to use enter the last day of the current school year, as defined in the Years & Terms, as the end date.

Bypass Validation

Choose Yes or No to run the validation portion of extract, which is used to validate that specified fields used for the extract are populated correctly.

If the report identifies errors in student data, an HTML page displays the list of the errors. If the report does not identify any data errors, the extract completes as expected.

See Extract Validations for a list of potential validation errors.

School Group 
Note: This overrides the Use selection above.

Choose a group of schools to override the above "Use" parameter indicating District-Wide vs.Current School Only. The extract includes student records associated with the selected schools that meet the selection criteria.

Note: This parameter is optional.

Include Records For Course Code 1000

Valid values: Yes/No

If you select Yes, the records associated with the course where the course number or alternate course number = 1000, will be included in the Course Sections Records report.

Generate Output with Old Language Codes (2 digit numeric)

Select this option to generate report with old language codes (2 digit numeric).

Field #

Data Element

Description

[Table]FieldName

Max Length

Field Type

O/U

Required

9.01

Record Type Code

The type of data record being submitted.

CRSE or CRSC

If Submission = Fall 2, then CRSE

If Submission = EOY 1, then CRSC

4

CS

N/A

Y

9.02

Transaction Type Code

The action the system should take on the data record being submitted.

CALPADS processes the following Transaction Type Codes:

• Blank: Add or update the record

• D: Delete the current record

This value is calculated based on the updatable fields and operational keys.

1

CS

N/A

N

9.03

Local Record ID

A local use field to provide the system record identifier for a submitted record in any CALPADS file format.

This field is calculated by concatenating internal ID fields. The values for the internal fields may be separated by periods.

[Sections]ID

255

CS

N/A

N

9.04

Reporting LEA

A unique identifier for the educational service institution responsible for obtaining and maintaining a student's SSID by way of an enrollment record in the CALPADS.

State Business Rules:

The 7-digit County District (CD) code must be submitted if the reporting entity is a district or county office.

If the reporting entity is an independently reporting charter school, the School (S) code must be submitted for both the Reporting LEA and the School of Course Delivery.

[Prefs]Name=districtnumber

[Prefs]Value

7

CS

N/A

Y

9.05

School of Course Delivery

The 7-digit school code for the school at which the student is taking the course.

State Business Rules:

If the school is an independent charter school, the school code must be submitted for both the School of Course Delivery and the Reporting LEA.

This number must be a valid value in CALPADS and have an active reporting relationship with the Reporting LEA.

The School of Course Delivery must match the School of Attendance from the student’s enrollment record.

[Sections]SchoolID = [Schools]School_Number

[S_CA_SCH_X]StateSchoolNumber

7

CS

O

Y

9.06

Academic Year ID

The period during which school is in regular session and provides a required number of days of instruction (175 days in California).

Extracted in the format CCYY-CCYY, such as 2008-2009.

[Terms]FirstDay

[Terms]LastDay

The report extracts the last four digits of the date value stored in both the FirstDay and LastDay fields.

9

CS

O

Y

9.07

CRS-State Course Code

A state-level code structure used to group several local course descriptions by major subject area, or to indicate individual-level courses.

If the Alternate Course Code is populated, the extract will report that value.  If the Alternate Course Code is not populated, the Course Number will be reported.

Note: If the LEA has mapped the local course code to a state course code, then this field may be left blank.

State Course Code values of 1001 – 1999 will be converted to 1000 by the extract. 

[Courses]alt_course_number

[Courses]Course_Number

4

CS

N/A

Y

9.08

CRS-Local Course ID

A course is the organization of subject matter and related learning experiences provided for students; not the same as a class.

Note: PowerSchool Course Numbers need to be no longer than ten characters in length.

[Courses]Course_Number

10

CS

N/A

Y

9.09

CRS-Course Name

The formal name of the course as established by the school or LEA.

[Courses]Course_Name

50

CS

N/A

Y

9.10

Filler

9.11

Filler

9.12

CRS-CTE Technical Preparation Course Indicator

A Technical Preparation Course is a course within a CTE technical career pathway or program from a postsecondary education institution.

[S_CA_CRS_X]CTETechPrep

1

CS

N/A

N

9.13

CRS-UC CSU Approved Indicator

Indicates whether the UC/CSU systems reviewed and approved the content of this course as meeting one or more of the A–G course admission requirements.

Any selected letter value is reported as Y

Otherwise N is reported.

[S_CA_CRS_X]UCCSU_Area

1

CS

N/A

Y

9.14

Course Section ID

Unique identifier for a course section.

State Business Rules: The Course Section ID must be unique for each Academic Term, School of Delivery, and SEID unless the SEID is 9999999999 or the Multiple Teachers Code is populated.

[Sections]ID

10

CS

N/A

Y

9.15

Academic Term Code

The period of time into which the education institution divides the academic year for instruction.

The value for the Academic Term Override field is reported, if populated. Otherwise, the report derives the value from the term associated with the section. Terms are assigned a portion value via Start Page > School Setup > Years & Terms > Edit Terms > Edit Term > “What portion of the school year does this term represent?”. The portion value assigned to the term is decoded as follows:

• 1 – FY

• 2 – SS_CA_SEC_X

• 3 – T

• 4 – Q

• 6 – H

• [null] - Z

[Sections]TermID

[Terms]Portion

[S_CA_SEC_X]AcademicTerm

2

CS

O

Y

9.16

SEID

The unique identifier assigned to each educator in the California public education system by the California Commission on Teacher Credentialing. This number is known as the Statewide Educator Identifier (SEID).

If Record Type Code is CRSE, then:

The report determines the SEID in the following order of operation:

• If the Census Teacher Override is populated on the section, that teacher’s SEID will be reported.

• If there is no Census Teacher Override, the section teacher’s SEID will be reported.
  Note: The teacher assigned as the Lead teacher on the Census Date is reported, if applicable.

• If the section is assigned multiple teachers, a second record for this section is created, with the secondary teacher’s SEID.

If Record Type Code is CRSC, then:

• The section teacher’s SEID will be reported.

State Business Rules:

Must be a valid SEID in the California Commission on Teacher Credentialing (CCTC) file.  If SEID is equal to 9999999999, school type must be Charter School and NCLB Core Course Instructional Level Code = N

or

CTE Course Section Provider Category = “1” (Regional Occupational Center or Program)

or

Course Section Instructional Level Code = 16 (College).

If Record Type Code is CRSE, then:

[S_CA_SEC_X]CensusTeacherId

[Sections]Teacher

[SchoolStaff]ID

[S_CA_USR_X]SEID

[Sections]MultipleTeacherID

If Record Type Code is CRSC, then:

[Sections]Teacher

[SchoolStaff]ID

[S_CA_USR_X]SEID

10

CS

N/A

Y

9.17

Local Staff ID

ID assigned to a staff member by the LEA.

The Local Staff ID reported is the [Teachers]ID for the teacher reported in element 9.16 (SEID).

The report uses the SEID to locate additional records for the staff member.

Note:  If this field is blank in the extract, check that the SEID does not have an extra space following the 10-digit number.

[Users]DCID

10

CS

N/A

Y

9.18

Class ID

A unique ID that represents a class. 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.

The value is reported in the format [Sections]Teacher + [Sections]Expression + [Schools]ID.

Note:  All spaces and special characters in the section expression have been removed.  Additionally, the Class ID is truncated at 20 characters in the rare case it is longer than 20.

State Business Rules: The Class ID must be unique for each the School of Course delivery and Academic Year ID.

If Record Type Code is CRSE, then:

[Sections]Teacher

[Sections]Expression

[Schools]ID

If Record Type Code is CRSC, then:

Not Reported

20

CS

N/A

Yes, if Record Type Code is CRSE.

9.19

Course Section Instructional Level Code

Code representing the Course Non-Standard Instructional Level, the level at which the content of a specific course is above or below a standard course instructional level.

[S_CA_CRS_X]NS_Instructional_Lvl

[S_CA_SEC_X]NS_Instructional_Lvl

2

CS

N/A

N

9.20

Education Service Code

The value represents Education Services; specific services performed within an Education Service Category.

If Record Type Code is CRSE, then:

[S_CA_CRS_X]EdServiceCode

[S_CA_SEC_X]EdServiceCode

If Record Type Code is CRSC, then:

Not Reported

1

CS

N/A

Yes, if Record Type is CRSE and Instructional Strategy is 400, 500, 600 or 650.

9.21

Language of Instruction Code

The language in which instruction is provided.

State Business Rules:

This value must not equal 00 (English) or 37 (Sign Language).

If Record Type Code is CRSE, then:

[S_CA_CRS_X]LangInstruction

[S_CA_SEC_X]LangInstruction

If Record Type Code is CRSC, then:

Not Reported

2

CS

N/A

Yes, if the Education Service Code is 1 or the Instructional Strategy is 600.

9.22

Instructional Strategy Code

A method used to deliver curriculum and instruction.

If Record Type Code is CRSE, then:

[S_CA_CRS_X]InstStrategy

[S_CA_SEC_X]InstStrategy

If Record Type Code is CRSC, then:

Not Reported

3

CS

N/A

Yes, if Record Type is CRSE and if Educational Service Code is not blank.

9.23

Independent Study

Indicates if students are completing the course via independent study.

Note: The value will default to N in the extract if not populated.

[S_CA_CRS_X]IndependentStudy

[S_CA_SEC_X]IndependentStudy

1

CS

N/A

Y

9.24

Distance Learning Indicator

Instructional method in which the pupil and instructor are in different locations.

Note: The value will default to N in the extract if not populated.

[S_CA_CRS_X]DistanceLearning

[S_CA_SEC_X]DistanceLearning

1

CS

N/A

Y

9.25

Multiple Teacher Code

State Business Rules:

If this field is populated, then two or more Course Section records with the same Class ID must be submitted with different SEIDs, except when the SEID is 9999999999, if the school is a charter school.

If Record Type Code is CRSE, then: [S_CA_SEC_X]MultipleTeacherStatus

If Record Type Code is CRSC, then:

Not Reported

1

CS

N/A

N

9.26

Education Program Funding Code

Indicates the source of funding.

[S_CA_CRS_X]FundingSource

[S_CA_SEC_X]FundingSource

4

CS

N/A

N

9.27

CTE Course Section Provider Code

Describes the entity that provides a Career Technical Education course.

State Business Rules:

This field is required if the Course Content Code is 154 or if a CTE State Course Code is populated for the course (7000–8999).

[S_CA_CRS_X]CTE_Provider

[S_CA_SEC_X]CTE_Provider

1

CS

N/A

Yes, if Course Content Code is 154 or a State Course Code is populated (i.e., 7000-8999)

9.28

Course Content Area Subcategory Code

The course content subcategory code representing a more detailed subject matter within the course content area.

State Business Rules:

This field is required if the State Course Code = 9000, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400.

[S_CA_CRS_X]Content_Subcategory_Code

[S_CA_SEC_X]Content_Subcategory_Code

7

CS

N/A

Yes, if the State Course Code equals 9000, 9051, 9080, 9090, 9130-37, 9155, 9222, 9223, 9291, 9292, 9293, 9294, 9316, 9381, or 9400.

9.29

CRS - Departmentalized Course Standards Grade Level Range Code

Represents the range of grade-level standards that are covered in the course content.

State Business Rules:

Required.

[S_CA_CRS_X]Dept_Grade_Lvl_Range

3

CS

N/A

Yes, if State Curse Code <> 1000.

If State COurse Code = 1000, this value must be blank/null.

9.30

CRS - Content Standards Alignment Code

Represents the currency of the standards that were used to develop the course content.

State Business Rules:

Required.

[S_CA_CRS_X]Content_Std_Alignment

1

CS

N/A

Y

9.31

Charter Non-Core, Non-College Prep Indicator

(Not displayed)

An indicator of whether or not a charter school has identified a course as non-core, non-college preparatory.

State Business Rules:

Required for Charter Schools.

[S_CA_CRS_X]Charter_Prep_Ind

[S_CA_SEC_X]Charter_Prep_Ind

1

CS

N/A

Yes, if the school is a charter school.

9.32

AP/IB Course Code Cross Reference

The four-digit AP/IB course code cross-reference to the actual AP or IB State Course Code for AP or IB courses that a local educational agency has mapped to a Career Technical Education.

[S_CA_CRS_X]AP_IB_Code_Reference

[S_CA_SEC_X]AP_IB_Code_Reference

4

CS

N/A

N

9.33

Online Course Instruction Type Code

The type of online instruction that is being delivered in a course section.

State Business Rules:

This field is required if Distance Learning Indicator = Y.

[S_CA_CRS_X]Online_Instruction_Type

[S_CA_SEC_X]Online_Instruction_Type

1

CS

N/A

Yes, if Distance Learning Indicator equals Y.

9.34

Middle School Core Indicator

An indicator that a course in grades five through eight is being taught as part of a middle school core setting.

State Business Rules:

This field is required if the Departmentalized Course Standards Grade Level Range = MID (Middle Grades 5-8).

[S_CA_CRS_X]Middle_School_Ind

[S_CA_SEC_X]Middle_School_Ind

1

CS

N/A

Yes, if the Departmentalized Course Standards Grade Level Range = MID (Middle Grades 5-8).

9.35

Local Assignment Option Code

The local assignment option code that represents the local assignment option approved by the local governing board to authorize a teacher to teach a course without the appropriate credential or authorization.

[S_CA_CRS_X]Local_Assignment_Opt_Code

[S_CA_SEC_X]Local_Assignment_Opt_Code

2

CS

N/A

N

9.36

High Quality CTE Course Indicator 

An indicator of whether the course section and teacher meet the High-Quality CTE Course qualifications.

State Business Rules:

This field is required if the CRS-State Course Code associated with the Course Section is in range of 7000-8999.

[S_CA_CRS_X]High_Quality_CTE_Ind

[S_CA_SEC_X]High_Quality_CTE_Ind

1

CS

N/A

Yes, if the CRS-State Course Code associated with the Course Section is in range of 7000-8999.