Second Language Program

Back to Secondary Index Back to Elementary Index Back to Inspected Private Secondary Index

Public Elementary Schools: In the student's record, within the enrolment tab, a student's enrolment in an ESL, ELD, French or native second language program can be specified along with the instructional time (minutes per day for French and hours per year for native languages).

Public Secondary Schools: For public secondary schools, only the second language program type is identified, and it is based on the student's timetable indicating enrolment in a French or Native Language course on the count date. For students enrolled in the Extended French or Immersion programs, schools must specify the second language program within the Enrolment tab (other Fields sub-tab). As well, if a student has one of the ESL or ESD second language programs selected on the Enrolment tab (Other Fields sub-tab), these programs will be reported. Private Secondary Schools: Should be entering data in the same way that Public Secondary Schools are entering this information.


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

DATA	M	No data required, as it is just a tag.
SCHOOL_SUBMISSION	M	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, 2013-2014 for a calendar that starts in September 2013 and ends in June 2014.
SCHOOL_SUBMISSION/ SUBMISSION_PERIOD_ TYPE	M	Submission period type is either OCTSEC1, MARSEC1, or JUNSEC1 for public secondary schools. Submission period type is either OCTELEM1, MARELEM2, JUNELEM3, or JUNELEM2 (June 2011 and on) for public elementary schools.
SCHOOL_SUBMISSION/ SCHOOL	MR	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.
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: CLEAR_SECOND_LANGUAGE_PROGRAM See Purge Flags for further information.
A student is included in this file if they are in the extract or if they are enrolled in a second language program.
Element	Char.	Maplewood Description

SCHOOL_SUBMISSION/SCHOOL/ STUDENT	OR	No data required, as it is just a tag.
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/OEN	M	Student’s OEN number (Enrolment tab of student's record).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_LEGAL_ GIVEN_NAME	M	Student’s Given Name (Name button on the Biographics tab of student's record)
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_LEGAL_ SECOND_NAME	O	Student’s Middle Name (Name button on the Biographics tab of student's record).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_LEGAL_ LAST_NAME	M	Student’s Legal Surname or if empty then Student’s Surname (Name button on the Biographics tab of student's record).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_DOB	O	Student's Date of Birth yyyy/mm/dd (Biographics tab of student's record).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/GENDER_TYPE	M	Gender (M for male and F for female) (Biographics tab of student's record).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/LANGUAGE_TYPE	C	Student's first language (Enrolment tab of student's record). This is the first language spoken by the student. First Languages table is accessed using Students, Custom Fields/Tables, Enrolment Tables, First Languages. The OnSIS code must agree with the OnSIS reference table for LANGUAGE_TYPE. This tag is omitted if the student's MAIN_SCHOOL_FLAG is false (see description below), however OnSIS will populate this field if the student exists in OnSIS or if the student has not been entered in OnSIS (by any school in the province), the value for Language First Spoken will be set to the language of the school. If the language of the school is both “English and French, Language First Spoken of the student will be set to English.
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_MIN_NUMBER	O	Student's Ministry Number (Enrolment tab of student's record). The Ministry Number was assigned to students before the OEN, and is no longer assigned to students.
Additional Mandatory Fields		There will be some additional mandatory fields that must appear when attempting to UPDATE any student data. For example, the ENROLMENT_START_DATE of the student is mandatory and will appear in the batch file. If an error is returned in any of these additional fields, they may be ignored as OnSIS has identified the student and will proceed to process the subsequent data.
The following SECOND_LANGUAGE_PROGRAM information provides information on the student's second language program(s).
Element	Char.	Maplewood Description
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_SCHOOL_ ENROLMENT/SECOND _LANGUAGE_PROGRAM	OR	No data required, as it is just a tag.
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_SCHOOL_ ENROLMENT/SECOND_LANGUAGE _PROGRAM/ACTION	M	If an Extract file is used, ADD will appear if the student is not in the Extract file, UPDATE will appear if the student’s information is different from the Extract file. DELETE will appear if the student is in the Extract file but is no longer enrolled in a second language program.
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_SCHOOL_ ENROLMENT/SECOND_LANGUAGE _PROGRAM/TYPE	M	(Elementary only) – edit the Enrolment tab of the student's record, then select the Other tab to see the student's second language information. There are check boxes for ESL and ELD and a selection box for the student's French and Aboriginal program. The following types are accepted: 001 - FSL Core 002 - FSL Extended 003 - FSL Immersion 004 - ESL (English as a second language) 005 - ELD (English literacy development) 006 - ICFP (Intensive Core French pilot) 010 - FRA - Anglais 011 - FRA-ALF 012 - FRA-APD 013 - FRA-PDF 020 - Cree 021 - Ojibwe 022 - Delaware 023 - Mohawk 024 - Cayuga 025 - Oneida 026 - Oji-Cree 027 - Native 030 - Private French 031 - Private Native This table is accessed using Students, Custom Fields/Tables, Enrolment Tables, Second Language Program. The OnSIS code must agree with the OnSIS reference table for SECOND_LANGUAGE_PROGRAM_TYPE. (Public Secondary only) - Based on the first 3 characters of the common course code in the student's timetable for the current submission period (e.g. sem 1 timetable in October, sem 2 timetable in Mar and June), the type is set as follows: 001 (Core) = course starting with FSF, FSG, FSI 002 (Extended) = course starting with FEF, FEG; OR enrolment tab shows Extended Program and timetable has any other class taught in French (language of instruction in classes file) 003 (Immersion) = course starting with FIF, FIG; OR enrolment tab shows Immersion Program and timetable has any other class taught in French (language of instruction in classes file). Secondary students taking a course beginning with LN will also appear in the second language file with the second language program code (type) will be based on the language of instruction of the class. As well, if a student has one of the ESL or ESD second language program types selected (on the Other Fields sub-tab in the student's Enrolment tab), these second language programs are also included in the file with code 004 for ESL (English as a second language) and 005 for ESD (English Skills Development). (Private Secondary only) - For private schools, if the student is enrolled in any class with a French language of instruction, or if the timetable contains any French common course code for the current submission period (as stated above for Public Secondary schools), the Type will be set to 030 (any French program). If the student is enrolled in any class with a native language of instruction (in the classes file), the type will be set to 031 (any native language).
SCHOOL_SUBMISSION/SCHOOL/ STUDENT/STUDENT_SCHOOL_ ENROLMENT/SECOND_LANGUAGE _PROGRAM/MINUTES_PER_DAY _OF_INSTRUCTION	O	(Elementary only) If the student has a French or Native program, then the tag for MINUTES_PER_DAY_OF_INSTRUCTION will be populated with the number entered in the Minutes Per Day field within the Other tab (accessible when editing the Enrolment tab of the student's record). (Public Secondary only) This tag is excluded from the file. (Private Secondary only) If the second language type was determined from the timetable, then the minutes per day from the classes file is used.