EQAO Extracts

Introduction

This report creates Excel or XML files to be submitted to the EQAO for the Grade 9 Winter and Spring Math Assessments, the Grade 10 Literacy Assessment, the Grade 3/6 Math, Reading and Writing Assessments, the Grades 4/8 Trends in International Mathematics and Science Study (TIMSS), the Grades 7-12 Programme for International Student Assessment (PISA) and the Grade 4 Progress in International Reading Literacy Study (PIRLS) and the Grade 8 Pan Canadian Assessment Program (PCAP).

Selection Criteria

For all extracts, students are excluded from the extract when:

The student's attendance type (EnrollmentType field = 'EX' for the Students or ReEnrollments record) is associated, in whole or in part, with the run date (i.e., if there is any overlap between the enrolment start and end dates and the run date)
The student is excluded from Provincial Reporting

Selection Criteria - Grade 3 & 6

The student is included in Grade 3 and 6 extract when:

The student is currently enrolled in grade level 3 or grade level 6
The student is actively enrolled (enroll_status = 0)
The student's entry date is prior to or equal to the current date

Selection Criteria - Grade 9 Math (Winter and Spring)

The student is included in the Grade 9 Math (Winter and Spring) extract when:

The student is actively enrolled (enroll_status = 0).
The student's entry date is prior to or equal to the current date.
The student is enrolled in an Applied or Academic Math Course:
- The course end date is between the date range provided at run time.
- Course Number (or Alternate Course Number) starts with the letter 'M' the 4^th/5^th character is '1P' (applied) or '1D' (academic) or '1W'.
- The course is not a locally developed (course type = L) or mathematics credit recovery program (where class type = credit recovery or Other course information Credit recovery flag is selected).
- When running the report for Winter, Course enrolment must be in the 1^st semester.
- When running the report for Spring, Course enrolment must be in the 2^nd semester.
- The course is not a co-op course tied to an applied or academic math course ([S_ON_SEC_X]Delivery_Type = '4').
Full-time remote learning students are only included if the 'Include FT remote learning' flag is selected at run time.

In the rare situation that a student is enrolled in more than one 'qualifying' math course for a period, Winter or Spring Administration, only the Academic Math Course record is extracted as it is a higher-level course.

Selection Criteria - Grade 10 OSSLT

The student is included in the Grade 10 OSSLT extract when:

The student is currently enrolled in grade level 10 or higher
The student is actively enrolled (enroll_status = 0), or (to support quadmester/octomester schools) is preregistered for the future
Student is working towards his OSSD (1) OR OSSD/SHSM (4) or if the diploma type is not defined (Diploma Type is Blank)
Students are reported in 1A submission and in 1B submissions only if "Include Students from 1A who have not been successful" flag is set to ON
- Students with previous year Historical Grades (storedgrades) Course Number (or Alternate Course Number) contains) contains 'NBE', 'ENG', 'ESL' or 'ELD'
Students reported in 1A and 1B submissions
- Students with current year Historical Grades (storedgrades) Course Number (or Alternate Course Number) contains 'NBE','ENG', 'ESL' or 'ELD' and the course falls in a term whose last day falls in the date range defined at the report input page. (1st-semester courses, can be included by selecting a wider date range)
- Students with current or prior Class Enrollments (CC) Course Number (or Alternate Course Number) contains 'NBE','ENG', 'ESL' or 'ELD' and the course falls in a term whose last day falls in the date range defined at the report input page. (1st-semester courses, can be included by selecting a wider date range)
- Pre-registered students with future Class Enrollments (CC) (CC) Course Number (or Alternate Course Number) contains 'NBE','ENG', 'ESL' or 'ELD' and the course falls in a term whose last day falls in the date range defined at the report input page.
Student meets one of the following criteria:
The student did not take the OSSLT-E or OSSLT-F test, OR
The student did take the OSSLT-E or OSSLT-F test, and none of the tests have an alpha score of 1 or A, OR
Any of the tests that fall in the current school year or last year's summer school after 7/1 have an alpha score of OLC or CCL

Alpha scores are:

1 (Successful)
2 (Unsuccessful)
3 (Student was absent)
4 (Previously eligible student fulfilling the requirement through the OSSLC)
5 (Student was deferred to the next administration of the OSSLT)
6 (Exempt this administration)
OLC or CCL (Requirement fulfilled through the OSSLC)
10 (Results are being withheld by EQAO.)
A (Adjudicated)

Deferred and exempt students are included in both 1A and 1B submissions.

Selection Criteria - Trends in International Mathematics and Science Study (TIMSS)

The student is included in the Trends in International Mathematics and Science Study (TIMSS) extract when:
The student is currently enrolled in grade level 4 or grade level 8
The student is actively enrolled (enroll_status = 0)
The student's entry date is prior or equal to the current date
The student is enrolled in a school that is flagged as "Is an EQAO TIMSS School" on the District Setup, Schools/School Info, Ontario Provincial Information page

Selection Criteria - Programme for International Student Assessment (PISA)

The student is included in the Programme for International Student Assessment (PISA) extract when:

