Skip to main content
Skip table of contents

OnSIS Verification Summary- Section U

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

The Section U (Number of Special Education Graduates Summary) 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.

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 NameThe name and Board School identification (BSID) number of the school board.

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

School Number and NameThe 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 YearThe 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 TypeThe submission period type selected on the report run page.Defined at report run time.
Diploma/Certificate TypeThe student's certification and type of exceptionality.S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type
Academic Year + “Actual”The academic year for which the report is running. Derived from [Terms]Yearid 
Total number of students for each exceptionality that have earned the OSSD diplomaS_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 1

Total number of students for each exceptionality that have earned the OSSD/SHSM diploma


Total number of students for each exceptionality that have earned the OSSD2 diploma



Total number of student for each exceptionality that have earned the OSSC diploma

C of A
Total number of student for each exceptionality that have earned the C of A (Certificate of Achievement)



Total number of student for each exceptionality that have earned the SSGD

Number of Ontario Scholars

Total number of students that are Ontario Scholars not including the Non Identified Students.

S_ON_STU_XML_SCHOOL_ENROL_C.Ontario_Scholarship_Date is Not Null

Grand TotalThe total number of students listed in the report without including the Non Identified Students.Calculated
JavaScript errors detected

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

If this problem persists, please contact our support.