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.
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 |
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
|
Enrolled vs.Non-Enrolled Students vs. Ontario Scholars Only | The report printed in the following order:
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. | ||
Diploma/Certificate | The diploma earned by the student. | S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type |
Age | 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. |
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 |
Birth Date | The student's birth date. | [Students]DOB |
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. | S_ON_STU_XML_SCHOOL_ENROL_C.gender_type |
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. | Calculated |
Total [Diploma Type]:### OR 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. | Calculated |
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. | Calculated |
Grand Total | Grand total of all counted students, not including students with unknown gender or age. | Calculated |