The student is a 15-year-old born in 2007 (between January 1, 2007 and December 31, 2007.
The student is currently enrolled in grade levels 7 through 12
Student is actively enrolled (enroll_status = 0)
Student's entry date is prior or equal to the current date
The student is enrolled in a school that is flagged as "Is an EQAO PISA School" on the District Setup, Schools/School Info, Ontario Provincial Information page

Selection Criteria - Progress in International Reading Literacy Study (PIRLS)

The student is included in the Progress in International Reading Literacy Study (PIRLS) extract when:

The student is currently enrolled in grade level 4, (for 2021-2022, student is currently enrolled in grade level 5)
The student is actively enrolled (enroll_status = 0)
The student's entry date is prior or equal to the current date
The student is enrolled in a school that is flagged as "Is an EQAO PIRLS School" on the District Setup, Schools/School Info, Ontario Provincial Information page

Selection Criteria - Pan Canadian Assessment Program (PCAP)

The student is included in the Pan Canadian Assessment Program (PCAP) extract when:

The student is currently enrolled in grade level 8
The student is actively enrolled (enroll_status = 0)
The student's entry date is prior to or equal to the current date
The students are enrolled in a school that is previously flagged as "Is an EQAO PCAP Schools" on the District Setup, Schools/School Info, Ontario Provincial Information page

Report Input

For help with navigation and running the report, refer to How to Find and Generate a Report.

Field	Description
Current Selection Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only - Run the report for students in the current selection. All students - Run the report for all students in the current school or district that meet the selection criteria. The default is "All Students". If you are running the report for a single student, or group of students, select the students prior to running the report.
Select Assessment	Options available depend on the school grade levels. The extracts are available for: Grade 3 and 6 Grade 9 Math Spring Grade 9 Math Winter Grade 10 OSSLT Grades 4 and 8 TIMSS Grades 7 to 12 PISA Grade 4 PIRLS, (Note: for 2021-2022 students in grade 5 are selected) Grade 8 PCAP
Select Output Format	Select from EXCEL or XML The XML output does not require any editing before uploading it to the Ministry. It is ready to be submitted without any additional steps.
Use School Entry Date Field	Valid only for Grades 3 and 6, Grade 9 Math, and Grade 10 OSSLT extracts. Indicate how the 'Date Entered School' field in the extract will be defined: If selected, the 'Date Entered School' extract field is the value entered in the School Entry Date field on the Modify Info student data entry page. If not selected, 'Date Entered School' is the earliest entry date from the latest set of consecutive Students/ReEnrollments records for the student for the school running the report. For Grade 9 Math and Grade 10 OSSLT Extracts If not selected, the report gets the earliest entry date from the latest set of consecutive Students/ReEnrollments records for the student for the school running the report and prints the Transcript Entry Date if defined, or prints the entry date.
Use District Entry Date Field	Valid only for Grades 3/6, Grade 9 Math, and Grade 10 OSSLT extracts. Indicate how the 'Date Entered Board' field in the extract will be defined: If selected, the 'Date Entered Board' extract field is the value entered in the District Entry Date field on the Modify Info student data entry page. If not selected, 'Date Entered Board' is the earliest entry date from the set of Students/ReEnrollments records for a student. For Grade 9 Math and Grade 10 OSSLT Extracts If not selected, the report gets the earliest entry date from the set of Students/ReEnrollments records for the student and prints the Transcript Entry Date if defined, or prints the entry date.
Report Parameters for EQAO 9 Winter, EQAO 9 Spring, and EQAO 10 OSSLT
Include Courses Ending between	Mandatory and Valid only for Grade 9 Math Winter/Spring and for Grade 10 OSSLT. Due to the new Quadmester, and Octomester models used in the 2020-2021 school year, testing for Grade 9 Math will need to be done more frequently and students need to be able to write the assessment at or near the end of the course. This date range is used by the report to pick up only students enrolled in Math classes that have finished during the specified date range. Also used to report students for Grade 10 OSSLT who are enrolled/completed the English class during that date range. To include students who were sent in the OSSLT 1A submission again in the 1B submission, select a date range that includes first semester courses. Dates selected must be within the currently selected school year When the selected Assessment is Math grade 9: If the selected submission is winter, then the range of dates should be on or before semester 1 end date. If the selected submission is Spring, then the range of dates should be after semester 1 end date
Include FT remote learning	Select this flag if you want to include FT remote learning. Grade 9 Math: When Flag is selected, students are included if any of the following is true: Student enrolled in a Math class [S_ON_SEC_X]Delivery_Type is 18 or 19 Students enrolled in a Math class in a school where the school learning preference is set to 02 (FT Remote learning) If the school learning preference is not defined and Instruction Mode value on the student's grade 9 Math CC enrolment, section or course is set to (02) FT Remote learning Grade 10 OSSLT: When Flag is selected, students are included if a value of '2' (full time remote) reported for their learning format field. refer to learning format for details.
Select Grouping	Valid only for Grade 10 OSSLT extract. Indicate how the fields will be grouped in the extract: Group by Homeroom - the field is set based on student's homeroom. Group by English Course Section - the field is set based on student's eligible English course.
Assessment Period	Select the period you are running the assessment for. This field is mandatory for Grade 10 OSSLT. Available options (1A - September, 1B - February.).
Include Students from 1A who have not been successful	Select this flag to Include students enrolled in previous years' courses and have no courses this year in the 1B submissions. Those students are included in the 1A submission by default.
Homeroom Period For Secondary PISA Students	Valid only for the PISA extract. Select the period in which the homeroom class for secondary students (Grades 9 - 12) meets. If the report is run from a school, the dialog box contains values from 1 to the highest period for the school. If run from the district, the dialog box contains a unique set of periods across all schools. This parameter does not affect the method in which the homeroom class is determined for elementary students. The period abbreviation appears in parentheses after the period number.

Report Output

The resulting file extract will use the file naming convention "EQAO_#####(#)_aa_yyyy.xls" where:

"#####(#)" is the five-digit ministry-assigned board identification number or the six-digit ministry-assigned school identification number.
- When the report is run for the district, all alpha characters are removed from the District Number and the first 5 numeric characters are used.
- When the report is run for the school, the Alternative School Number is used if entered. Otherwise, the School Number is used.
"aa" is the assessment Period (see table below)
"yyyy" represents the year the report is being run (example: 2021 represents the 2020-2021 school year).

Assessment	"aa" value
Grade 9 Assessment of Mathematics, Winter 2023	9A
Ontario Secondary School Literacy Test (OSSLT)	1A, 1B
Assessments of Reading, Writing and Mathematics, Primary and Junior Divisions, Spring 2023	36
Grade 9 Assessment of Mathematics, Spring 2024	9B
Trends in International Mathematics and Science Study (TIMSS), 2022	TI
Programme for International Student Assessment (PISA), 2023	PI
Progress in International Reading Literacy Study (PIRLS), 2022	IR
Pan Canadian Assessment Program (PCAP) Extract, 2016	PC

Grade 3 and 6 Output

The Report Name on the Report Queue page includes " _#####(#)_36_Y1Y2" where "#####(#)" is the five-digit ministry-assigned board identification number or the six-digit ministry-assigned school identification number. Y1Y2 represents the year the report is being run (example: 1516 represents the 2015-2016 school year). See EQAO Extracts for a definition of each column in the table.

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered
StudentOEN	The Ministry-assigned Ontario Education Number. For use only by schools not required by the ministry to assign OENs.	[Student]State_StudentNumber Extract # if not entered
SASN	The Board- or school-assigned student identification number.	[Students]Student_Number Extract # if not defined.
StudentType	The student is home-schooled or enrolled in a Section 23 program (for school boards only). Only independent schools may submit the value "#".	Student type "1" (home schooled) is not generated as currently no boards send these students from PowerSchool. This functionality will be added if the need arises. Set to "2" if [S_ON_SCH_X]Section23_Flag is on Otherwise, extract #
EnrolledOntario	The student has been enrolled in publicly-funded education in Ontario for the past two years. Valid values: # = No 1 = Yes	If the school running the report is a private school, value is # for No. If the student has ReEnrolment records in any school in the board in both of the previous two school years, the value is 1 for Yes. If the student has no ReEnrolment records for the previous two school years, and the entry code on the student's earliest enrolment records for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes. If the student has no ReEnrollment record for one year previously, but has a record for two years previously, and the entry code for the student's earliest enrolment record for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes If the student has no ReEnrollment record for two years previously, but has one for last year and, the entry code for the student's earliest enrolment record for the previous school year is not 09,19, 27,29, 30, 31, 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes Night and Summer schools enrolments and No Show (NS) and records where the start date = end date are ignored in the above calculation.
OutOfProvinceResidence	The student's permanent residence is outside Ontario.	OutOfProvinceResidence is set to '1' when StatusInCanada is 4 (Study Visa), 5 (Other Visa or 6 (None of the above). When StatusInCanada is set to other value: OutOfProvinceResidence is set to 1 if Country (Current Residence) is not empty and is not Canada. OutOfProvinceResidence is set to 1 if Province (Current Residence) is not empty and is not Ontario. Otherwise, OutOfProvinceResidence is set to '#'.
StatusInCanada	The legal status of the student in Canada. Populated from State/Province - ON, General Info, Citizenship/Immigration, Residence Status.	IF [S_ON_STU_X]Residence_Status = 0 or NULL, THEN # is extracted, Otherwise: If [S_ON_STU_X]Residence_Status = 2 - Native Ancestry, THEN StatusInCanada = 1 - Canadian Citizen If [S_ON_STU_X]Residence_Status = 3 - Permanent Resident, THEN StatusInCanada = 2 - Permanent Resident If [S_ON_STU_X]Residence_Status = 7 - Refugee Status, THEN StatusInCanada = 3 - Refugee Status IF [S_ON_STU_X]Residence_Status = 12 - Study Permit/Visitor Record OR 14 - Exchange Student, THEN StatusInCanada = 4 - Study Visa IF [S_ON_STU_X]Residence_Status = 13 - Diplomat Status/Minister's Permit, OR 15 - Parents' study permit, OR 16 - Parents work permit, THEN StatusInCanada = 5 - Other Visa IF [S_ON_STU_X]Residence_Status = 99 - Not Applicable OR 98 - Other Status, THEN StatusInCanada = 6 - None of the above, Otherwise, [6 - None f the above]
IndigenousType	In accordance with the board's policy for voluntary, confidential Indigenous student self-identification, this Indigenous student has voluntarily self-identified as: a First Nation student who lives in the jurisdiction of and attends a provincially funded elementary or secondary school or who lives in a First Nation community and attends a provincially funded elementary or secondary school under a tuition agreement; a Métis student who attends a provincially funded elementary or secondary school; or an Inuit student who attends a provincially funded elementary or secondary school. Populated from: State/Province - ON, General Info, Provincial Reporting, Indigenous Self Identification. Only the value "#" may be submitted by independent schools.	[S_ON_STU_X]Aboriginal_Type When 002, 2 is extracted When 003, 3 is extracted When 004, 4 is extracted Otherwise, # is extracted
Grade	The grade in which the student will be writing the assessment.	[Students]Grade_Level [ReEnrollments]Grade_Level
LearningFormat	The learning format of the student. Display valueDescription1Full-time in-person learning2Full-time remote learning3Combination of in-person and remote learning	[S_STU_LEARNINGPREF_C]LearningPreference Student Learning Preference (Learning preference page) as of the report date. The report uses the Alternate Report code if defined otherwise the code is used. If Student Learning Preference is not defined, the school Learning Preference defined on the school page is used. Otherwise, extract 1 (Full time in-person learning)
FrenchImmersion	This student is in a French Immersion class.	Extract 1 if either of the following are true: Student is enrolled in a French class - [Courses]Alt_Course_Number or [Courses]Course_Number = 'FRE-10' and [S_ON_CRS_X]Lang_Pgm_Type = 'I' (or if null,[S_ON_CRS_X]Lang_Pgm_Type = 'I') Student is enrolled in a French Immersion program - [SpEnrollments]ProgramId points to a GEN record where [S_ON_GEN_SPECPROG_X]French_Flag is on and [GEN]Value2 (second language program type) = '003' (immersion) Otherwise extract #
ClassTeacherFirstName	The student's homeroom class teacher's first name. 'No Teacher,' is reported when there is no teacher assigned to ClassCode or if the student is not assigned to a homeroom	[UserCorefields]PSCore_Legal_First_Name] if blank then [Users]First_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassTeacherLastName	The student's homeroom class teacher's last name. 'No Teacher,' is reported when there is no teacher assigned to ClassCode or if the student is not assigned to a homeroom	[UserCorefields]PSCore_Legal_Last_Name] if blank then [Users]Last_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassCode	The student's homeroom class code ID. 'SPARE,' is reported when the student is not assigned to a homeroom	[Sections]Course_Number + '-' + [Sections]Section_Number for class where [S_ON_CRS_X]Course_Type = 'H'
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
DateEnteredSchool	Date student entered current school. This date is based on the most recent date of entry.	[S_ON_STU_X]transcriptentrydate if it exists otherwise [Students]SchoolEntryDate, if it exists, otherwise Obtain earliest [Students/Reenrollments]entrydate from latest set of consecutive records for the school otherwise Extract #
DateEnteredBoard	The date student entered current board. This date is based on the most recent date of entry.	[Students]DistrictEntryDate, if it exists, otherwise Obtain minimum entrydate from ps_enrollment otherwise Extract #
FirstLanguage	This student learned English as his or her first language at home. Populated from State/Province - ON, General Info, Provincial Reporting, First Language	Extract # when [S_ON_STU_X]First_Language is 0 or null) Extract 1 when [S_ON_STU_X]First_Language = E (English) or B (English and French) Extract 2 when [S_ON_STU_X]First_Language is other than = E or B or 0 or null
BornOutsideCanada	This student was born outside Canada.	Extract # when [S_ON_STU_X]Birth_Country = 0, null, 988 or 999 Extract 2 when [S_ON_STU_X]Birth_Country = 'CAN' Extract 1 when [S_ON_STU_X]Birth_Country not equal to any of the values above.
TimeinCanada	Length of time this student has been in Canada if not born in Canada.	Compare [S_ON_STU_X]Year_Of_Entry to current date Extract 1 when less than one year. Extract 2 when one year or more but less than two years. Extract 3 when two years or more but less than three years. Extract 4 when three years or more but less than five years. Extract 5 when five years. Extract # when missing, unknown or not applicable.
Refugee	Student's refugee status. Indicates whether this student's family came to Canada as refugees. Valid values # = No 1 = Yes Populated from State/Province - ON, General Info, Citizenship/Immigration, Did this student's family come to Canada as refugees?	Refugee field is set to 1(Yes) if the StatusInCanada field in the EQAO Extract is set to 3 (Refugee) or if the Did this student's family come to Canada as refugees? flag is True; otherwise it is set to #(No)
JrKindergarten	Student has attended full-day junior kindergarten.	IF a [ReEnrollments] record exists for the student where [ReEnrollments]Grade_Level = -1 THEN set field to 1 ('This student attended full-day junior kindergarten) ELSE set field to # (Missing/Unknown)
SrKindergarten	Student has attended full-day senior kindergarten.	IF a [ReEnrollments] record exists for the student where [ReEnrollments]Grade_Level = 0 THEN set field to 1 ('This student attended full-day junior kindergarten) ELSE set field to # (Missing/Unknown)
ESLELD	This student is currently an English language learner.	derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrollment that qualifies as ESL/ELD
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
SpecEdNoExpectationReadWrite	The student is not working toward satisfying the language expectations in The Ontario Curriculum. As outlined in his or her IEP, the student is working on alternative language expectations as part of his or her educational program. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, No Expectations - Math And Reading/Writing, Reading	[S_ON_STU_X]EQAO_NoExpectRW Extract 1 if reading column selected, Otherwise extract #
SpecEdNoExpectationMath	The student is not working toward satisfying the mathematics expectations in the Ontario Curriculum. As outlined in his or her IEP, the student is working on alternative mathematics expectations as part of his or her educational program. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, No Expectations - Math And Reading/Writing, Math	[S_ON_STU_X]EQAO_NoExpectM Extract 1 if math column selected, Otherwise extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following IPRC Exceptionalities.	Extract 12 if multiple special education programs exist with different exceptionalities or if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 2 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 3 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 4 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 5 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 6 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 7 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 8 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 9 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 10 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 11 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, Otherwise extract #
ExemptionRead	This student has been exempted from reading in accordance with EQAO's policies. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, EQAO Exemption, Reading	[S_ON_STU_X]EQAO_ExemptR - Extract 1 if reading column selected, Otherwise extract #
ExemptionWrite	This student has been exempted from writing in accordance with EQAO's policies. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, EQAO Exemption, Writing	[S_ON_STU_X]EQAO_ExemptW - Extract 1 if writing column selected, Otherwise extract #
ExemptionMath	This student has been exempted from mathematics in accordance with EQAO's policies. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, EQAO Exemption, Math	[S_ON_STU_X]EQAO_ExemptM- Extract 1 if math column selected, Otherwise extract #
AccSignRead	This student will receive the following accommodation for reading: Sign language or an oral interpreter. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Sign Language Or Oral Interpreter, Reading	[S_ON_STU_X]SE_SignLR - Extract 1 if reading column selected, Otherwise extract #
AccSignWrite	This student will receive the following accommodation for writing: Sign language or an oral interpreter. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Sign Language Or Oral Interpreter, Writing	[S_ON_STU_X]SE_SignLW - Extract 1 if writing column selected, Otherwise extract #
AccSignMath	This student will receive the following accommodation for mathematics: Sign language or an oral interpreter. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Sign Language Or Oral Interpreter, Math	[S_ON_STU_X]SE_SignLM - Extract 1 if math column selected, Otherwise extract #
AccAssistiveTechRead	This student will receive the following accommodation for reading (presentation): An assistive technology version (an electronic version [e.g. Kurzweil, Premier] used with technology such as text-to-speech software, obtained from the secure section of EQAO's Web site). Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Presentation Devices, Write	Extract 1 if [S_ON_STU_X]SE_PresDevR = 1 - 'Other' Extract 2 if if [S_ON_STU_X]SE_PresDevR = 2 - 'Read&Write for Google' Otherwise extract #
AccAssistiveTechWrite	This student will receive the following accommodation for writing (presentation): An assistive technology version (an electronic version [e.g. Kurzweil, Premier] used with technology such as text-to-speech software, obtained from the secure section of EQAO's Web site). Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Presentation Devices, Write	Extract 1 if [S_ON_STU_X]SE_PresDevW = 1 - 'Other' Extract 2 if if [S_ON_STU_X]SE_PresDevW = 2 - 'Read&Write for Google' Otherwise extract #
AccAssistiveTechMath	This student will receive the following accommodation for mathematics (presentation): An assistive technology version (an electronic version [e.g. Kurzweil, Premier] used with technology such as text-to-speech software, obtained from the secure section of EQAO's Web site). Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Presentation Devices, Math	Extract 1 if [S_ON_STU_X]SE_PresDevM = 1 - 'Other' Extract 2 if if [S_ON_STU_X]SE_PresDevM = 2 - 'Read&Write for Google' Otherwise extract #
AccScribingRead	This student will receive the following accommodation for reading: Verbatim scribing of responses. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Verbatim Scribing Of Responses, Read	[S_ON_STU_X]SE_ScriptR - Extract 1 if reading column selected, Otherwise extract #
AccScribingWrite	This student will receive the following accommodation for writing: Verbatim scribing of responses. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Verbatim Scribing Of Responses, Write	[S_ON_STU_X]SE_ScriptW - Extract 1 if writing column selected, Otherwise extract #
AccScribingMath	This student will receive the following accommodation for mathematics: Verbatim scribing of responses. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Verbatim Scribing Of Responses, Math	[S_ON_STU_X]SE_ScriptM - Extract 1 if math column selected, Otherwise extract #
SpecPermTemp	This student has no IEP but has received the principal's permission for accommodations because of a temporary injury or condition. The accommodations have been indicated. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Temporary Injury Or Condition	[S_ON_STU_X]SP_Temporary - Extract 1 if Temporary Injury Or Condition selected, Otherwise extract #
SpecPermMoved	This student has recently arrived from another school and has no IEP but has received the principal's permission for accommodations. The accommodations have been indicated. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, New Student	[S_ON_STU_X]SP_Moved - Extract 1 if New Student selected, Otherwise extract #

Grade 9 Math (Winter and Spring) Output

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered.
StudentOEN	The Ministry-assigned Ontario Education Number. The OEN must be greater than 060-000-000.	[Students]State_StudentNumber. Extract # if not defined.
SASN	The Board- or school-assigned student identification number.	[Students]Student_Number. Extract # if not entered.
StudentType	This student is home-schooled, enrolled in a Section 23 program, an adult student, a mature student, enrolled in an e-learning course (see first note below), participating in an independent or private study course or to be issued an OSSD by the Independent Learning Centre. Please see "Accounting and Reporting EQAO Results for Student with Unique or Special Circumstances" for information on who to include in these categories. Use value "5" only for students enrolled in an e-learning course who do not reside within the jurisdiction of the school board offering the course. Only the values "#," "3" and "4" may be submitted by independent schools.	E IF [S_ON_SCH_X]Section23_Flag = 1, Extract 2 IF [S_ON_STU_X]Brd_Res_Status = 09, Extract 5 IF [S_ON_STU_X]Brd_Res_Status = 07 and [S_ON_SEC_X]IsIndependentStudy_Class or [S_ON_CC_X]IsIndependentStudy_Class = 1 for all of the student's current sections at runtime, Extract 6 IF [S_ON_STU_X]Mature_Student is null and student age >= 18 as of Aiugust 31st of the current school year, Extract 3 IF [S_ON_STU_X]Mature_Student = 1, Extract 4 IF [S_ON_STU_X]HomeSchooled = 1, Extract 1 ELSE set to #
EnrolledOntario	The student has been enrolled in publicly-funded education in Ontario for the past two years. Valid values: # = No 1 = Yes	If the school running the report is a private school, value is # for No. If the student has ReEnrolment records in any school in the board in both of the previous two school years, the value is 1 for Yes. If the student has no ReEnrolment records for the previous two school years, and the entry code on the student's earliest enrolment records for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes. If the student has no ReEnrollment record for one year previously, but has a record for two years previously, and the entry code for the student's earliest enrolment record for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes If the student has no ReEnrollment record for two years previously but has one for last year and, the entry code for the student's earliest enrolment record for the previous school year is not 09,19, 27,29, 30, 31, 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes Note: Night and Summer school enrolments and No Show (NS) and records where the start date = end date are ignored in the above calculation.
OutOfProvinceResidence	The student's permanent residence is outside Ontario.	OutOfProvinceResidence is set to '1' when StatusInCanada is 4 (Study Visa), 5 (Other Visa or 6 (None of the above). When StatusInCanada is set to other value: OutOfProvinceResidence is set to 1 if Country (Current Residence) is not empty and is not Canada. OutOfProvinceResidence is set to 1 if Province (Current Residence) is not empty and is not Ontario. Otherwise, OutOfProvinceResidence is set to '#'.
StatusInCanada	Legal status of student in Canada. Populated from State/Province - ON, General Info, Citizenship/Immigration, Residence Status.	IF [S_ON_STU_X]Residence_Status = 0 or NULL, THEN # is extracted, Otherwise: If [S_ON_STU_X]Residence_Status = 2 - Native Ancestry, THEN StatusInCanada = 1 - Canadian Citizen If [S_ON_STU_X]Residence_Status = 3 - Permanent Resident, THEN StatusInCanada = 2 - Permanent Resident If [S_ON_STU_X]Residence_Status = 7 - Refugee Status, THEN StatusInCanada = 3 - Refugee Status IF [S_ON_STU_X]Residence_Status = 12 - Study Permit/Visitor Record OR 14 - Exchange Student, THEN StatusInCanada = 4 - Study Visa IF [S_ON_STU_X]Residence_Status = 13 - Diplomat Status/Minister's Permit, OR 15 - Parents' study permit, OR 16 - Parents work permit, THEN StatusInCanada = 5 - Other Visa IF [S_ON_STU_X]Residence_Status = 99 - Not Applicable OR 98 - Other Status, THEN StatusInCanada = 6 - None of the above, Otherwise, [6 - None f the above]
IndigenousType	In accordance with the board's policy for voluntary, confidential Indigenous student self-identification, this Indigenous student has voluntarily self-identified as: a First Nation student who lives in the jurisdiction of and attends a provincially funded elementary or secondary school or who lives in a First Nation community and attends a provincially funded elementary or secondary school under a tuition agreement or a Métis student who attends a provincially funded elementary or secondary school or an Inuit student who attends a provincially funded elementary or secondary school. Populated from: State/Province - ON, General Info, Provincial Reporting, Indigenous Self Identification. Note: Only the value "#" may be submitted by independent schools.	IndigenousType
Learning Format	Indicates if the student is enrolled in the course for mathematics and the math class learning format. Only 3 valid values (1) is reported if Grade 9 Mathematics learning preference/instruction Mode is Full-time in-person learning (2) is reported if Grade 9 Mathematics learning preference/instruction Mode is Full-time remote learning (3) is reported if Grade 9 Mathematics learning preference/instruction Mode is Combination of in-person and remote learning	If Math section [S_ON_SEC_X]Delivery_Type is 18 or 19 then the course is FT remote learning - '2' otherwise use S_CC_X]instructionmode i if not defined use[S_SEC_X]instructionmode, if not defined use [S_CRS_X]instructionmode Otherwise use [S_SCH_X]learningpreference defined for the school where the class is taken Otherwise default to 1 ( Full time in-person learning)
MathTeacherFirstName	The student's mathematics class teacher's first name.	[UserCorefields]PSCore_Legal_First_Name] if blank then [Users]First_Name of Applied or Academic Math Course. The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course.
MathTeacherLastName	The student's mathematics class teacher's last name.	[UserCorefields]PSCore_Legal_First_Name] if blank then [Users]Last_Name of Applied or Academic Math Course. The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course.
ClassCode	The student's mathematics class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number of Applied or Academic Math Course
TermFormat	Indicates whether the student's mathematics class is held during the first semester, second semester, quadmester, octomester, or full year.	Values are set as follows (1) for Semester - Math class scheduled in semester term (2) Full Year - Math class scheduled in Full Year term (3) for Quadmester - Math class scheduled in Quad term (4) For Octomester - Math class scheduled in Octo term Otherwise 5
FrenchImmersionOr Extended	This student is studying mathematics in a French Immersion or extended French class.	Where [Courses]Alt_Course_Number or [Courses]Course_Number = 'FRE-10' Extract 1 if [S_ON_SEC_X]Lang_Pgm_Type = 'I' or 'E' or if 0 or null and [S_ON_CRS_X]Lang_Pgm_Type = 'I' or 'E' Otherwise extract #
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
DateEnteredSchool	Date student entered current school. This date is based on the most recent date of entry.	[Students]SchoolEntryDate, if it exists, otherwise Obtain earliest [Students/Reenrollments]entrydate from latest set of consecutive records for the school otherwise Extract #
DateEnteredBoard	Date student entered current board. This date is based on the most recent date of entry.	[Students]DistrictEntryDate, if it exists, otherwise Obtain minimum entrydate from ps_enrollment otherwise Extract #
FirstLanguage	This student learned English as his or her first language at home Populated from State/Province - ON, General Info, Provincial Reporting, First Language	Extract # when [S_ON_STU_X]First_Language is 0 or null) Extract 1 when [S_ON_STU_X]First_Language = E (English) or B (English and French) otherwise Extract 2
BornOutsideCanada	This student was born outside Canada	Extract # when [S_ON_STU_X]Birth_Country = 0, null, 988 or 999 Extract 2 when [S_ON_STU_X]Birth_Country = 'CAN' Extract 1 when [S_ON_STU_X]Birth_Country not equal to any of the values above.
TimeInCanada	If BornOutsideCanada= 1 (Yes), how long has this student been in Canada? Valid values: # = Missing/Unknown/Not Applicable 1 = Less than one year 2 = One year or more but less than two years 3 = Two years or more but less than three years 4 =Three years or more but less than five years 5 = Five years or more	Compare [S_ON_STU_X]Year_Of_Entry to current date Extract 1 when less than one year. Extract 2 when one year or more but less than two years. Extract 3 when two years or more but less than three years. Extract 4 when three years or more but less than five years. Extract 5 when five years. Extract # when missing, unknown or not applicable.
Refugee	Refugee status. Indicates whether the student's family came to Canada as refugees. Valid values # = No 1 = Yes Populated from State/Province - ON, General Info, Citizenship/Immigration, Did this student's family come to Canada as refugees?	Refugee field is set to 1(Yes) if: "Did this student's family come to Canada as refugees?" is 1 (Yes), OR StatusInCanada value is 3 (Refugee); Otherwise, it is set to #(No)
LanguageLearner	This student is currently an English language learner.	If [Students]Grade_Level < 9, derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrolment that qualifies as ESL/ELD If [Students]grade_level,= 9, Extract 1 if student is currently enrolled in a course with an alternate course number or course number starting with 'ESL' or 'ELD'.
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following IPRC Exceptionalities:	Extract 12 if multiple special education programs exist with different exceptionalities or if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 2 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 3 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 4 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 5 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 6 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 7 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 8 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 9 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 10 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 11 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, Otherwise extract #
AccSign	This student receives the following accommodation: Sign language or an oral interpreter. Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Sign Language Or Oral Interpreter	[S_ON_STU_X]SE_SignLM - Extract 1 if selected, Otherwise extract #
AccAssistiveTech	This student will utilize third-party text-to-speech software (not the text reader in the e-assessment system) to complete the assessment. Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Presentation Devices	Extract 1 if [S_ON_STU_X]SE_PresDevM = 1 - 'Other' Extract 2 if if [S_ON_STU_X]SE_PresDevM = 2 - 'Read&Write for Google' Otherwise extract #
AccScribing	This student will receive the following accommodation: verbatim key entry/scribing of responses. Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Verbatim Scribing Of Responses	[S_ON_STU_X]SE_ScriptM - Extract 1 if selected, Otherwise extract #
SpecPermTemp	This student has no IEP but has received the principal's permission for one or more appropriate accommodations because of a temporary injury or condition. The accommodations have been indicated. Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Temporary Injury Or Condition	[S_ON_STU_X]SP_Temporary - Extract 1 if selected, Otherwise extract #
SpecPermMoved	This student has recently arrived from another school and has no IEP but has received the principal's permission for one or more appropriate accommodations. The accommodations have been indicated. Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, New Student	[S_ON_STU_X]SP_Moved - Extract 1 if selected, Otherwise extract #

Grade 10 OSSLT Output

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB. Extract # if not entered.
StudentOEN	The Ministry-assigned Ontario Education Number. Populated from State/Province - ON, General Info, Provincial Reporting, Ontario Education Number Note: The OEN must be greater than 060-000-000.	[Students]State_StudentNumber. Extract # if not entered.
SASN	The Board- or school-assigned student identification number.	[Students]Student_Number Extract "#" if undefined.
StudentType	This student is home-schooled, enrolled in a Section 23 program, an adult student, a mature student, enrolled in an e-learning course (see first note below), participating in an independent or private study course, or is to be issued an OSSD by the Independent Learning Centre. Please see "Accounting and Reporting EQAO Results for Student with Unique or Special Circumstances" for information about who to include in these categories. Note: Use value "5" only for students enrolled in an e-learning course who do not reside within the jurisdiction of the school board offering the course. Note: Only the values "#," "3" and "4" may be submitted by independent schools.	IF [S_ON_SCH_X]Section23_Flag = 1, Extract 2 IF [S_ON_STU_X]Brd_Res_Status = 09, Extract 5 IF [S_ON_STU_X]Brd_Res_Status = 07 and [S_ON_SEC_X]IsIndependentStudy_Class or [S_ON_CC_X]IsIndependentStudy_Class = 1 for all of the student's current sections at runtime, Extract 6 IF [S_ON_STU_X]Mature_Student is null and student age >= 18 as of Aiugust 31st of the current school year, Extract 3 IF [S_ON_STU_X]Mature_Student = 1, Extract 4 IF [S_ON_STU_X]HomeSchooled = 1, Extract 1 ELSE set to #
EnrolledOntario	The student has been enrolled in publicly-funded education in Ontario for the past two years. That is, the student was enrolled for Grade 8 (at any point in the school year) and Grade 9 (at any point in the school year.) Valid values: # = No 1 = Yes	If the school running the report is a private school, value is # for No. If the student has ReEnrolment records in any school in the board in both of the previous two school years, the value is 1 for Yes. If the student has no ReEnrolment records for the previous two school years, and the entry code on the student's earliest enrolment records for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes. If the student has no ReEnrollment record for one year previously, but has a record for two years previously, and the entry code for the student's earliest enrolment record for the current school year in any school is not 09, 19, 27, 29, 30, 31, or 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes If the student has no ReEnrollment record for two years previously, but has one for last year and, the entry code for the student's earliest enrolment record for the previous school year is not 09,19, 27,29, 30, 31, 32, or a code mapped to one of these codes, the value is # for No; otherwise, the value is 1 for Yes Note: Night and Summer schools enrolments and No Show (NS) and records where the start date = end date are ignored in the above calculation.
OutOfProvinceResidence	Student's primary residence is not Ontario and is classified as a temporary resident.	OutOfProvinceResidence is set to '1' when StatusInCanada is 4 (Study Visa), 5 (Other Visa or 6 (None of the above). When StatusInCanada is set to other value: OutOfProvinceResidence is set to 1 if Country (Current Residence) is not empty and is not Canada. OutOfProvinceResidence is set to 1 if Province (Current Residence) is not empty and is not Ontario. Otherwise, OutOfProvinceResidence is set to '#'.
StatusInCanada	Legal status of student in Canada. Valid values: # - Missing or Unknown: Student's legal status cannot be determined because it is unknown or missing 1 - Canadian Citizen: Student's Canadian citizenship is determined by birth, descent or grant. 2 - Permanent Resident: Permanent resident in accordance with the Immigration and Refugee Protection Act (Canda) - also known as Landed Immigrant. 3 - Refugee Status: Student has refugee status. 4 - Study Permit: Visa student under the Immigration Act, 1976 (Canada). 5 - Authority of another Visa: In Canada on the authority of another visa under the Immigration Act, 1976 (Canada) 6 - None of the above: None of the above and attending an overseas school. Populated from State/Province - ON, General Info, Citizenship/Immigration, Residence Status.	IF [S_ON_STU_X]Residence_Status = 0 or NULL, THEN # is extracted, Otherwise: If [S_ON_STU_X]Residence_Status = 2 - Native Ancestry, THEN StatusInCanada = 1 - Canadian Citizen If [S_ON_STU_X]Residence_Status = 3 - Permanent Resident, THEN StatusInCanada = 2 - Permanent Resident If [S_ON_STU_X]Residence_Status = 7 - Refugee Status, THEN StatusInCanada = 3 - Refugee Status IF [S_ON_STU_X]Residence_Status = 12 - Study Permit/Visitor Record OR 14 - Exchange Student, THEN StatusInCanada = 4 - Study Visa IF [S_ON_STU_X]Residence_Status = 13 - Diplomat Status/Minister's Permit, OR 15 - Parents' study permit, OR 16 - Parents work permit, THEN StatusInCanada = 5 - Other Visa IF [S_ON_STU_X]Residence_Status = 99 - Not Applicable OR 98 - Other Status, THEN StatusInCanada = 6 - None of the above, Otherwise, [6 - None f the above]
IndigenousType	The Indigenous student self-identifies as: a First Nation student; a Métis student; or an Inuit student Populated from: State/Province - ON, General Info, Provincial Reporting, Indigenous Self Identification. Note: Only the value "#" may be submitted by independent schools.	IndigenousType
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
EligibilityStatus	The student's eligibility status according to the year in which he or she entered or (would have entered) Grade 9: first-time eligible or previously eligible.	IF student has taken the OSSLT-E or OSSLT-F test in a prior year (previously eligible), Extract 2 IF Student Type is determined to be '3' (adult) or '4' (mature) OR Current grade level is 11 or 12 Extract 2 ELSE Extract 1 (First-time eligible)
LevelofStudyLanguage	The type of English course the first-time eligible student has been or is currently enrolled in during this school year: academic, applied, locally developed, ESL/ELD or other. Refer to the File Submission Specifications for the Type of Course logic.	If the student is first time eligible (eligibility status = 1) and the student is currently enrolled in a course with course number ([Courses]Course_Number ) starting with 'NBE', 'ENG', 'ESL', 'ELD' or 'OLC': The most recent course in the current year for which the class enrollment start date is on or before the report date is used. Classes which a student starts after the report date are not considered. If the student is not taking English in the current year, the latest historical English Course (from StoredGrades) is used. IF course starts with 'ENG' AND the 5th character 'D', Extract 1 IF course starts with 'ENG' AND the 5th character is 'P', Extract 2 IF the course starts with 'ESL' or 'ELD', Extract 4 IF course starts with 'ENG14', 'ENG23' OR starts with 'ENG' and the 5th character is 'L', Extract 3 IF course starts with 'ENG' and the 5th character is 'U', 'C' or 'M' OR course starts with 'OLC' OR no other conditions are met for eligibility status of 1, Extract 5 ELSE Extract # For NBE course level of study language will be 5
DateOfFTE	Date the previously eligible student was first eligible to participate in the OSSLT. Valid values: # - Not applicable 20 - 2020-2021 or earlier 21 - 2021-2022 22 - 2022-2023 23 - 2023-2024	IF Eligibility Status = 1 (first time eligible), Extract # IF Eligibility Status = 2 (previously eligible) and OSSLT-E or OSSLT-F scores are missing AND IF Student Type = '3' (adult) or '4' (mature), Extract 20 IF [Students]Grade_Level = 12, Extract 21 IF [Students]Grade_Level = 11, Extract 22 IF first test date is between September 1, 2020 and August 31, 2021, or earlier Extract 20 IF first test date is between September 1, 2021 and August 31, 2022, Extract 21 IF first test date is between September 1, 2022 and August 31, 2023, Extract 22 IF first test date is between September 1, 2023 and August 31, 2024 Extract 23 If Not Applicable, Extract #
Grouping	The student's group for the purposes of writing the test.	If grouping by homeroom then [Students]Home_Room, otherwise: [Courses]Course_Number + '-' + [Sections]Section_Number for current year courses. YY_YY- [Courses]Course_Number + '-' + [Sections]Section_Number. If the course-section is from a previous year, course is prefaced with the year it is from (e.g., 20_21-ENG2DR-1). RE- [Courses]Course_Number + '-' + [Sections]Section_Number. If the course-section is from another school (e.g., remote/cross enrolment), course is prefaced with an 'RE' for remote enrolment (e.g. RE-ENG2DR-1). OTH- [Courses]Course_Number. If the course is manually entered into historical grades (student is not enrolled or cross enrolled in the course), course is prefaced with an 'OTH' for those courses Where [Courses]Course_Number starts with 'NBE', 'ENG', 'ESL' or 'ELD'
Homeroom	The student's homeroom or class.	[Students]Home_Room, otherwise extract #
TermFormat	Indicates whether this student's current English course or last English course taken was semester or full-year. The value to report is based on the portion value of the course's TermId (either [CC]TermId or [StoredGrades]TermId): if portion = 1, set SemesterIndicator to 2 (Full Year) if portion = 2, set SemesterIndicator to 1 (Semestered) if portion = 4, set SemesterIndicator to 3 (Quadmestered) if portion = 8, set SemesterIndicator to 4 (Octomestered) ** if portion is any other value, set SemesterIndicator to 5 (Other)	[CC]TermId for current year English course. Extract 1 (semester) or 2 (full year) or [StoredGrades]TermId for prior year English course. Extract 1 (semester) or 2 (full year)
NonParticipationStatus	This eligible student is not participating in this administration, because he or she has been exempted or deferred in accordance with EQAO's policies or has fulfilled or is planning to fulfill the literacy requirement through the OSSLC and in accordance with Ministry of Education policies during the current school year (i.e., summer school last summer, first semester, second semester or full year).	If student has taken OSSLT-E or OSSLT-F test with score 'OLC' or 'CCL' and the test date is in the current school year or last year's summer school (after 7/1), Extract 3 IF [S_ON_STU_X]OSSLT_NonParticpationStatus is: 'Exempted', Extract 1 'Deferred', Extract 2 'OSSLC', Extract 3 ELSE Extract #
Graduating	Indicates the student is graduating this year.	IF [Students]Sched_YearOfGraduation = null or 0 and [Students]ClassOf = current school year, Extract 1 IF [Students]Sched_YearOfGraduation <= current school year, Extract 1 and Students]Sched_YearOfGraduation > 0 ELSE Extract #
Learning Format	Indicate the student learning preferencein-person, remote or combined in-person/remote format? Only 3 valid values (1) Full-time in-person learning (2) Full-time remote learning (3) Combination of in-person and remote learning The report uses the latest learning preference defined before the run date for the student, if not defined uses the school level Learning preference and if not defined default to (1) Full-time in-person learning Student learning format setup may be required. Refer to Learning Preference sections under District Setup and Student Setup for details.	Report check 'students latest effective date before the report run date to get the Learning preference for the student. First it maps to the Alternate Report code in the learning preference code sets table and if not defined it uses the codesets code. If the student level learning preference is not defined ?? table is empty, it uses the [s_sch_x].learningpreference otherwise default to 1 ( Full time in-person learning)
DateEnteredSchool	Date student entered current school. This date is based on the most recent date of entry.	[Students]SchoolEntryDate, if it exists, otherwise Obtain earliest [Students/Reenrollments]entrydate from latest set of consecutive records for the school
DateEnteredBoard	Date student entered current board. This date is based on the most recent date of entry.	[Students]DistrictEntryDate, if it exists, otherwise Obtain minimum entrydate from ps_enrollment
FirstLanguage	This student learned English as his or her first language at home. Populated from: State/Province - ON, General Info, Provincial Reporting, First Language	Extract # when [S_ON_STU_X]First_Language is 0 or null) Extract 1 when [S_ON_STU_X]First_Language = E (English) or B (English and French) otherwise Extract 2
BornOutsideCanada	This student was born outside Canada	Extract # when [S_ON_STU_X]Birth_Country = 0, null, 988 or 999 Extract 2 when [S_ON_STU_X]Birth_Country = 'CAN' Extract 1 when [S_ON_STU_X]Birth_Country not equal to any of the values above.
TimeinCanada	If BornOutsideCanada = 1 (Yes), how long has this student been in Canada?	Compare [S_ON_STU_X]Year_Of_Entry to current date Extract 1 when less than one year. Extract 2 when one year or more but less than two years. Extract 3 when two years or more but less than three years. Extract 4 when three years or more but less than five years. Extract 5 when five years. Extract # when missing, unknown or not applicable.
Refugee	Refugee status. Indicates whether the student's family came to Canada as refugees Valid values # = No 1 = Yes Populated from State/Province - ON, General Info, Citizenship/Immigration, Did this student's family come to Canada as refugees?	Refugee field is set to 1(Yes) if the StatusInCanada field in the EQAO Extract is set to 3 (Refugee) or the "Did this student's family come to Canada as refugees?" flag is True; otherwise, Refugee is set to #(No)
LanguageLearner	This student is currently an English language learner.	Extract 1 if [Courses]Alt_Course_Number or [Courses]Course_Number starts with 'ESL' or 'ELD'. The most recent course in the current year for which the class enrollment start date is on or before the report date is used. Classes which a student starts after the report date are not considered.
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following IPRC Exceptionalities:	Extract 12 if multiple special education programs exist with different exceptionalities or if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 2 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 3 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 4 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 5 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 6 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 7 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 8 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 9 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 10 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 11 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, Otherwise extract #
AccSign	This student will receive the following accommodation: sign language or oral interpreter. Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Sign Language Or Oral Interpreter.	[S_ON_STU_X]SE_SignLR - Extract 1 if selected, Otherwise extract #
AccAssistiveTech	This student will receive the following accommodation (presentation): an assistive technology version (i.e., optimized document for Read&Write Google Chrome extension, Kurzweil, HTML, Word optimized for Read and Write Gold, Word optimized for WordQ, Word and PDF) used with technology such as text-to-speech software, obtained from the secure section of EQAO's Web site.	Extract 1 if [S_ON_STU_X]SE_PresDevR = 1 - 'Other' Extract 2 if if [S_ON_STU_X]SE_PresDevR = 2 - 'Read&Write for Google' Otherwise extract #
AccScribing	This student will receive the following accommodation: verbatim scribing of responses.	[S_ON_STU_X]SE_ScriptR - Extract 1 if selected, Otherwise extract #
AccOther	This student will receive the following accommodation: other accommodations (with the written permission of the Chief Assessment Officer, EQAO).	[S_ON_STU_X]SE_Other - Extract #
SpecPermTemp	This student has no IEP but has received the principal's permission for accommodations owing to temporary circumstances. The accommodations have been indicated.	[S_ON_STU_X]SP_Temporary - Extract 1 if selected, Otherwise extract #
SpecPermMoved	This student has recently arrived from another school and has no IEP but has received the appropriate supervisory officer's permission for accommodations. The accommodations have been indicated.	[S_ON_STU_X]SP_Moved - Extract 1 if selected, Otherwise extract #
SpecPermIEP	This student's accommodations are not described in his or her IEP, but they have been approved by the appropriate supervisory officer. The accommodations have been indicated.	[S_ON_STU_X]SP_NotDescribed - Extract 1 if selected, Otherwise extract #

Trends in International Mathematics and Science Study (TIMSS) Output

The Report Name on the Report Queue page includes " _#####(#)_TI_Y1Y2" where "#####(#)" is the five-digit ministry-assigned board identification number or the six-digit ministry-assigned school identification number. Y1Y2 represents the year the report is being run (example: 1819 represents the 2018-2019 school year).

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered
StudentOEN	The Ministry-assigned Ontario Education Number. TO be uses only by schools that are not required by the ministry to assign OENs. Populated from State/Province - ON, General Info, Provincial Reporting, Ontario Education Number	[Student]State_StudentNumber Extract # if not entered
Grade	The grade in which the student is writing the assessment.	[Students] Grade_Level [ReEnrollments]Grade_Level Allowed values: '4' or '8'
Learning Format	Indicate the student's learning preference in-person, remote, or combined in-person/remote format. Valid values: (1) Full-time in-person learning (2) Full-time remote learning (3) Combination of in-person and remote learning The report uses the latest learning preference defined before the run date for the student, if not defined uses the school level Learning preference and if not defined default to (1) Full-time in-person learning Note: Student learning format setup may be required. Refer to the Learning Preference sections under District Setup and Student Setup for details.	Report check 'students latest effective date before the report run date to get the learning preference for the student. First it maps to the Alternate Report code in the learning preference code sets table and if not defined it uses the codesets code. If the student level learning preference is not defined ?? table is empty, it uses the [s_sch_x].learningpreference otherwise default to 1 ( Full time in-person learning)
ClassTeacherFirstName	The student's homeroom class teacher's first name. Note: Will report, 'No Teacher,' when there is no teacher assigned to ClassCode.	[UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassTeacherLastName	The student's homeroom class teacher's last name. Note: Will report, 'No Teacher,' when there is no teacher assigned to ClassCode.	[UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassCode	The student's homeroom class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number for class where [S_ON_CRS_X]Course_Type = 'H'
ClassMathTeacherFirstName	Student's math class teacher's first name.	[UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name of Math Course (Alt_Course_Number = 'MAT-20') The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course If the value is missing, the report extracts #
ClassMathTeacherLastName	Student's math class teacher's last name.	[UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name of Math Course (Alt_Course_Number = 'MAT-20') The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course If the value is missing, the report extracts #
ClassCode_Math	Student's math class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number of Math Course If the value is missing, the report extracts #
ClassScienceTeacherFirstName	Student's science class teacher's first name.	[UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name of Science Course (Alt_Course_Number = 'SAT-20') The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course If the value is missing, the report extracts #
ClassScienceTeacherLastName	Student's science class teacher's last name.	[UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name of Science Course (Alt_Course_Number = 'SAT-20') The lead teacher is based on the earlier of: the report run (current) date OR [cc]DateLeft for active students in the course If the value is missing, the report extracts #
ClassCode_Science	Student's science class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number of Science Course If the value is missing, the report extracts #
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
LanguageLearner	This student is currently an English language learner.	Derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrolment that qualifies as ESL/ELD
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following IPRC Exceptionalities:	Extract 12 if multiple special education programs exist with different exceptionalities or if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 2 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 3 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 4 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 5 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 6 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 7 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 8 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 9 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 10 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 11 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, Otherwise extract #

Programme for International Student Assessment (PISA) Output

The Report Name on the Report Queue page is enhanced to include " _#####(#)_PI_Y1Y2" where "#####(#)" is the five-digit ministry-assigned board identification number or the six-digit ministry-assigned school identification number. Y1Y2 represents the year the report is being run (example: 1516 represents the 2015-2016 school year).

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered
StudentOEN	The Ministry-assigned Ontario Education Number. Populated from State/Province - ON, General Info, Provincial Reporting, Ontario Education Number Note: For use only by schools not required by the ministry to assign OENs.	[Student]State_StudentNumber Extract # if not entered
Gender	Student's gender	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
Grade	The grade in which the student will be writing the assessment.	[Students] Grade_Level [ReEnrollments]Grade_Level Allowed values: '7' (Grade 7), '8' (Grade 8), '9' (Grade 9), '10' (Grade 10), '11' (Grade 11), '12' (Grade 12)
LearningFormat	The learning format of the student Display ValueDescription1 Full Time in-person learning 2Filltime Remote Learning3Combination of in-person and remote learning	[S_STU_LEARNINGPREF_C]LearningPreference Student Learning Preference (Learning preference page) as of the report date. The report uses the Alternate Report code if defined otherwise the code is used. If Student Learning Preference is not defined, the school Learning Preference defined on the school page is used. Otherwise, extract 1 (Full time in-person learning)
ClassTeacherFirstName	The student's homeroom class teacher's first name. Note: Will report, 'No Teacher,' when there is no teacher assigned to ClassCode.	ELEMENTARY STUDENTS (Grades 7 & 8): [UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name for class where [S_ON_CRS_X]Course_Type = 'H' SECONDARY STUDENTS (Grades 9-12): [UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name for class designated as the homeroom period on the report input page. Set to 'SPARE' if a student has no class in the designated period.
ClassTeacherLastName	The student's homeroom class teacher's last name. Note: Will report, 'No Teacher,' when there is no teacher assigned to ClassCode.	ELEMENTARY STUDENTS (Grades 7 & 8): [UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name for class where [S_ON_CRS_X]Course_Type = 'H' SECONDARY STUDENTS (Grades 9-12): [UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name for class designated as the homeroom period on the report input page. Set to 'SPARE' if a student has no class in the designated period.
ClassCode	The student's homeroom class code ID.	ELEMENTARY STUDENTS (Grades 7 & 8): [Sections]Course_Number + '-' + [Sections]Section_Number for class where [S_ON_CRS_X]Course_Type = 'H' SECONDARY STUDENTS (Grades 9-12): [Sections]Course_Number + '-' + [Sections]Section_Number for class designated as the homeroom period on the report run page. Set to 'SPARE' if a student has no class in the designated period.
LanguageLearner	This student is currently an English language learner.	derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrolment that qualifies as ESL/ELD
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following IPRC Exceptionalities: Autism spectrum disorder Behaviour Blind or low vision Deaf or hard of hearing Developmental disability Giftedness Language impairment Learning disability Mild intellectual disability Multiple exceptionalities Physical disability Speech impairment	Extract 12 if multiple special education programs exist with different exceptionalities or if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 2 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 3 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 4 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 5 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 6 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 7 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 8 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 9 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, else extract 10 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date else extract 11 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, Otherwise extract #

Progress in International Reading Literacy Study (PIRLS) Output

Data Element	Description	[Table]FieldName
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered
StudentOEN	The Ministry-assigned Ontario Education Number. Populated from State/Province - ON, General Info, Provincial Reporting, Ontario Education Number Note: For use only by schools not required by the ministry to assign OENs.	[Student]State_StudentNumber Extract # if not entered
Grade	The grade in which the student will be writing the assessment. Only grade four students are reported. The value reported in this field will be 4.	[Students] Grade_Level [ReEnrollments]Grade_Level Allowed value: '4' For 2021-2022: Allowed value: '5'
LearningFormat	This student's learning format: 1- Full-time in-person learning 2 - Full-time remote learning 3 - Combination of in-person and remote learning	[S_STU_LEARNINGPREF_C]LearningPreference Student Learning Preference (Learning preference page) as of the report date. The report uses the Alternate Report code if defined otherwise the code is used. If Student Learning Preference is not defined, the school Learning Preference defined on the school page is used. Otherwise, extract 1 (Full time in-person learning)
ClassTeacherFirstName	The student's homeroom class teacher's first name.	[UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassTeacherLastName	The student's homeroom class teacher's last name.	[UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassCode	The student's homeroom class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number for class where [S_ON_CRS_X]Course_Type = 'H'
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
LanguageLearner	This student is currently an English language learner.	derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrolment that qualifies as ESL/ELD
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCExceptionalities	This student has special education needs and has been identified as having one of the following exceptionalities: behaviour autism spectrum disorder deaf or hard of hearing language impairment speech impairment learning disability giftedness mild intellectual disability developmental disability physical disability blind or low vision multiple exceptionalities	[S_ON_SEN_X]Exceptionality if [S_ON_SEN_X]Exceptionality = PSCode and [SPEnrollments]Exit_Date is 0 or null or greater than the report date 12 - if multiple special education programs exist with different exceptionalities or if code is 14 1 behaviour 2 autism spectrum disorder 3 deaf or hard of hearing 7 language impairment 6 speech impairment 5 learning disability r8 giftedness 9 mild intellectual disability 10 developmental disability 11 physical disability 12 blind or low vision 14 multiple exceptionalities Otherwise extract #

Pan Canadian Assessment Program (PCAP) Output

The Report Name on the Report Queue page is enhanced to include " _#####(#)_PC_Y1Y2" where "#####(#)" is the five-digit ministry-assigned board identification number or the six-digit ministry-assigned school identification number. Y1Y2 represents the year the report is being run (example: 1516 represents the 2015-2016 school year).

Data Element	Description	[Table]FieldName
ProjectCode	Pan Canadian Assessment Program (PCAP).	Set to "PCAP_19"
SchMident	The Ministry-assigned identifier for the school.	[Schools]Alternate_School_Number or [Schools]School_Number
FirstName	The student's first name.	[Students]First_Name
LastName	The student's last name.	[Students]Last_Name
DateofBirth	The student's date of birth.	[Students]DOB Extract # if not entered
StudentOEN	The Ministry-assigned Ontario Education Number. Populated from State/Province - ON, General Info, Provincial Reporting, Ontario Education Number Note: For use only by schools not required by the ministry to assign OENs.	[Student]State_StudentNumber Extract # if not entered
Grade	The grade in which the student will be writing the assessment.	[Students] Grade_Level [ReEnrollments]Grade_Level Allowed value: '8'
ClassTeacherFirstName	The student's homeroom class teacher's first name. Note: Will report 'No Teacher' when there is no teacher assigned to ClassCode.	[UsersCoreFields] PSCore_Legal_First_Name if blank [Users]First_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassTeacherLastName	The student's homeroom class teacher's last name. Note: Will report 'No Teacher' when there is no teacher assigned to ClassCode.	[UsersCoreFields] PSCore_Legal_Last_Name if blank [Users]Last_Name for class where [S_ON_CRS_X]Course_Type = 'H'
ClassCode	The student's homeroom class code ID.	[Sections]Course_Number + '-' + [Sections]Section_Number for class where [S_ON_CRS_X]Course_Type = 'H'
Gender	The student's gender.	[Students]Gender Extract 1 when M, extract 2 when F, extract # for all other values. If the student's gender is not specified, blank is extracted.
ESLELD	This student is currently an English language learner.	derived from [S_ON_GEN_SPECPROG_X]ESL_Flag Extract 1 if student has Special Program enrollment that qualifies as ESL/ELD
IEP	This student has an Individual Education Plan (IEP).	IF [S_ON_SEN_X]IEP_Flag is selected, Extract 1 ELSE Extract #
IPRCBehaviour	This student has special education needs and has been identified as having the following exceptionality: Behaviour.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 1 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCAutism	This student has special education needs and has been identified as having the following exceptionality: Autism.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 2 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCDeaf	This student has special education needs and has been identified as having the following exceptionality: Deaf or hard of hearing.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 3 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCLanguage	This student has special education needs and has been identified as having the following exceptionality: Language impairment.	If multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 7 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCSpeech	This student has special education needs and has been identified as having the following exceptionality: Speech impairment.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 6 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCLearning	This student has special education needs and has been identified as having the following exceptionality: Learning disability.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 5 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCGifted	This student has special education needs and has been identified as having the following exceptionality: Giftedness.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 8 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCIntellectual	This student has special education needs and has been identified as having the following exceptionality: Mild intellectual disability.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 9 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCDevelopmental	This student has special education needs and has been identified as having the following exceptionality: Developmental disability.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 10 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCPhysical	This student has special education needs and has been identified as having the following exceptionality: Physical disability.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 11 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCBlind	This student has special education needs and has been identified as having the following exceptionality: Blind or low vision.	Extract # if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 12 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #
IPRCMultiple	This student has special education needs and has been identified as having the following exceptionality: Multiple exceptionalities.	Extract 1 if multiple special education programs exist with different exceptionalities Extract 1 if [S_ON_SEN_X]Exceptionality = 14 and [SPEnrollments]Exit_Date is 0 or null or greater than the report date, otherwise extract #