Skip to main content
Skip table of contents

OnSIS Verification Detail - Section G1

Section G1 - Native Language by Minutes Details - Elementary Only

The Section G1 (Native Language by Minutes - Details) report collects details of the native language by grades for students who have an Active status as of the count date of the submission. In addition, the details report lists individual student information for students included in the OnSIS Verification Summary - Section G1 report. You can run this report only for elementary schools.

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 not included.

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 Inuktitut

  • Other values are ignored

Report Output

See Understanding the Report Output Table for a definition of each column in the table.

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.Defined at report run time
Students are grouped by Language and Grade.
LanguageOnly Native languages where students are enrolled.


020' Cree

‘021’ Ojibwe

‘022’ Delaware

‘023’ Mohawk

‘024’ Cayuga

‘025’ Oneida

‘026’ Oji-Cree

''028' Inuktitut

GradeThe student's grade. Between KJ, SK, 01, 02, ...07, and 08[S_ON_STU_XML_SCHOOL_ENROL_C] GRADE_TYPE
OENThe student's OEN. The field is nine digits (format: ###-###-###).[S_ON_STU_XML_School_Enrol_C]OEN
Student Name

The student's name (last name, first name).

[S_ON_STU_X]Legal_Last_Name or [Students]Last_Name

[S_ON_STU_X]Legal_First_Name or [Students]First_Name

Number of MinutesThe number of minutes of instruction for the native language. The field has a total of five digits with two digits after the decimal (format: ###.##).[S_ON_STU_XML_SECOND_LANG_C.Type]Minutes_Per_Day_Of_Instr
Native and FrenchThis box is selected when a student is enrolled in French as a second language and Native Language.Flag selected if student also has a record in S_ON_STU_XML_SECOND_LANG_C table where Type is one of ('001','002','003' or '006')
Pupils of the BoardThis box is selected for 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
Other StudentsThis box is selected when the student is not Pupils of the Board student.S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type <> 01
JavaScript errors detected

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

If this problem persists, please contact our support.