Skip to main content
Skip table of contents

OnSIS Verification Detail - Section U

Section U - Number of Special Education Graduates Detail - Secondary Only

The Section U (Number of Special Education Graduates Details) report collects aggregate figures for all students by the type of certification, type of exceptionality, and who have an Active status as of the count date of the submission. You can run this report only for secondary schools. The details report lists individual student information for students included in the OnSIS Verification Summary- Section U report.

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

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

Student Selection

  • The select student from the school enrolment permanent table (where S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type <> 08 ( Shared) and <> 09 ( e-learning ). Shared and E-learning students are excluded from the report.

  • The report must include only Active Students: Students must not have an Enrolment End Date prior to or on the Count Date for the submission period. The student is active when:

    • Enrolment_End_Date = null or greater than the count date.

    • All other students are considered to be Inactive and are to be ignored.

  • Student achieved a Diploma (with/without Ontario Scholars) or students with only Ontario Scholars, that is when correspondent fields are populated in the permanent table (S_ON_STU_XML_SCHOOL_ENROL_C .Diploma_Certificate_Issued is not Null or S_ON_STU_XML_SCHOOL_ENROL_C .Ontario_Scholarship_Date is Not null.

  • Student must be a special education student (record in S_ON_STU_XML_SPED_C):

    • Report should include/count the student under the exceptionality with the Main Exceptionality Flag is ON otherwise where the Non Identified Student flag is ON.

    • If a student has multiple special education segment (multiple records in S_ON_STU_XML_SPED_C) , the student must be included/counted once in the report:

      • When multiple records are found,where the S_ON_STU_XML_SPED_C .MAIN_EXCEPTIONALITY_FLAG = "T" , the report will order by placement and take the first.

      • If a student does not have any records with S_ON_STU_XML_SPED_C .MAIN_EXCEPTIONALITY_FLAG = "T", and the student has multiple records where the S_ON_STU_XML_SPED_C .NON_IDENTIFIED_STUDENT_FLAG = "T" and then the code considers the order by placement and takes the first one.

Report Output

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




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. Format '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.

Students are grouped by diploma/certification type and types of exceptionalities. Each exceptionality is sorted by age, OEN or student name.


The diploma earned by the student.



Student's Exceptionality

S_ON_STU_XML_SPED_C .Exceptionality_Type


The student's age as of December 31 of the school year.

[Students]DOB - Calculate the student's age as of December 31 of the current academic school year.


The student's 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

Birth Date

The student's birth date.


Diploma Earned Date

The date that the student earned the diploma.

S_ON_STU_XML_SCHOOL_ENROL_C .Diploma_Certificate_Issued

Ontario Scholar

A flag to indicate that the student is an Ontario Scholar.

Selected when S_ON_STU_XML_SCHOOL_ENROL_C.Ontario_Scholarship_Date

SHSM Req. Met

A flag to indicate that the student met his SHSM requirements.

Prints a checkmark if the student has met the requirements for SHSM Program type in a previous or current submission period in any school (that is, ALL _REQUIREMENTS_MET_DATE is less than or equal to the Submission Period Count Date).

Selected when

S_ON_STU_XML_SCHOOL_ENROL_C.SHSM_All_Req_Met_YYYYMM is not null and is <= count date

Main Exept.

To identify if the student exceptionality is the main exceptionality.

S_ON_STU_XML_SPED_C .Main_Exceptionality_Flag

Non Identified Students

List List of special education students that are non identified and are graduates


Total [Diploma/Certificate]:

Total number of special education students that earned this diploma.


Ontario Scholars Only

This section lists special education students that are only Ontario Scholars.

Total [Ontario Scholars Only]

The total number of Ontario Scholars Only.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.