Skip to main content
Skip table of contents

OnSIS Verification Summary - Section T

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

The Section T (Enrolment by Age, Gender and type of Diploma/Certificate Summary) report collects aggregate figures for enrollment by age, gender, and type of diploma or certificate. 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 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 that 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.

FieldDescription[Table]FieldName
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. Submission Period, School Type, and School.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 Title

The Enrolled Students summary is displayed at the beginning followed by the summary for Non-Enrolled Students.

Students with STUDENT_SCHOOL_ENROLMENT segment generated

followed by

Students with STUDENT_NON_ENROLMENT segment generated

Age

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

Age groups printed on the report:

  • Age 15 or under
  • 16
  • 17
  • 18
  • 19
  • 20
  • Total Under 21
  • Total 21and Over

Prints the Age row titles.

Calculate Student age based on December 31, YYYY where YYYY is based on the first part of calculated Diplomas For Academic Year.

[Students]DOB

Gender

Total number of students with gender M, F, N, or S in that age group.

S_ON_STU_XML_SCHOOL_ENROL_C.GNDER_TYPE/

S_ON_STU_XML_NON_ENROL_C.GNDER_TYPE

Diploma/Certificate TypeThe diploma earned by the student.S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type
S_ON_STU_XML_NON_ENROL_C.Diploma_Type
OSSDTotal number of students for each age and gender that have earned the OSSD diploma.

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 1

/S_ON_STU_XML_NON_ENROL_C.Diploma_type = 1

OSSD/SHSM

Total number of students for each age and gender that have earned the OSSD/SHSM diploma.

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 4

/S_ON_STU_XML_NON_ENROL_CDiploma_type = 4

OSSD2Total number of students for each age and gender that have earned the OSSD2 diploma.

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 2

/S_ON_STU_XML_NON_ENROL_C.Diploma_type = 2

OSSC

Total number of student for each age and gender that have earned the OSSC diploma.

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 7

/S_ON_STU_XML_NON_ENROL_C.Diploma_type = 7

C of ATotal number of students for each age and gender that have earned the C of A (Certificate of Achievement).

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 8

/S_ON_STU_XML_NON_ENROL_C.Diploma_type = 8

SSGD

Total number of students for each age and gender that have earned the SSGD.

S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type = 3

/S_ON_STU_XML_NON_ENROL_C.Diploma_type = 3

Number of Ontario Scholars

Total number of students that are Ontario Scholars regardless of the diploma date value.

S_ON_STU_XML_SCHOOL_ENROL_C.Ontario_Scholarship_Date is Not Null

/S_ON_STU_XML_NON_ENROL_C.Ontario_Scholarship_Date is Not Null

Total (row)This row is repeated at end of each age group. Total Number of student earned the diploma (as per the column) for the age group and regardless of gender.Calculated
Grand Total ( row) - M, F, N, S

Total number of students earned the diploma by gender regardless of age.

Calculated
TotalTotal number of students earned the diploma regardless of age and gender.Calculated
Enrolled and non-Enrolled TotalsTotal number of enrolled and non-enrolled students.Calculated
Diplomas for Academic Year

Total number of enrolled and non-enrolled students by academic year.

Calculated
JavaScript errors detected

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

If this problem persists, please contact our support.