Course Section Report

Use

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• District Wide – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The District Wide option is only available when running the report from the District Office.

Collection Period*

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

• 40 Day Period – Extracts all sections from the start of school through the 40^th school day

• 100 Day Period – Extracts all sections from the 40^th school day through the 100^th school day
• End of Year – Extracts all sections from the 100^th school day through the end of the year.
• Ad-Hoc Report – Extracts all section enrollments from the ‘Start Date of Report’ and the ‘End Date of Report’ parameters.

Note: For the 40 Day, 100 Day, and EOY collections, the 40th and 100th school days are automatically calculated by the report at run-time. See the STC – Collection Date Setup Screen to view or override the calculated collection dates.

The Start of School and End of Year dates are determined by the first day and last day of the full year term at the top of the page at run-time.

Start Date of Report

Enter the Start Date of the Report.

The option is available for the Ad-Hoc Report collection option. For all other collections, the entry box is greyed out.

When the Ad-Hoc Report collection period is selected, the ‘Start Date of Report’ and ‘End Date of Report’ are used to determine section enrollment inclusion.

End Date of Report

Enter the End Date of the Report.

The option is available for the Ad-Hoc Report collection option. For all other collections, the entry box is greyed out.

LEA Entity ID*

Enter the District LEA Entity ID (Required).

Bypass Validation Mode*

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

• Yes – Bypass validation and produce a file for submission to the state
• No – Produce a file which lists validation errors for required data elements

AZ LEA Entity ID

(LEAID)

The state assigned unique LEA entity identifier

N/A

Entered at report run-time.

AZ School Entity ID

(SchoolId)

The state assigned public or charter school entity identifier

[Schools]AZ_EntityID

Course Identifier

(CourseId)

The identifying code for the course content.

If the Course Identifier Section field is blank, report pulls from the Alternate Course Number Course field.  If the Alternate Course Number field is blank, report pulls from the Course Number field.

[Courses]Course_Number

[Courses]alt_course_number

[Sections]AZ_CourseID

Course Identifier System

(CourseIdSystem)

The system used for the course identifier- either Local or State. If local course codes are used, the course must be mapped in the CourseWalk system to a state course code.

Calculated

If [courses]alt_course_number or [sections]AZ_CourseID is populated, S is reported, otherwise L is reported.

Local Course Title

(CourseTitle)

The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts).

If the Course Name Section field is blank, report pulls from the Courses Course name field.

[Courses]Course_Name

[Sections]AZ_CourseName

School Year

(SchoolYear)

The school year for this course section in '2012' format.

Calculated.

Pulls the 4 digit year number of the last day of the full year term of the term year set at the top of the page at run-time.

SessionName

(SessionName)

A description for the term or session for the course section, for example 'Fall semester' or '2nd Trimester'

[Terms]Name

Pulls term name of term associated with the section.

Timetable Day Identifier

(TimetableDayIdentifier)

The unique identifier for the locally defined rotation cycle date code when the class meets (e.g., in a two day schedule, valid values could be "A" and "B", or "1" and "2").

[Sections]expression

Pulls all characters between parentheses, replacing a comma with a space.

Class Period

(ClassPeriod)

An identifier for the period during the day in which this section is held. If a Section spans multiple periods, report just the initial Class Period.

[Sections]expression

Pulls first period in the expression.

Section Identifier

(SectionIdentifier)

Unique identifier for a section.

[Sections]Id

Term Type

(TermType)

The type of term this is.

[Sections]termid

[StuTchCrsConnection]user_defined_integer (termid)

[StuTchCrsConnection]user_defined_text2 (term type)

Session Type

(SessionType)

The type of term or session this is.

Note:  Use the Student Course Enrollment / Final Grade mapping page to populate Session Type.

[Sections]termid

[StuTchCrsConnection]user_defined_integer (termid)

[StuTchCrsConnection]user_defined_text (session type)

Session Begin Date

(SessionBegin)

The month and year in which a session begins.

[Sections]termid

[Terms]firstday

Format: MM/YYYY

Session End Date

(SessionEnd)

The month and year in which a session ends.

[Sections]termid

[Terms]lastday

Format: MM/YYYY

Teacher 1 Last Name

(T1LastName)

The last, family or surname for the primary teacher for the course section as reported in the HQT system

