OnSIS Verification Summary- Section G2
Section G2 - Native Language by Credits Summary - Secondary Only
The Section G2 (Native Language by Credits - Summary) report collects the aggregate data of all students who have an Active status as of the last day of the submission period in the current year. This report is only for students who are enrolled in the Native language. The data is collected by grade and the number of students enrolled in the Native language.
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 the Exclude From State Reporting ([Schools]State_ExcludeFromReporting) checkbox selected are not included.
Student Selection
For the selected academic year, School BSID, Submission type, select all students from the school enrolment permanent table:
Select students from the school enrolment permanent table where the Board Residence Status Types (S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type) are 01 - Pupils of the Board or 06 - Independent Studies.
For Other students, the counts include the following Board Residence Status Types:
02 - Native Education Authority
03 - Government of Canada
05 - Study permit/Temp resident
07 - Other student
All other Board Residence Status Types are excluded.
Exclude fully high-credit students:
Students with high credit full-time equivalent value more than zero and the full-time equivalent value of zero (STUDENT_SCHOOL_ENROLMENT. HIGH_CREDIT_FTE > 0 and STUDENT_SCHOOL_ENROLMENT.FTE = 0).
Students with high credit independent study average daily enrolment value more than zero and independent study average daily enrolment value equal to zero (STUDENT_SCHOOL_ENROLMENT.HIGH_CREDIT_ADE > 0 and STUDENT_SCHOOL_ENROLMENT.ADE = 0).
The report 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 is null.
For June submission, the Enrolment End Date must be July 1st. To add flexibility, a student is considered active if the Enrolment End Date is greater than the Count Date, and
Students that have records in the S_ON_STU_XML_SECOND_LANG_C table where the S_ON_STU_XML_SECOND_LANG_C type is either 027 (NL - Native) or 031 (Private - Native).
Course selection
Ministry Defined Courses (MDC) (S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs) begin with “LNA”, “LNC”, “LND”, “LNL”, “LNM”, “LNN”, and “LNO”. “LNG”
Dual Credit Courses (DCC) are excluded, i.e., S_ON_STU_XML_CLASS_ENROL_C E. Institution_Type must be NULL.
Locally Developed Courses (LDC) are excluded.
Credit is taken from the student class enrolment Credit_Value field(S_ON_STU_XML_CLASS_ENROL_C .Credit_Value).
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. Submission Period + School Type + 'School'. | Defined at report run time |
Grade | The student's grade. Students must be less than 21 years to be listed under grade levels. | [S_ON_STU_XML_SCHOOL_ENROL_C] GRADE_TYPE |
Cree (1) Credit, (2) Credits | Prints the count of students enrolled in Cree. | Count of students for the grade, and enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNC count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Ojibwe (1) Credit, (2) Credits | Prints the count of students enrolled in Ojibwe. | Count of students for the grade, and enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNO count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Delaware (1) Credit, (2) Credits | Prints the count of students enrolled in Delaware. | Count of students for the grade, and enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LND count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Mohawk (1) Credit, (2) Credits | Prints the count of students enrolled in Mohawk. | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNM count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Cayuga (1) Credit, (2) Credits | Prints the count of students enrolled in Cayuga. | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNA count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Oneida (1) Credit, (2) Credits | Prints the count of students enrolled in Oneida. | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNN count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Oji-Cree (1) Credit, (2) Credits | Prints the count of students enrolled in Oji-Cree. | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNL count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Inuktitut (1) Credit, (2) Credits | Prints the count of students enrolled in Inuktitut | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNI count under (1) if ON_STU_XML_CLASS_ENROL_C .Credit_Value = 1 and under (2) if ON_STU_XML_CLASS_ENROL_C .Credit_Value > 1 |
Algonquin (1) Credit, (2) Credits | Prints the count of students enrolled in Algonquin. | Count of students for the grade, and is enrolled in S_ON_STU_XML_CLASS_ENROL_C.Ministry_Dfnd_Crs begins with LNG |
Pupils of the Board | The students whose Board Residence Status types are 01 - Pupils of the Board or 06 - Independent Studies. | Total number of students for the grade ( enrolled in all Native languages) where S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type = 01 or 06 |
Other Students | The total number of Other students (that are not Pupils of the Board students). | Calculated |
Total Students | The total number of students, including Pupils of the board and Other students. | Calculated |
Student 21 or over | The count of students that are 21 years or older for the different Native language columns. | Calculated |
Number of students enrolled in both French as a second language and Native Language | The count of students enrolled in both French as a second language and Native Language. | Total number of students that has at least one of the Native languages and S_ON_STU_XML_SECOND_LANG_C table where the S_ON_STU_XML_SECOND_LANG_C.type is one of ('001','002','003' or '006') |