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.

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 OR [Schools]alternate_school_number is equal to the alternative school number selected on the report run page.
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 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
Grade	The student's grade.	S_ON_STU_XML_SCHOOL_ENROL_C.GRADE_TYPE
Gender	The student's gender.	S_ON_STU_XML_SCHOOL_ENROL_C.GENDER_TYPE
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
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 Students	The total number of students listed in the report.	Calculated