PowerSchool SIS Ontario

OnSIS Verification Details - Section C

Section C - Co-operative Education Courses

The Section C (Co-operative Education Courses) details report supports validation of student-level records that contribute to the OnSIS Verification Summary - Section C totals. Use this report to review which students and course records are included for the selected submission period before final submission.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

School Selection

  • The school must be a secondary schools.

  • Schools with the "Exclude From State Reporting" ([Schools]State_ExcludeFromReporting) checkbox selected will not be included.

  • School must not be closed.

  • Any school with the same BSID but with "Exclude From State Reporting" or "School is Closed" ([S_ON_SCH_X]IsClosed_TF) checkboxes selected is not included.

  • The selected school must be identified by Alternative School Number (BSID).

Student Selection

  • The student must be enrolled in the school as of the submission count date. (where S_ON_STU_XML_School_Enrol_C .Enrolment_End_Date is NULL and S_ON_STU_XML_School_Enrol_C .Main_School_Flag is T)

  • The student must be active for the selected submission period rules.

  • Cross-enrolled students are not included unless they are enrolled in the selected school for reporting purposes.

October submissions do not include non returning students.

Course Selection

  • The report includes Co-operative Education Courses for the selected school, academic year, and submission period.

  • The report is generated from saved OnSIS verification data for the selected submission period.

  • The report includes only records associated with the selected school BSID.Records excluded by OnSIS reporting rules or validation filters are not included.

Report Output

See Understanding the Report Output Table for a definition of each column in the table.

Field

Description

[Table]FieldName

Board Number and Name

The name and Board School identification (BSID) number of the school board.

[Prefs]Value where [Prefs]name is districtnumber, districtname

School Number and Name

The school's name and Board School identification (BSID) number.

[Schools]Alternate_School_Number. If undefined, [Schools]School_Number

[Schools]Name where [Schools]school_number
OR [Schools]alternate_school_number is equal to the alternative school number selected on the report run page.

Academic Year

The academic year for which the report is run; the report is associated with the OnSIS Reporting Dates entered in District Setup. The format is YYYY-YYYY. For example, 2012-2013.

Derived from [Terms]YearId

Submission Period Type

The submission period type selected on the report run page.

Defined at report run time.

Class Code

 The class code.

[S_ON_STU_XML_CLASS_ENROL_C ]CLASS_CODE

Class Type

 The class type.

[S_ON_XML_CLASS_S]CLASS_TYPE

Segment Course Code

Course Code

[S_ON_XML_SEGMENT_S]MINISTRY_DFND_CRS

[S_ON_XML_SEGMENT_S]LOCAL_DEV_CRS

Credit Value

 The credit value of the course.

[S_ON_XML_SEGMENT_S]CREDIT_VALUE

Language of Instruction

 The language of instruction for the course.

[S_ON_XML_SEGMENT_S]LANGUAGE_TYPE

Attendance Type

The student's attendance type.

[S_ON_STU_XML_School_Enrol_C]Attendance_Type

OEN

The student's OEN.

[S_ON_STU_XML_School_Enrol_C]OEN

Student Name

The student's name.

[S_ON_STU_X]Legal_Last_Name or [Students]Last_Name

[S_ON_STU_X]Legal_First_Name or [Students]First_Name

Grade

The student's grade.

[S_ON_STU_XML_School_Enrol_C]Grade_Type

Course Delivery

Displays the course delivery type: Co-Op.

[S_ON_STU_XML_CLASS_ENROL_C]COURSE_DELIVERY_TYPE 

Counted

This field is selected when a record is counted. If the Course Start Date is on or after the Cycle Start Date and the Withdrawal/Dropped Code is blank, the Student Class Enrollment record is counted. Otherwise, it is in the LIST. The Course End Date condition does not apply.


Course Code

Course code included in Section C reporting.

Course and section reporting record

Course/Segment:

The label and Segment Course Code is printed.

[S_ON_STU_XML_CLASS_ENROL_C ]CLASS_CODE

Total Students Counted: # of # for course/segment

Displays the row label, Total Students Counted followed by the total number of students counted for the course/segment.

 

“Total Students Counted: # of #” for class

Total number of counted students for the class.

 

Number of Segments: # for Class

The number of segments for the class.