PS 7.5 and higher:

The most recent active Section Lead Teacher within the collection period is always reported as Teacher 1.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher 1 First Name

(T1FirstName)

The first or given name for the primary teacher for the course section as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher 1 Middle Initial

(T1MI)

The middle initial for the primary teacher for the course section as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher 1 Birthdate

(T1Birthdate)

The primary teacher's birthdate as reported in the HQT system

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher 1 Role

(T1Role)

The role of the primary teacher for this course section

PS 7.5 and higher:

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract.

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See the Appendix for a list of valid Role Code values.

PS 7.2.3 and previous:

Report pulls a Role Code of R for all teachers.

Calculated.

Teacher 1 Begin Date

(T1BeginDate)

The date when Teacher 1 begins being associated with this section

PS 7.5 and higher:

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

PS 7.2.3 and previous:

Report pulls the first in-session day of the term.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher 1 End Date

(T1EndDate)

The Date upon which the primary teacher is no longer associated with this section

PS 7.5 and higher:

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

PS 7.2.3 and previous:

Report pulls the last in-session day of the term.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Teacher 1 Educator Stakeholder ID

(T1EducatorID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[Teachers]SIF_StatePrid

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

Teacher 1 Contribution Percent

(T1Contribution)

A fraction of time used to weight the educator's assigned responsibility for student learning in a Class Section, particularly when more than one educator is assigned to the class section. Use 0.5 for half contribution or 1 for full contribution.

PS 7.5 and higher:

Report pulls the Section Teacher % Allocation value entered on the section setup page.

PS 7.2.3 and before:

Report pulls a contribution percent of 1.00 for all teachers. 

[SectionTeacher]Allocation

Teacher 2 Last Name

(T2LastName)

The last, family or surname for the secondary teacher for the course section as reported in the HQT system.

Note: Teachers 2-5 are not reported on PowerSchool version 7.2.3 and previous. Co-Teaching functionality released in PowerSchool 7.5 allows for the collection and reporting of multiple teachers per section.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher 2 First Name

(T2FirstName)

The first or given name for the secondary teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher 2 Middle Initial

(T2MI)

The middle initial for the secondary teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher 2 Birthdate

(T2Birthdate)

The secondary teacher's birthdate as reported in the HQT system

 [SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher 2 Role

(T2Role)

The role of the secondary teacher for this course section

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract.

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See the Appendix for a list of valid Role Code values.

Calculated.

Teacher 2 Begin Date

(T2BeginDate)

The date when Teacher 2 begins being associated with this section

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher 2 End Date

(T2EndDate)

The Date upon which Teacher 2 is no longer associated with this section

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Teacher 2 Educator Stakeholder ID

(T2EducatorID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[Teachers]SIF_StatePrid

Teacher 2 Contribution Percent

(T2Contribution)

A fraction of time used to weight the educator's assigned responsibility for student learning in a Class Section, particularly when more than one educator is assigned to the class section. Use 0.5 for half contribution or 1 for full contribution.

Report pulls the Section Teacher % Allocation value entered on the section setup page.

[SectionTeacher]Allocation

Teacher 3 Last Name

(T3LastName)

The last, family or surname for the tertiary teacher for the course section as reported in the HQT system.

Note: Teachers 2-5 are not reported on PowerSchool version 7.2.3 and previous. Co-Teaching functionality released in PowerSchool 7.5 allows for the collection and reporting of multiple teachers per section.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher 3 First Name

(T3FirstName)

The first or given name for the tertiary teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher 3 Middle Initial

(T3MI)

The middle initial for the tertiary teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher 3 Birthdate

(T3Birthdate)

The tertiary teacher's birthdate as reported in the HQT system

 [SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher 3 Role

(T3Role)

The role of the tertiary teacher for this course section

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract.

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See the Appendix for a list of valid Role Code values.

Calculated.

Teacher 3 Begin Date

(T3BeginDate)

The date when Teacher 3 begins being associated with this section

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher 3 End Date

(T3EndDate)

The Date upon which Teacher 3 is no longer associated with this section

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Teacher 3 Educator Stakeholder ID

(T3EducatorID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[Teachers]SIF_StatePrid

Teacher 3 Contribution Percent

(T3Contribution)

A fraction of time used to weight the educator's assigned responsibility for student learning in a Class Section, particularly when more than one educator is assigned to the class section. Use 0.5 for half contribution or 1 for full contribution.

Report pulls the Section Teacher % Allocation value entered on the section setup page.

[SectionTeacher]Allocation

Teacher 4 Last Name

(T4LastName)

The last, family or surname for the fourth teacher for the course section as reported in the HQT system.

Note: Teachers 2-5 are not reported on PowerSchool version 7.2.3 and previous. Co-Teaching functionality released in PowerSchool 7.5 allows for the collection and reporting of multiple teachers per section.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher 4 First Name

(T4FirstName)

The first or given name for the fourth teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher 4 Middle Initial

(T4MI)

The middle initial for the fourth teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher 4 Birthdate

(T4Birthdate)

The fourth teacher's birthdate as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher 4 Role

(T4Role)

The role of the fourth teacher for this course section

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract .

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See the Appendix for a list of valid Role Code values.

Calculated.

Teacher 4 Begin Date

(T4BeginDate)

The date when Teacher 4 begins being associated with this section

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher 4 End Date

(T4EndDate)

The Date upon which Teacher 4 is no longer associated with this section

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Teacher 4 Educator Stakeholder ID

(T4EducatorID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[Teachers]SIF_StatePrid

Teacher 4 Contribution Percent

(T4Contribution)

A fraction of time used to weight the educator's assigned responsibility for student learning in a Class Section, particularly when more than one educator is assigned to the class section. Use 0.5 for half contribution or 1 for full contribution.

Report pulls the Section Teacher % Allocation value entered on the section setup page.

[SectionTeacher]Allocation

Teacher 5 Last Name

(T5LastName)

The last, family or surname for the fifth teacher for the course section as reported in the HQT system.

Note: Teachers 2-5 are not reported on PowerSchool version 7.2.3 and previous. Co-Teaching functionality released in PowerSchool 7.5 allows for the collection and reporting of multiple teachers per section.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Teacher 5 First Name

(T5FirstName)

The first or given name for the fifth teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]first_name

Teacher 5 Middle Initial

(T5MI)

The middle initial for the fifth teacher for the course section as reported in the HQT system

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]middle_name

Pulls first character.

Teacher 5 Birthdate

(T5Birthdate)

The fifth teacher's birthdate as reported in the HQT system

 [SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]dob

Teacher 5 Role

(T5Role)

The role of the fifth teacher for this course section

Reports the Reference Code value associated with the Role assigned to the teacher. See Co-Teaching Roles Setup - Student Teacher Extract.

A teacher’s Role code value may be overridden by entering a valid Role Code value in the Notes field of the Actions Co-teaching column.

See the Appendix for a list of valid Role Code values.

Calculated.

Teacher 5 Begin Date

(T5BeginDate)

The date when Teacher 5 begins being associated with this section

Report pulls either the Section Teacher Start Date, or the first in-session day of the term, whichever is the most recent.

Calculated.

[Sections]termid

[Terms]firstday

[SectionTeacher]Start_Date

Teacher 5 End Date

(T5EndDate)

The Date upon which Teacher 5 is no longer associated with this section

Report pulls either the Section Teacher End Date, or the last in-session day of the term, whichever is less recent.

[Sections]termid

[Terms]lastday

[SectionTeacher]End_Date

Teacher 5 Educator Stakeholder ID

(T5EducatorID)

The Arizona Educator Stakeholder Id (if available)

Per state guidelines, all Educator Stakeholder IDs are reported with a single quote before the 16-digit number so that the number will display correctly in excel. SRM will strip out the single quote upon submission.

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[Teachers]SIF_StatePrid

Teacher 5 Contribution Percent

(T5Contribution)

A fraction of time used to weight the educator's assigned responsibility for student learning in a Class Section, particularly when more than one educator is assigned to the class section. Use 0.5 for half contribution or 1 for full contribution.

Report pulls the Section Teacher % Allocation value entered on the section setup page.

[SectionTeacher]Allocation

Course Begin Date

(CourseBegin)

The date of the first day of instruction

Report pulls the first in-session day of the term.

[Sections]termid

[Terms]firstday

Course End Date

(CourseEnd)

The date of the last day of instruction

Report pulls the last in-session day of the term.

[Sections]termid

[Terms]lastday

Credits Offered

(CreditsOffered)

The number of credits offered for this course (HS Only)

[Sections]course_number

[Courses]credit_hours

Instructional Setting

(InstructionalSetting)

The instructional setting for the course

Defaults to ‘Regular Departmentalized Classroom’ if course or section are blank

[Sections]AZ_InstSet

[Courses]AZ_InstSet

Low Grade Level

(LowGrade)

The lowest grade level of students either enrolled in the course or for which the course is targeted

If section value is blank, report pulls from course. If course and section values are blank, report pulls from low grade of school.

[Sections]AZ_LowGrade

[Courses]AZ_LowGrade

[Schools]Low_Grade

High Grade Level

(HighGrade)

The highest grade level of students either enrolled in the course or for which the course is targeted

If section value is blank, report pulls from course. If course and section values are blank, report pulls from high grade of school.

[Sections]AZ_HighGrade

[Courses]AZ_HighGrade

[Schools]High_Grade

Is Dual Credit

(DualCredit)

A flag indicating if students enrolled in this course have the option of receiving both high school and post-secondary credit, regardless of whether any students avail themselves of that option. High School Courses only

If section value is blank, report pulls from course. If course and section values are blank, the value defaults to N for high school courses.

Non high school courses report X.

[Sections]AZ_DualCredit

[Courses]AZ_DualCredit

Concurrent Enrollment

(Concurrent)

A flag indicating a college course attended by students prior to high school graduation for which they are not receiving high school credit. Reporting these sections is optional.

Optional Field. Reports as blank for high school courses unless populated at section or course level.

[Sections]AZ_ConcurEnroll

[Courses]AZ_ConcurEnroll

Course Level Characteristic

(CourseLevel)

An indication of the level of rigor in a course

Defaults to ‘General or Regular’ if course or section are blank)

[Sections]AZ_CourseLevel

[Courses]AZ_CourseLevel

Is CTE Certificate (HS Only)

(Certificate)

A flag indicating if the course is part of a career or technical education program leading to a specific technical certification. High School Courses Only

If section value is blank, report pulls from course. If course and section values are blank, the value defaults to N for high school courses.

Non high school courses report X.

[Sections]AZ_CTECert

[Courses]AZ_CTECert

Is Required for Graduation (HS Only)

(GradRequirement)

A flag indicating if this specific course is required for a student to graduate. This does not apply if this course is one of several they may meet a general "so many credits" in a subject area requirement, but not this specific course. High School Course Only

Optional Field. Reports as blank for high school courses unless populated at section or course level.

[Sections]AZ_ReqGrad

[Courses]AZ_ReqGrad

External Provider Name

(Provider)

If the course is being provided by an external organization, e.g. a distance education or virtual course, the name of that providing organization.

[Sections]AZ_Provider

Provider Teacher 1 last Name

(ProviderT1LastName)

If the course is being provided by an external provider, the last, family, or surname of the provider's primary instructor.

Note: When External Provider Teacher 1 Last and First Name are entered, the teacher(s) associated with the section will not be reported unless the ‘Include both External Provider and Internal Teacher…’ box is checked.

External Provider teachers are not validated against HQT.

[Sections]AZ_ProviderT1LastName

Provider Teacher 1 First Name

ProviderT1FirstName)

If the course is being provided by an external provider, the first or given name of the provider's primary instructor.

[Sections]AZ_ProviderT1FirstName

Provider Teacher 1 Role

(ProviderT1Role)

The instructional role of the provider's primary instructor

[Sections]AZ_ProviderT1Role

Provider Teacher 2 last Name

(ProviderT2LastName)

If the course is being provided by an external provider, the last, family, or surname of the provider's secondary, if any, instructor.

[Sections]AZ_ProviderT2LastName

Provider Teacher 2 First Name

ProviderT2FirstName)

If the course is being provided by an external provider, the first or given name of the provider's secondary, if any, instructor.

[Sections]AZ_ProviderT2FirstName

Provider Teacher 2 Role

(ProviderT2Role)

The instructional role of the provider's secondary, if any, instructor

[Sections]AZ_ProviderT2Role

Notes

Any clarifying information for this course section

[Sections]AZ_Notes