OnSIS Verification Summary - Section G1
Section G1 - Native Language by Minutes Summary - Elementary Schools Only
The Section G1 (Native Language by Minutes - Summary) report collects the aggregate data of all students with 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, the number of students enrolled in that native language, and the minutes of instruction.
Selection Criteria
Selection criteria determine which database records are used in the report. When the report does not return the correct records, analyze the selection criteria for issues.
School Selection
Schools with the Exclude From State Reporting ([Schools]State_ExcludeFromReporting) checkbox selected are excluded.
Student Selection
For the selected academic year, School BSID, and Submission type, select all students from the school enrolment permanent table:
Select students from the school enrolment permanent table whose Board Residence Status Types is not 08 (S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type <> 08). Shared students are excluded from the report.
The report includes only Active Students: Students must not have an Enrolment End Date before 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 one of the following:
020 Cree
021 Ojibwe
022 Delaware
023 Mohawk
024 Cayuga
025 Oneida
026 Oji-Cree
028 Inukitut
029 Algonquin
Other values are ignored
Report Output
Refer to 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 is selected on the report run page. Submission Period + School Type + 'School'. | Defined at report run time |
Grade | The student's grade. Only elementary grades between KJ, SK, 01, 02, ...07, and 08. | [S_ON_STU_XML_SCHOOL_ENROL_C] GRADE_TYPE |
Cree Number of students | Prints the count of students enrolled in Cree. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = ‘020' |
Cree MOI | Prints the average count of minutes for students enrolled in Cree. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of Instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Cree Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Ojibwe Number of students | Prints the count of students enrolled in Ojibwe. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '021' |
Ojibwe MOI | Prints the average count of minutes for students enrolled in Ojibwe. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of Instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Ojibwe Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Delaware Number of students | Prints the count of students enrolled in Delaware. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '022' |
Delaware MOI | Prints the average count of minutes for students enrolled in Delaware. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Delaware Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Mohawk Number of students | Prints the count of students enrolled in Mohawk. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '023' |
Mohawk MOI | Prints the average count of minutes for students enrolled in Mohawk. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Mohawk Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Cayuga Number of students | Prints the count of students enrolled in Cayuga. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '024' |
Cayuga MOI | Prints the average count of minutes for students enrolled in Cayuga. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of Instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Cayuga Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Oneida Number of students | Prints the count of students enrolled in Oneida. | Count of students for the grade and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '025' |
Oneida MOI | Prints the average count of minutes for students enrolled in Oneida. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of Instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Oneida Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Oji-Cree Number of students | Prints the count of students enrolled in Oji-Cree. | Count of students for the grade, and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '026' |
Oji-Cree MOI | Prints the average count of minutes for students enrolled in Oji-Cree. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Oji-Cree Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Inuktitut Number of students | Prints the count of students enrolled in Oji-Cree. | Count of students for the grade, and enrolled where [S_ON_STU_XML_SECOND_LANG_C ] TYPE = '026' |
Inuktitut MOI | Prints the average count of minutes for students enrolled in Oji-Cree. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of instruction. Print (Total Number of Minutes / Total Number of Students enrolled in Oji-Cree Native Language). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Algonquin Number of students | Prints the count of students enrolled in Algonquin. | Count the number of students for the grade, where [SECOND_LANGUAGE_PROGRAM]TYPE = ‘029’ |
Algonquin MOI | Prints the average count of minutes for students enrolled in Algonquin. The field has a total of five digits with two digits after the decimal (format: ###.##). | Calculate the average number of minutes of instruction per day (Total Number of Minutes / Total Number of students enrolled in Algonquin). Based on [S_ON_STU_XML_SECOND_LANG_C ] Minutes_Per_Day_Of_Instr |
Pupils of the Board | The total number of students whose Board Residence Status types are 01 - Pupils of the Board. | 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 |
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') |