Skip to main content
Skip table of contents

OnSIS Verification Detail - Section J

Section J - Education for Students Receiving Special Education Programs and Services - Elementary and Secondary

The Section J (Education for Students Receiving Special Education Programs and Services - Details) report collects details of the native language and grade for students who have an Active status as of the count date of the submission. The details report lists individual student information for students included in the OnSIS Verification Summary - Section J report. You can run this report only for elementary and secondary schools.

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 that have the Exclude From State Reporting ([Schools]State_ExcludeFromReporting) checkbox selected are not included.

Student Selection

  • For the selected academic year, School BSID, Submission type, select all students from the school enrolment permanent table who have records in the S_ON_STU_XML_SPED_C.

  • Select students from the school enrolment permanent table where the Board Residence Status Types are not 08 and 09 (S_ON_STU_XML_SCHOOL_ENROL_C.Stu_Brd_Res_Stat_Type <> ‘08' shared and <> '09’ e-learning)

  • List only records where the Non-Identified Student Flag is ON or the Main Exceptionality Flag is ON (to avoid counting the student more than once).

  • 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 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.

Report Output

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




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. Submission Period + School Type + 'School'.

Defined at report run time.

Students are grouped by their Exceptionality and Setting.


Only exceptionalities with students are listed here.

  • Non-identified students are displayed first, grouped by placement.

  • The rest of the students display, grouped by exceptionality, and then placement. Exceptionalities are displayed in the same order as in the summary report.



Setting (or placements) are displayed in this column and are sorted as follows:

Fully self-contained, Partially integrated, Withdrawal assistance, Resource assistance, and Indirect service.

Only placements with students should be displayed.



The student's OEN. The field is nine digits (format: ###-###-###).


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


The student's grade.


Age 21 +

This box is selected if the student's age is 21 or over as of December 31st of the current school academic year.



This box is selected if the student's individual education plan is turned on.

[S_ON_STU_XML_SPED_C]Individual_Edu_Plan_Flag is ON

Main Exceptionality

This box is selected if the student's main exceptionally flag is T.

[S_ON_STU_XML_SPED_C.S_ON_STU_XML_SPED_C]Main_Exceptionality_Flag = T

JavaScript errors detected

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

If this problem persists, please contact our support.