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.
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. |
Students are grouped by diploma/certification type and types of exceptionalities. Each exceptionality is sorted by age, OEN or student name. | ||
Diploma/Certificate | The diploma earned by the student. | S_ON_STU_XML_SCHOOL_ENROL_C.Diploma_Type |
Exceptionality | Student's Exceptionality | S_ON_STU_XML_SPED_C .Exceptionality_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 |
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 | S_ON_STU_XML_SPED_C .NON_IDENTIFIED_STUDENT_FLAG = "T |
Total [Diploma/Certificate]: | Total number of special education students that earned this diploma. | Calculated |
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. | Calculated |
