Reference

Number

Field Name

Field Name Definition

Blue text describes location of the data in Maplewood

Required orOptional

Null

Value

Allowed

Values

Value Definition

Variable

Format

1

ProjectCode

Progress in International Reading Literacy Study

Automatically populated in the file

Required

Not allowed

PIRLS_E_xx

where xx denotes the 2 digit year of the submission

Text(7)

2

SchMident

Ministry-assigned identifier for the school; File, School Setup, School Information; School Info tab.

Required

Not
allowed

Text (6)

3

FirstName

Student's first name; Student Records, Biographics tab, Name.

Required

Not
allowed

Text (50)

4

LastName

Student's last name; Student Records, Biographics tab, Name. Note: legal surname is used if it exists.

Required

Not
allowed

Text (50)

DateofBirth

Student's date of birth;  Student Records, Biographics tab, Birth Date

Required

Not
allowed

#

Missing/Unknown

YYYYMMDD

StudentOEN

Ministry-assigned Ontario Education Number; Student Records, Enrolment tab, Edit, OEN Number.

In Maplewood, this means - If school has a funding type of "private" and an OEN has not been assigned to a student, -then a '#' will be sent in the OEN field.

Required

Not
allowed

#

For use only by

schools not

required by the

ministry to assign OENs

Text (9)

7

Grade

Grade; Student Records, Biographics tab, Edit, This Year’s Grade. Only grade 3 and 6 students are included in the file.

Required

Not
allowed

4

Grade 4

Text (1)

8

ClassTeacherFirst
Name

Student's homeroom class teacher's first name; Student Records, Biographics, Edit, This Year’s Homeroom. The student’s homeroom is based on a list of homerooms defined through File, School Setup, Rooms/Homerooms. Teachers’ names are editable through Staff, Staff Records, Personal menu, Name. If teacher's first name doesn't exist, surname will be used as both the first and last name.

Required

Not
allowed

Text (35)

9

ClassTeacherLast
Name

Student's homeroom class teacher's last name; See description in ClassTeacherFirstName.

Required

Not
allowed

Text (35)

10

ClassCode

Student's homeroom class code ID; Student Records, Biographics, Edit, This Year’s Homeroom. The student’s homeroom is based on a list of homerooms defined through File, School Setup, Rooms/Homerooms. Homeroom designation is sent in the file. The homeroom will have -FrIm automatically added if the student is French Immersion.

Required

Not
allowed

Text (20)

11

Gender

Student's gender; Student Records, Biographics tab, Edit, Gender.

Required

Not allowed

1

Male

Text (1)

2

Female

12

ESLELD

This student is currently an English as a second language (ESL) or English literacy development (ELD) learner; Student Records, View Menu, Report Card Details & EQAO Tests, Program tab. If ESL or ESD is checked for the student’s English or Mathematics course, 1 (for Yes) will appear. Otherwise # (no/Not filled in) will appear.

Required

Not
allowed

#
 

No

Text (1)

1

Yes

13

IEPStatus

This student has an Individual Education Plan (IEP), excluding gifted;

If IEP for all Special Ed. Students is checked (on the form where you create this EQAO file), then all active special ed. students, with an exceptionality (other than Gifted) will have 1 (Yes). If the IEP for all Special Ed. Students is not checked, then it will look at Student Records, View Menu, Report Card Details & EQAO Tests, Program tab. If IEP is checked for the student’s English or Mathematics course, 1 (for Yes) will appear. Otherwise # (No/Not filled in) will appear.

If the box "IEP for all special ed. students" was checked, 1 (Yes) appears if a special education student has an active status and an exceptionality other than Gifted.

Required

Not
allowed

#
 

No

Text (1)

1

Yes

14

IPRCCategory
Behaviour

This student has special needs and has been identified as having the following exceptionality: behaviour; Student Records, Special Ed. tab, Edit, exceptionality contains Behaviour (Ministry code 01 in exceptionality table). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

15

IPRCCategory
Autism

This student has special needs and has been identified as having the following exceptionality: autism spectrum disorders; Student Records, Special Ed. tab, Edit; exceptionality contains Autism (Ministry code 02). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

16

IPRCCategoryDeaf

This student has special needs and has been identified as having the following exceptionality: deaf or hard of hearing; Student Records, Special Ed. tab, Edit; exceptionality contains Deaf and hard of hearing or Deaf (Alternate Program) (Ministry code 03 or 21). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

17

IPRCCategory
Language

This student has special needs and has been identified as having the following exceptionality: language impairment; Student Records, Special Ed. tab, Edit; exceptionality contains Language impairment (Ministry code 05). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

18

IPRCCategory
Speech

This student has special needs and has been identified as having the following exceptionality: speech impairment; Student Records, Special Ed. tab, Edit; exceptionality contains Speech impairment (Ministry code 20). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

19

IPRCCategory
Learning
Disabled

This student has special needs and has been identified as having the following exceptionality: learning disability; Student Records, Special Ed. tab, Edit; exceptionality contains Learning disability (Ministry code 04). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

20

IPRCCategory
Giftedness

This student has special needs and has been identified as having the following exceptionality: giftedness; Student Records, Special Ed. tab, Edit; exceptionality contains Giftedness (Ministry code 06). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

21

IPRCCategoryMild
Intellectual

This student has special needs and has been identified as having the following exceptionality: mild intellectual disability; Student Records, Special Ed. tab, Edit; exceptionality contains Mild intellectual disability (Ministry code 07). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

22

IPRCCategory
Developmental

This student has special needs and has been identified as having the following exceptionality: developmental disability; Student Records, Special Ed. tab, Edit; exceptionality contains Developmental disability (Ministry code 24). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

23

IPRCCategory
Physical

This student has special needs and has been identified as having the following exceptionality: physical disability; Student Records, Special Ed. tab, Edit; exceptionality contains Physical disability (Ministry code 09). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

24

IPRCCategoryBlind

This student has special needs and has been identified as having the following exceptionality: blind or low vision; Student Records, Special Ed. tab, Edit; exceptionality contains Blind and low vision (Ministry code 08). *

Required

Not
allowed

#
 

No

Text (1)

1

Yes

25

IPRCCategory
Multiple

This student has special needs and has been identified as having the following exceptionality: multiple exceptionalities;

Student Records, Special Ed. tab, Edit; exceptionality contains Multiple exceptionalities (Ministry code 10 or 23 Deaf/Blind Alternate Program). *If the student has more than one exceptionality, the individual IPRCCategory tags are set to # (no) and IPRCCategoryMultiple is set to 1 (yes). Note: Exceptionalities are ignored if the special ed status is Inactive.

Required

Not
allowed

#
 

No

Text (1)

1

Yes