OnSIS Verification Detail - Section N
Section N - Enrolment by Class - Elementary Only
The Section N (Enrolment by Class - Detail) report collects the Enrolment by Class information for elementary students. The report is grouped by class code and grade. The regular and Special Ed students are listed separately. You can run this report at the district and school level, for different submissions (October, March, and June),. This detailed report lists individual student information for students included in the OnSIS Verification Detail - Section N report.
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 Detail - 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 Submission Period + School Type + "School" |
The report lists students grouped by class and grade.. | ||
Class Code | The report is grouped by class and then by grade. This is the list of all class codes in S_ON_XML_CLASS_S. The Class Code can be up to 25 characters. | [S_ON_STU_XML_CLASS_S]CLASS_CODE |
Grade | The student's grade. JK, K, 01, 02, ...08 | [S_ON_STU_XML_SCHOOL_ENROL_C] GRADE_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 [S_ON_STU_X]Legal_Middle_Name, if blank then [Students]Middle_Name |
Special Education | This box should be selected if the student is a special education student.
| If a student has multiple special education segment (multiple records in S_ON_STU_XML_SPED_C), the flag must be checked for the student
|
Total for Grade | The total number of students in the grade, regular students, and then Special Ed students. SPED is the total count of special education students for the grade | Calculated |
Total Students for the Class Code | The total number of students in the class for all grades, excluding sped students. SPED is the total count of special education students for all grades | Calculated |
Grand Total | The total number of students listed in the report, excluding SPED students. SPED is the total count of special education students listed in the report. | Calculated |