Reference

Number

Field Name

Field Name Definition

Blue text describes location of the data in Maplewood

Required or Optional

Null

Value

Allowed

Values

Value Definition

Variable

Format

1

ProjectCode

Trends in International Mathematics and Science Study, 2015

Automatically populated in the file

Required

Not allowed

TIMSSxx 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

Grade 8

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

ClassMathTeacherFirst
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)

12

ClassMathTeacherLast
Name

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

Required

Not
allowed

Text (35)

13

ClassCode_Math

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)

14

ClassScienceTeacherFirst
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)

15

ClassScienceTeacherLast
Name

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

Required

Not
allowed

Text (35)

16

ClassCode_Science

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)

17

Gender

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

Required

Not allowed

1

Male

Text (1)

2

Female

18

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

19

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

20

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

21

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

22

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

23

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

24

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

25

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

26

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

27

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

28

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

29

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

30

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

31

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)