EQAO Extracts

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.

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

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 #

AccBrailleRead

This student will receive the following accommodation for reading: Unified English Braille (UEB)

Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Braille Version, Read

Extract 3 if [S_ON_STU_X]SE_BrailleR = 3(UEB, contracted)

Extract 4 if [S_ON_STU_X]SE_BrailleR = 4 (UEB, uncontracted)

Otherwise extract #

AccBrailleWrite

This student will receive the following accommodation for writing: Unified English Braille (UEB)

Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Braille Version, Write

Extract 3 if [S_ON_STU_X]SE_BrailleW = 3 (UEB, contracted)

Extract 4 if [S_ON_STU_X]SE_BrailleW = 4 (UEB, uncontracted)

Otherwise extract #

AccBrailleMath

This student will receive the following accommodation for mathematics: Nemeth Mathematics & Unified English Braille (UEB)

Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Braille Version, Math

Extract 3 if [S_ON_STU_X]SE_BrailleM = 3 (UEB, contracted)

Extract 4 if [S_ON_STU_X]SE_BrailleM = 4 (UEB, uncontracted)

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 #

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 #

SpecProvBreaks

This English language learner receives the following special provision: Periodic supervised breaks.

Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Periodic Supervised Breaks (ELL)

[S_ON_STU_X]ELL_Breaks - Extract 1 if selected, Otherwise extract #

AccBreaks

This student receives the following accommodation: Extended periodic supervised breaks.

Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Periodic Supervised Breaks

[S_ON_STU_X]SE_Breaks - Extract 1 if selected, 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 #

AccBraille

This student receives the following accommodation: Unified English Braille Mathematics (UEB) formats.

Populated from State/Province - ON, EQAO Gr 9 Math, Education Quality And Accountability Office, Braille Version

Extract 3 if [S_ON_STU_X]SE_BrailleM = 3 (UEB, contracted)

Extract 4 if [S_ON_STU_X]SE_BrailleM = 4 (UEB, uncontracted)

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 #

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.

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 18
IF [Students]Grade_Level = 12, Extract 20
IF [Students]Grade_Level = 11, Extract 21

IF first test date is between September 1, 2018 and August 31, 2018, or earlier Extract 18

IF first test date is between September 1, 2019 and August 31, 2020,
Extract 19

IF first test date is between September 1, 2020 and August 31, 2021,
Extract 20

IF first test date is between September 1, 2021 and August 31, 2022 Extract 21

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.

SpecProvBreaks

This English language learner will receive the following special provision: extended periodic supervised breaks.

[S_ON_STU_X]ELL_Breaks - Extract 1 if selected, Otherwise extract #

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 #

AccBreaks

This student will receive the following accommodation: periodic supervised breaks.

[S_ON_STU_X]SE_Breaks - Extract 1 if selected, 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 #

AccBraille

This student will receive the following accommodation: Unified English Braille (UEB).

Populated from State/Province - ON, EQAO, Education Quality And Accountability Office, Braille Version

Extract 1 if [S_ON_STU_X]SE_BrailleR = 1 (EBAE, contracted)

Extract 2 if [S_ON_STU_X]SE_BrailleR = 2 (EBAE, uncontracted)

Extract 3 if [S_ON_STU_X]SE_BrailleR = 3 (UEB, contracted)

Extract 4 if [S_ON_STU_X]SE_BrailleR = 4 (UEB, uncontracted)

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 #

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 #

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:

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 #

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.

[Students] Grade_Level

[ReEnrollments]Grade_Level

Allowed value: '4'

For 2021-2022: Allowed value: '5'

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.

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 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 #

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 #

G4ClassTeacherFirstName

Previous year latest grade 4 homeroom teacher first name

Applicable for 2021-2022 school year only

[Users]First_Name for the latest grade 4 class where [S_ON_CRS_X]Course_Type = 'H', if not identified the field is set to blank.

G4ClassTeacherLastName

Previous year latest grade 4 homeroom teacher Last name,

Applicable for 2021-2022 school year only

[Users]Last_Namefor the latest grade 4 class where [S_ON_CRS_X]Course_Type = 'H', if not identified the field is set to blank.

G4ClassCode

Previous year latest grade 4 homeroom class code,

Applicable for 2021-2022 school year only

[Sections]Course_Number + '-' + [Sections]Section_Number

for the latest grade 4 class where [S_ON_CRS_X]Course_Type = 'H', if not identified the field is set to blank.

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 #