Student Section Enrollment 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 (Default) – Includes all student records on the PowerSchool server that meet selection criteria.

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

Current Selection Students*

Indicate which students to include in the report by selecting one of the following options:

• The selected [number] students only – Run the report for students in the current selection.
• All students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running the report.

Collection Period*

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

• 40 Day Period – Extracts all section enrollments from the start of school through the 40^th school day
• 100 Day Period – Extracts all section enrollments from the 40^th school day through the 100^th school day
• End of Year – Extracts all section enrollments 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. The Final Grade reported is determined by the ‘Final Grade Store Code(s)’ parameter.

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. Also, the Final Grade reported is determined by the setup done using the Student Course Enrollment / Final Grade Mapping’ screen located on the Edit School page at the district office.

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.

Final Grade Store Code(s)

(Optional)

Enter a Historical Grade store code or store codes (comma-separated). If entering a comma-separated list of store codes, the most recent grade is reported.

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.

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.

Term Type

(TermType)

The type of term this is.

[Sections]termid

[StuTchCrsConnection]user_defined_integer (termid)

[StuTchCrsConnection]user_defined_text2 (term type)

Session Name

(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.

Primary Teacher’s 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 for the section, External Provider Teacher 1 is reported as the Primary Teacher unless the ‘Include both External Provider and Internal Teacher…’ box is checked. When both External Provider and Internal Teachers are reported in the Course Section file, the Internal PowerSchool teacher is reported as the Primary Teacher in the Student Section Enrollment file.

External Provider Teachers are not validated against HQT.

[Sections]teacher or

[SectionTeacher]SectionID

[SectionTeacher]Teacherid

[teachers]last_name

Primary Teacher’s 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

Section Identifier

(SectionIdentifier)

Unique identifier for a section.

[Sections]Id

SAIS Student ID

SAISID

The state assigned student ID in SAIS

[Students]State_StudentNumber

Local Student ID

(LocalStudentID)

An optional local ID for the student in the local student information system.

[Students]Student_Number

Student Last Name

(LastName)

The last, family, or surname for the student as reported in SAIS

[Students]Last_Name

Student First Name

(FirstName)

The first or given name for the student as reported in SAIS

[Students]First_Name

Student Middle Initial

(MI)

The middle initial of the student as reported in SAIS

[Students]middle_name

Pulls first character.

Student Birthdate

(Birthdate)

The student's birthdate

[Students]dob

Student Gender

(Gender)

The student's gender.

[Students]Gender

Course Entry Date

(CourseEntryDate)

The date of the first day the student received instruction in this course. Or, in the case of reentry, the date this particular membership segment began.

[CC]DateEnrolled

Course Entry Type

(EntryType)

The way the student entered this course section, either as a new enrollee or as a transfer from another section at the same school

Calculated

Reported Values:

N – New course enrollment

R – Student reenrolls in the same section (same SectionID) after an exit.

T – Student transfers from one class section to another class section of the same course at a school (same course number, different SectionID) within the school year.

Course Exit Date

(CourseExitDate)

The date of the last day the student received instruction in this course. Leave blank if the student is still enrolled at the time of reporting. If a student exits and re-enrolls, each enrollment segment should have its own record with its own entry and exit date.

[CC]DateLeft

Reports the last in session date before the exit date.

Course Exit Type

(ExitType)

The type of exit the student had from this course. Required if the exit date is not empty.

Valid Values:

• CF – Content Complete (Full Credit)
• CP – Content Complete (Partial Credit)
• CN – Content Complete (No Credit)
• SC – Schedule Change
• LS – Left the School
• OE – Open Ended Course

The value entered on the student’s Section Enrollment page (All Enrollments) will be reported. If blank, Course Exit Type will be calculated (see next column).

Calculated Values:

LS – Student does not complete class because he left school (class exit date equals school exit date and school exit date is less than the end of the year)

SC – Student drops class before class completes and student has not left school on the drop date.

CN – Student completed the course, but received no credit where credit was offered (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit for stored grades associated with the section equals 0.

CP – Student completed the course, but received partial credit where credit was offered (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit hours for stored grades associated with the section is greater than 0 but less than the sum of the potential credit).

CF – Student completed the course with full credit (the sum of the potential credit for stored grades associated with the section is greater than 0 and the earned credit hours for stored grades associated with the section is greater than or equal to the sum of the potential credit).

Note: CF is reported at course completion for students in grade levels below grade 9.

Credits Earned

(CreditsEarned)

The number of credits the student earned from this course. Required for High school courses when the exit date is not empty.

[CC]SectionID

[StoredGrades]SectionID

[StoredGrades]EarnedCrHrs

Reports the Earned Credit hours of the grade reported.

Grade Mark Earned

(GradeMark)

The final grade mark the student earned for the course section. Required when a Course Exit Date is reported. While Credit Earned is only required for High School Courses, a grade Mark is required whenever a student exits a course and is considered to have partially or fully accomplished the objectives of the course.

Important: Use the ‘Student Course Enrollment/Final Grade mapping’ page to map store codes to a collection period.  The report uses the mapping to determine which grades (if any) to report for each class.

Note: See Grade Mark Earned above for information regarding how grades are reported.

[CC]SectionID

[StoredGrades]Sectionid

[StoredGrades]Termid

[StoredGrades]StoreCode

[StoredGrades]Grade

[StandardsGrades]Identifier

[StandardsGrades]StoreCode

[StandardsGrades]YearID

[StandardsGrades]TransHighScore or TransAverageScore or HighScore or AverageScore

Earning Dual Credit

(DualCredit)

A flag indicating if this student is earning Dual Credit in a Dual Credit course. Use 'X' or 'N' when not a Dual Credit course

Reports a value if the section or course record’s AZ_DualCredit field is not blank. If CC is blank, the section value is reported.  If CC and Section are blank, Course Value is reported.

State Business Rule 10722:

[Earning Dual Credit] must be 'Y' or 'N' when [Is Dual Credit] = 'Y' and 'X', 'N', or blank otherwise.

[CC]AZ_DualCredit

[Sections]AZ_DualCredit

[Courses]AZ_DualCredit

Concurrently Enrolled

(ConcurrentlyEnrolled)

A Flag indicating if this student is concurrently enrolled in a course that offers concurrent enrollment. Use 'X', 'N' or blank when the course does not offer concurrent enrollment

Reports a value if the section or course record’s AZ_Concurrent field is not blank. If CC is blank, the section value is reported.  If CC and Section are blank, Course Value is reported.

[CC]AZ_ConcurrentlyEnrolled

[Sections]AZ_ConcurEnroll

[Courses]AZ_ConcurEnroll

Notes

Any clarifying information for this student section enrollment record.

[CC]AZ_Notes