Skip to main content
Skip table of contents

OnSIS Verification Detail - Section T

Section T - Enrollment by Age, Gender and Type of Diploma/Certificate Details - Secondary Only

The Section T (Enrollment by Age, Gender and type of Diploma/Certificate Details) report collects the enrollment details by age, gender, and type of diploma or certificate for secondary students. The report groups Enrolled, Non-enrolled, and Ontario Scholars separately. You can run this report at the district and school level for different submissions (October, March, and June) for secondary schools. The details report lists individual student information for students included in the OnSIS Verification Summary - Section T 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 that have Exclude From State Reporting ([Schools]State_ExcludeFromReporting) selected are not included.

Student Selection

For the selected Academic Year, School BSID, Submission type:

  • Choose a student from the school enrollment 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 Active Students only. The student does not have an Enrollment End Date prior to or on the Count Date for the submission period. The student is active when:

    • Enrolment_End_Date is null or greater than the Count Date.

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

  • A student can also be non-enrolled (STUDENT_NON_ENROLMENT segment generated for the student, which is recorded in the correspondent permanent table).

  • A student achieved a diploma (with or without Ontario Scholars) or is a Student with Ontario Scholars only (when correspondent fields are populated in the permanent table).

Report Output

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.

Diplomas for Academic Year

A label that identifies the year when the listed students earned their diploma.

Derived from Diploma_Certificate_Issued based on the predefined academic year date range of September 1, YYYY to August 31, YYYY+1. For example, if the Diploma Date of Issuance is equal to June 30, 2007, the Academic Year would be 2006-2007.

For Ontario Scholars Only is derived from the ONTARIO_SCHOLARSHIP_DATE

  • If the date is between September and December then academic year = YYYY - YYYY + 1. For example, if the Diploma Date of Issuance is September 3, 2015, then the academic year will be 2015 - (2015 + 1) = 2015 - 2016

  • If the date is between January and August then academic year = YYYY -1 - YYYY. For example, if the Diploma Date of Issuance is March 3, 2016, then the academic year will be (2016-1) - (2016) = 2015 - 2016

Enrolled vs.Non-Enrolled Students vs. Ontario Scholars Only

The report printed in the following order:

  • Enrolled Students

  • Non-Enrolled Students

  • Ontario Scholars Only (which may be followed by Enrolled Students and/or Non-Enrolled Students)

In the Ontario Scholar Only section, the Diploma Earned Date is blank.

Students are grouped by diploma/certification type and age group. Each age group is then sorted by OEN or student name.


The diploma earned by the student.



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

Unk Gender

This checkbox is selected to identify students that are not counted in the Totals due to unidentified or invalid gender.


Total for Age ###

This is a sub-total number of students by Diploma/Certificate type and age. This is repeated after every age group. Students with undefined or invalid gender should not be included in the totals.


Total [Diploma Type]:###


Ontario Scholars Only

Grand total of the number of students included by Diploma/Certificate type. Unknown or students with an undefined age or gender are not included.


Total [Academic Year]:###

The total number of counted students (not including students with unknown gender or age) who earned their diploma or become Ontario Scholars in the Academic year. This total is repeated with every Diplomas for Academic Year listed.


Grand Total

Grand total of all counted students, not including students with unknown gender or age.


JavaScript errors detected

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

If this problem persists, please contact our support.