Reference

Number

Field Name

Field Name Definition

Blue text describes location of the data in Maplewood

Null

Value

Allowed

Values

Value Definition

Variable

Format

1

ProjectCode

Programme for International Student Assessment

Automatically populated in the file

Not allowed

PISAxx

where xx denotes the 2 digit year of collection

Text(6)

2

SchMident

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

Not
allowed

Text (6)

3

FirstName

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

Not
allowed

Text (50)

4

LastName

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

Not
allowed

Text (50)

DateofBirth

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

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.

Not
allowed

#

For use only by

schools not

required by the

ministry to assign

OENs.

Text (9)

7

Gender

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

Not
allowed

1

Male

Text (1)

2

Female

8

Grade

Grade; Student Records, Biographics tab, Edit, This Year’s Grade. Only students in grade 7 - 12 are included in the file.

Not
allowed

7

Grade 7

Text (1)

8

Grade 8

9

Grade 9

10

Grade 10

11

Grade 11

12

Grade 12

9

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.

Not
allowed

Text (35)

10

ClassTeacherLast
Name

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

Not
allowed

Text (35)

11

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.

Not
allowed

Text (20)

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.

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.

Not
allowed

#
 

No

Text (1)

1

Yes

14

IPRCExBehaviour

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

15

IPRCExAutism

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

16

IPRCExDeaf

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

17

IPRCExLanguage

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

18

IPRCExSpeech

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

19

IPRCExLearning
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). *

Not
allowed

#
 

No

Text (1)

1

Yes

20

IPRCExGiftedness

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

21

IPRCExMildIntellectual

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

22

IPRCExDevelopmental

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

23

IPRCExPhysical

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

24

IPRCExBlind

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). *

Not
allowed

#
 

No

Text (1)

1

Yes

25

IPRCExMultiple

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.

Not
allowed

#
 

No

Text (1)

1

Yes