Skip to main content
Skip table of contents

OnSIS Verification Detail - Section B

Section B - Enrollment by Grade and Gender Details Report

The Section B (Enrolment by Grade and Gender Details) report collects aggregate figures for all students by grade, gender, and who have an Active status as of the count date of the submission. You can run this report for either elementary or secondary schools. The details report lists individual student information for students included in the OnSIS Verification Summary - Section B 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.

Report Output

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

FieldDescription[Table]FieldName
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 in a grade are grouped by gender in the order of M, F, S, and N. Each gender is sorted by birth date and then OEN or student name.

Note: Students with unidentified or invalid gender is not counted in the summary report but is printed on the details report

GradeThe student's grade.S_ON_STU_XML_SCHOOL_ENROL_C.GRADE_TYPE
GenderThe student's gender.S_ON_STU_XML_SCHOOL_ENROL_C.GENDER_TYPE
OENThe 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

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.

Special Education

This checkbox must be selected for special education students.

Special Educations students are

  • Students with records are in S_ON_STU_XML_SPED_C and
  • Students whose Special Education Placement Type = Fully Self-Contained (“F”) or Partially Integrated (“P”) and
  • Special Education Placement Type is based on the Main exceptionality or the Non-identified student (Special_Education.MAIN_EXCEPTIONALITY_FLAG = “T” OR Special_Education.NON_IDENTIFIED_STUDENT_FLAG = “T”)

If a student has multiple special education segment, the student is included once in the report.

  • when multiple records are found, the report must display the student under the special education section, based on the SPED record where tthe S_ON_STU_XML_SPED_C .MAIN_EXCEPTIONALITY_FLAG = “T” and has at least one placement type in ('F','P'), then that student show under special education section.
  • else based on the SPED record where the S_ON_STU_XML_SPED_C .NON_IDENTIFIED_STUDENT_FLAG = “T” and has at least one placement type in ('F','P'), then that student show under special education section.

  • Otherwise the student is counted as Regular students and the Special Education flag is set OFF

Total for Grade

The total number of students by grade and gender (M, F, S, and N).Calculated
Total StudentsThe total number of students listed in the report.Calculated
JavaScript errors detected

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

If this problem persists, please contact our support.