Back to Index

Class List - Elementary

The Class List file contains a class code which is a unique name representing the group of students meeting in the same room for instruction.  For elementary schools, the class code does not have to match any Ministry defined class codes.  Maplewood uses the homeroom designation when reporting elementary students' class codes to OnSIS.

If a homeroom has no students, or no elementary students (for combined elementary and secondary schools), it is excluded from the batch file.
 

Char. column values are M-Mandatory, O-Optional, R-Repeatable

 

Element

Char

Description

DATA

M

N/A - No data required, as it is just a tag.

SCHOOL_SUBMISSION

M

N/A - No data required, as it is just a tag.

SCHOOL_SUBMISSION/

ACADEMIC_YEAR

M

yyyy-yyyy - Based on the school calendar (File, School Setup, School Calendar).  For example, 2009-2010 for a calendar that starts in September 2009 and ends in June 2010.

SCHOOL_SUBMISSION/

SUBMISSION_PERIOD_

TYPE

M

Submission period type is either OCTELEM1, MARELEM2, JUNELEM1,  JUNELEM2 (June 2011 and 2012) or JUNELEM3 (June 2013) for public elementary schools.

SCHOOL_SUBMISSION/

SCHOOL

 

MR

N/A - No data required, as it is just a tag.

SCHOOL_SUBMISSION/

SCHOOL/SCHOOL_NUMBER

M

School Number (File, School Setup, School Information).  Only Maplewood may change the school number.

SCHOOL_SUBMISSION/

CLEAR_PENDING_AREA

M

N, for No, will always appear, unless the class list batch file is created with the "Purge and Pre-populate ALL OnSIS data" check box selected.

SCHOOL_SUBMISSION/

Batch Files Purge and

Pre-Population XML Tags

O

If the purge item check box is checked, Y will appear for the purge tag, which will return all the data to the original format:
CLEAR_CLASS

The following CLASS information is repeated for each elementary homeroom in the school.

Element

Char

Maplewood Description

SCHOOL_SUBMISSION/

SCHOOL/

CLASS

OR

No data required, as it is just a tag

SCHOOL_SUBMISSION/

SCHOOL/

CLASS/ACTION

M

ADD will appear for all classes if no Extract file is used.  If an Extract file is used, ADD will appear if the class is not in the Extract file, UPDATE will appear if the class information is different from the Extract file, and DELETE will appear if the class is in the Extract file but is no longer in the school’s data.  Note: Data pre-populated from a previous submission may not be deleted, and in this case, the DELETE action will return an error. 

SCHOOL_SUBMISSION/

SCHOOL/

CLASS/CLASS_CODE

M

The homeroom designation as entered in the Room/Homeroom table (File, School Setup, Rooms/Homerooms).

 

SCHOOL_SUBMISSION/

SCHOOL/

CLASS/CLASS_START_

DATE

 

M

The first day of class is based on the school’s calendar.  The start date is the first day the students may attend the class (e.g. it skips over holidays, Special Days, and Exam Days that may appear at the start of the school year).  The calendar is found under File, School Setup, Calendar, Edit

 

SCHOOL_SUBMISSION/

SCHOOL/

CLASS/CLASS_END_DATE

M

The last day of class is based on the school’s calendar.  The end date is the last day the students may attend the class (e.g. it skips over holidays, Special Days, and Exam Days that may appear at the end of the school year). The calendar is found under File, School Setup, Calendar, Edit

 

SCHOOL_SUBMISSION/

SCHOOL/CLASS/

CLASS_TYPE

C

In the rooms/homeroom table (File, School Setup, Rooms/Homerooms), the Type of Class field is used to determine whether a class is:
 

R - Regular

S - Special Education

ICF - Intensive Core French (applicable to Pilots Boards Only)

OTH - Other

ELP - Early Learning Program/Full Day Kindergarten

SCHOOL_SUBMISSION/

SCHOOL/

CLASS/LANGUAGE_TYPE

C

The language of the class is based on the school's language (File, School Setup, School Information, Configuration Tab).  OnSIS only accepts the values:
E - English
F – French
B - Both 

SCHOOL_SUBMISSION/

SCHOOL/C

LASS/CLASSROOM_TYPE

O

Each homeroom has a room type field in the rooms/homerooms table (File, School Setup, Room/Homerooms).  

The following types are available:
1 - Regular
2 - Portable
3 - Library
4 - Computer Lab
5 - Gymnasium
6 - Other
7 - Science Lab
8 - Design/Technology Shop
9 - Family Studies
10 - Auto Shop