OnSIS Verification Summary - Section N
Section N - Enrolment by Class - Elementary Only
The Section N (Enrolment by Class) report collects the aggregate class enrolment figures for regular and Special Ed students who have an Active status as of the count date of the submission. The data is sorted by the class code in ascending order. You can run this report for different submissions (October, March, and June) and only for elementary schools.
It is required to import OnSIS PAE files and save OnSIS XML prior to running this 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 are not included.
Student Selection
Select the student from the school enrolment permanent table where S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type <> 08 ( Shared). Shared 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.
Only students enrolled in classes are included in the summary counts and displayed in the details report. That is, students that are not in any class are not be included in the report.
Report Output
See OnSIS Verification Summary - Section N 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. | Defined at report run time. |
Class | The total number of students enrolled in a class (JK, K, 01, 02, ...08). | [S_ON_STU_XML_CLASS_S]CLASS_CODE |
Grade | The total number of students in a grade for each class. This row does not include Special Education students whose Special Education Placement Type = Fully Self-Contained ("F") or Partially Integrated ("P"). | [S_ON_STU_XML_SCHOOL_ENROL_C] GRADE_TYPE |
Special Education | The total number of students enrolled in the class indicated on the row, and according to the student grade and who are Special Education Students: This only include those Special Education Students whose Special Education Placement Type = Fully Self-Contained ("F") or Partially Integrated ("P"). 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 segments (multiple records in S_ON_STU_XML_SPED_C), the student must be counted once in the report.
|
Total (column) | The total number of students counted for every column. | Calculated |
Total (row) | Only two cells should be populated
| Calculated |