Course Section Records Report (Legacy)

Field

Description

Use

If run at the district level, choose one of the following from the pop-up menu:

• Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.

• Current School Only – Includes all records associated with the current school that meet the selection criteria.

• District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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.

Term (Fall 2)

Choose the appropriate term from the pop-up menu.

Census Date
(Fall 2)

Enter the census date, 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 from the pop-up menu 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, extract completes as expected.

See Extract Validations for a list of potential validation errors.

Bypass Course Validation

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

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 course section records associated with the selected schools that meet the selection criteria.

Note: This parameter is optional.

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

CRS-Course Content Code

Value represents the Education Program related to specific course content.

State Business Rules: If the CTE Technical Preparation Course Indicator is Yes, then the Course Content Code must be 154 or the State Course Code must be a value from 7000 to 8999.

[S_CA_CRS_X]ContentCode

4

CS

N/A

N

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 – S

• 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

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

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 completing 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)