DRAFT Requirements- Phase 2 Enrolment Reporting Initiative (ERI)

DRAFT Requirements- Phase 2 Enrolment Reporting Initiative (ERI)

Below areOnSIS high level draft requirements for each of the three non-credit continuing education registers which are part of phase 2 of the Enrolment Reporting Initiative (ERI) being implemented for October2015-2016 school year.

Enrolment in Literacy and Numeracy Program Requirements

Data to be collected at an elemental level once a year at the end of August through the con-ed and/or summer school submissions in OnSIS.See screen shots on pages 3-5.
ADE to be collected by Course Offering Type for each student. Course Offering Types include:

-Grade 7 or 8 Remedial Literacy and Numeracy

-Non-credit Grade 9 or 10 Remedial Literacy and Numeracy

-Literacy and Numeracy for Parents and Guardians

Either ‘ADE - September to June’ or ‘ADE – Summer’ must be reported
Course start date and course end date required to differentiate between duplicate records should the student take the same program more than once in a given year.
Literacy and Numeracy for Parents and Guardians will be submitted using the childs OEN, First Name, Last Name, DOB and Gender.
Allow boards to submit multiple ADE records [AN1]where Course Offering Type = ‘Literacy and Numeracy for Parents and Guardians’ should more than one parent/guardian be enrolled in the program.

2. Enrolment in the International Languages Elementary (ILE) Program Requirements

Data to be collected at an aggregate level once a year at the end of August through the con-ed and/or summer school submissions in OnSIS.
Collection to include Number of Classes, Number of Instructors, Number of Students [AN2]and Total Number of Hours[AN3] by international language (similar to existing Board Aggregate collection. See screen shots on page 2.

3. Enrolment in Adult Native Language Instruction Requirementsnot currently offered at TDSB

Data to be collected at an elemental level once a year at the end of August through the con-ed and/or summer school submissions in OnSIS. See screen shots on pages 3-5.
Collect ADE by Course Offering Type for each student.

-Adult Native Language

Native Language the student is enrolled in must be reported.
Either ‘ADE - September to June’ or ‘ADE – Summer’ must be reported
Course start date and course end date required to differentiate between duplicate records should the student take the same program more than once in a given year.
Small class size adjustment will not be collected through OnSIS.

OnSIS Form Updates - Continuing Education (Night) School Submission

Add new link ‘International Languages Elementary Program’ to the School Data submission menu for con-ed school submissions. See mock-up below.

A newInternational Languages Elementary Programaggregate form will be created to collect ILE enrolment throughcon-ed school submissions.See mock-up below. Screen will look similar to the existing ILE collection on the October Board Report.

A new ‘ADE – Non Credit’ button will be added to the student School Enrolment form which will take users to the new ‘Average Daily Enrolment (ADE) – Non Credit’ form.

A new Average Daily Enrolment (ADE) – Non Credit form will be added to the con-ed school submission to collect the ADE for students enrolled inLiteracy/Numeracy and Adult Native Language non-credit programs.

Users will be required to submit ‘Course Offering’, Course Start Date, Course End Date, Native Language (if applicable)and either ‘ADE – September to June’ or ‘ADE – Summer’ for each ADE record.

Course Offeringdropdown field will include the following values:

-Grade 7 or 8 Remedial Literacy and Numeracy

-Non-credit Grade 9 or 10 Remedial Literacy and Numeracy

-Literacy and Numeracy for Parents and Guardians (Also refer to Option B below)[AN4]

-Adult Native Language Instruction

Form Updates - Summer School Submission

The existing Average Daily Enrolment (ADE) – Non Credit form will be updated to collect the ADE for students enrolled in non-credit programs.

Users will be required to submit ‘Course Offering’, Course Start Date, Course End Date, Native Language (if applicable)and either ‘ADE – September to June’ or ‘ADE – Summer’ for each ADE record.

Course Offering dropdown field will include the following values:

-Elementary program for developmentally delayed pupils (existing value added in 2014-2015)

-Grade 7 or 8 Remedial Literacy and Numeracy

-Non-credit Grade 9 or 10 Remedial Literacy and Numeracy

-Literacy and Numeracy for Parents and Guardians (Also refer to Option B below)

-Adult Native Language Instruction

2018-10-10OnSIS DRAFT Requirements – ERIPhase 2

ADE -Non Credit Program Business Rules

# / Action (New, Update, Delete, Turn Off) / Rule / Error / Warning
Type / Error / Warning Timing / Business
Rule
Code
(Plus Business
Rule Value) / Error
Message
Code
English and French Message / Additional Notes / Public – Elementary / Public – Secondary / Continuing Education / Summer School
Update / For non-credit related ADE , Course Offering must =
6 -‘Elementary program for developmentally-delayed pupils’
13 - Grade 7 or 8 Remedial Literacy and Numeracy
14 - Non-credit Grade 9 or 10 Remedial Literacy and Numeracy
15 - Literacy and Numeracy for Parents and Guardians
16 - Adult Native Language Instruction. / Critical Error / Upon Entry / ADEN0001
Rule Value: Course Offering types (i.e. “06:13:14:15:16”) / MADEN0001
Invalid Course Offering Type. / Open Date: September 1, 2014
Note: Apply rule for non-credit ADE.
AVERAGE_DAILY_ENROLMENT.STUDENT_SCHOOL_ENROLMENT_ID !=null
Note: Codes 13-16 are new for 2015-2016. / 
New / For non-credit related ADE, Course Offering must =
13 - Grade 7 or 8 Remedial Literacy and Numeracy
14 - Non-credit Grade 9 or 10 Remedial Literacy and Numeracy
15 - Literacy and Numeracy for Parents and Guardians
16 - Adult Native Language Instruction. / Critical Error / Upon Entry / ADEN####
Rule Value: Course Offering types (i.e. “13:14:15:16”) / MADEN####
Invalid Course Offering Type. / Open Date: September 1, 2015
Note: Apply rule for non-credit ADE.
AVERAGE_DAILY_ENROLMENT.STUDENT_SCHOOL_ENROLMENT_ID !=null / 
New / ‘ADE – September to June’ must be >= 0 and less than 0.36 for each record.[AN5] / Critical Error / Upon Entry / ADEN####
Rule Value Total ADE (i.e. “0:0.36”) / MADEN####
‘ADE – September to June’ must be >= 0 and less than 0.36. / Open Date: September 1, 2015 / 
New / ‘ADE – Summer’ must be >= 0 and less than 0.36. / Critical Error / Upon Entry / ADEN####
Rule Value ADE Summer (i.e. “0:0.36”) / MADEN####
‘ADE – Summer’ must be >= 0 and less than 0.36. / Open Date: September 1 2015 /  / 
New / Only one of ‘ADE – September to June’ or ‘ADE – Summer’ can be > 0. [AN6] / Critical Error / Upon Entry / ADEN#### / MADEN####
Only one of ‘ADE – September to June’ and ‘ADE – Summer’ can be > 0. / Open Date: September 1, 2015 / 
New / ‘ADE – Summer’ cannot be > 0 if Course Start Date is prior to July 1st of the current academic year. / Critical Error / School Sign-off / ADEN####
Rule Value: Course Start Date (i.e. “07/01”) / MADEN####
ADE – Summer’ cannot be > 0 if Course Start Date is prior to July 1st of the current academic year / Open Date: September 1, 2015
OEN: CourseOffering Type
AVERAGE_DAILY_ENROLMENT. STUDENT_CLASS_ENROLMENT_ID != NULL /  / 
New / ‘ADE – September to June’ cannot be > 0 if Course Start Date is > or = July 1st of the current academic year. / Critical Error / School Sign-off / ADEN####
Rule Value: Course Start Date (i.e. “07/01”) / MADEN####
ADE – September to June’ cannot be > 0 if Course Start Date is > or = July 1st of the current academic year / Open Date: September 1, 2015
OEN: CourseOffering Type /  / 
New / If Course Start Date is prior to July 1st of the current academic year then ‘ADE – September to June’ should be > 0. / Warning / School Sign-off / ADEN####
Rule Value: Course Start Date (“07/01”) / MADEN####
If Course Start Date is prior to July 1st of the current academic year then ‘ADE – September to June’ should be > 0. / Open Date: September 1, 2015
OEN: CourseOffering Type
Note Rule should only be triggered for courses where ‘ADE – September to June’ = 0.
Do not apply rule if ‘ADE – September to June’ = null as this will be handled by other business rules. /  / 
New / Course Start Date must be > or = to the submission cycle start date and < or = to the submission count date. / Critical Error / Upon Entry / ADEN#### / MADEN####
Course Start Date must be > or = to the submission cycle start date and < or = to the submission count date. / Open date: September 1, 2015 /  / 
New / Course End Date must be > than the Course Start Date and < or = to the submission count date. / Critical Error / Upon Entry / ADEN#### / MADEN####
Course End Date must be > than the Course Start Date and < or = to the submission count date. / Open date: September 1, 2015 /  / 
New / Course Start Date must be > or = to the students enrolment start date and < than the students enrolment end date. / School Sign Off / Upon Entry / ADEN#### / MADEN####
Course Start Date must be > or = to the students enrolment start date and < than the students enrolment end date. / Open date: September 1, 2015 /  / 
New / Course End Date must be > thanthe students enrolment start date and < or = to the students enrolment end date. / School Sign Off / Upon Entry / ADEN#### / MADEN####
Course End Date must be > thanthe students enrolment start date and < or = to the students enrolment end date. / Open date: September 1, 2015 /  / 
New / If a Native Language is selected then Course Offering Type must = ‘16 - Adult Native Language Instruction’. / Critical Error / Upon Entry / ADEN#### / MADEN####
Course Offering Type must = ‘16 - Adult Native Language Instruction’ if a Native Language is selected. / Open date: September 1, 2015 /  / 
New / If Course Offering Type = ‘16 - Adult Native Language Instruction’ then a Native Language must be selected. / Critical Error / Upon Entry / ADEN#### / MADEN####
Native Language must be selected if Course Offering Type must = ‘16 - Adult Native Language Instruction’. / Open date: September 1, 2015 /  / 
New / If selected, Native Language must be one of the following:
09 - Cayuga
10 - Cree
33 - Mohawk
34 - Ojibwe
55 - Delaware
64 - Ojib-cree
65 - Oneida / Critical Error / Upon Entry / ADEN####
Rule Value:
Native Language (i.e. “09:10:33:34:55:64:65”) / MADEN####
Invalid Native Language. / Open date: September 1, 2015 /  / 
Student must have an enrolment record in a public elementary or secondary day school in the same academic year where the student grade is > 6, if Course Offering Type is one of the following:
13 - Grade 7 or 8 Remedial Literacy and Numeracy
14 - Non-credit Grade 9 or 10 Remedial Literacy and Numeracy [AN7] / Critical Error / Board Sign Off / ADEN####
Rule Value:
Course Offering Type, Student Grade(i.e. “13:14,6”) / MADEN#### / Open date: September 1, 2015
Data in Error: OEN: /  / 
New / Student must have an enrolment record in a public elementary or secondary day school in the same academic year, if Course Offering Type is one of the following:
15 - Literacy and Numeracy for Parents and Guardians / Critical Error / Board Sign Off / ADEN####
Rule Value:
Course Offering Type, Count Dates (i.e. “15”) / MADEN#### / Open date: September 1, 2015
Data in Error: OEN: /  / 

International Languages Elementary (ILE)Program Business Rules

# / Rule / Error / Warning
Type(s) / Error / Warning Timing / Business
Rule
Code
and Value / Error
Message
Code / Additional Notes
(i.e. How applied) / Continuing Education
This screen applies only to public Con Ed schools only. / N/A / N/A / N/A / N/A / For information purposes only.
See specifications for details. / 
On each row, # of students should be greater than or equal to 5 times # of classes.[AN8] / Warning / Board
Sign-off / ILE001 / MILE001 / Number of students should be 5 to 45 times number of classes
Data in Error = language description / 
Number of Students in each row must be > than Number of Classes for the same language. / Applied
Error / Upon Entry / ILE002 / MILE002 / There should be at least one student for each class / 
On each row, # of Students must be less than or equal to 45 times # of Classes.[AN9] / Warning / Board
Sign-off / ILE003 / MILE003 / Number of students should be 5 to 45 times number of classes
Data in Error = language description / 
Every field on each row must be blank or all fields on the same row must have values. / Applied
Error / Upon Entry / ILE004 / MILE004 / All columns must be blank or all must have values / 
If the text entered in the Other Language description field exactly matches (case insensitive, TRIM) the description of another entry generate an error. / Applied
Error / Upon Entry (On-line input only) / N/A / E00023
“Entry already on file.” / This Business Rule is applicable to on-line input only
Not applicable to batch file processing.
Refer to section 3.12 “Aggregate Data – Handling Approach for Zero and Null (blank) Count values” in the Board Data Submission Specifications for additional information. / 
If the text entered in the Other Language description field exactly matches (case insensitive, TRIM) the description of the defined language types (English or French description), generate an error. / Applied
Error / Upon Entry / N/A / E00023
“Entry already on file.” / 

Reference Table Updates

# / New Update
Delete / Table / Code / Open Date / Close
Date / English long Description
(max. 240 characters) / French long Description
(max. 240 characters) / Comments / Night School Submission / Summer School Submission
New / Course Offering Type / 13 / 2015/09/01 / Grade 7 or 8 Remedial Literacy and Numeracy / Literacy/Numeracy Register / X / X
New / Course Offering Type / 14 / 2015/09/01 / Non-credit Grade 9 or 10 Remedial Literacy and Numeracy / Literacy/Numeracy Register / X / X
New / Course Offering Type / 15 / 2015/09/01 / Literacy and Numeracy for Parents and Guardians / Literacy/Numeracy Register / X / X
New / Course Offering Type / 16 / 2015/09/01 / Adult Native Language Instruction / Adult Native Language Instruction Register / X / X
Existing / Language Type / 03 / Albanian / Albanais / International / X / X
Existing / Language Type / 04 / Arabic / Arabe / International / X / X
Existing / Language Type / 05 / Armenian / Arménien / International / X / X
Existing / Language Type / 06 / Bengali / Bengali / International / X / X
Existing / Language Type / 07 / Cambodian / Cambodgien / International / X / X
Existing / Language Type / 08 / Cantonese / Cantonais / International / X / X
Existing / Language Type / 09 / Cayuga / Cayuga / Native / X / X
Existing / Language Type / 10 / Cree / Cri / Native / X / X
Existing / Language Type / 11 / Croatian / Croate / International / X / X
Existing / Language Type / 12 / Czech / Tchèque / International / X / X
Existing / Language Type / 13 / Danish / Danois / International / X / X
Existing / Language Type / 14 / Dutch / Hollandais / International / X / X
Existing / Language Type / 15 / Estonian / Estonien / International / X / X
Existing / Language Type / 16 / Finnish / Finlandais / International / X / X
Existing / Language Type / 17 / Gaelic / Gaélique / International / X / X
Existing / Language Type / 18 / German / Allemand / International / X / X
Existing / Language Type / 19 / Greek / Grec / International / X / X
Existing / Language Type / 20 / Gujarati / Gujarati / International / X / X
Existing / Language Type / 21 / Hebrew / Hébreu / International / X / X
Existing / Language Type / 22 / Hindi / Hindi / International / X / X
Existing / Language Type / 23 / Hungarian / Hongrois / International / X / X
Existing / Language Type / 24 / Italian / Italien / International / X / X
Existing / Language Type / 25 / Japanese / Japonais / International / X / X
Existing / Language Type / 26 / Korean / Coréen / International / X / X
Existing / Language Type / 27 / Latvian / Letton / International / X / X
Existing / Language Type / 28 / Lithuanian / Lituanien / International / X / X
Existing / Language Type / 29 / Macedonian / Macédonien / International / X / X
Existing / Language Type / 30 / Malay / Malais / International / X / X
Existing / Language Type / 31 / Maltese / Maltais / International / X / X
Existing / Language Type / 32 / Mandarin / Mandarin / International / X / X
Existing / Language Type / 33 / Mohawk / Mohawk / Native / X / X
Existing / Language Type / 34 / Ojibwe / Otchipwé / Native / X / X
Existing / Language Type / 35 / Persian (Farsi) / Persan (Farsi) / International / X / X
Existing / Language Type / 36 / Polish / Polonais / International / X / X
Existing / Language Type / 37 / Portuguese / Portugais / International / X / X
Existing / Language Type / 38 / Punjabi / Panjabi / International / X / X
Existing / Language Type / 39 / Russian / Russe / International / X / X
Existing / Language Type / 40 / Serbian / Serbe / International / X / X
Existing / Language Type / 41 / Serbo-Croatian / Serbo-croate / International / X / X
Existing / Language Type / 42 / Singhalese / Cinghalais / International / X / X
Existing / Language Type / 43 / Slovak / Slovaque / International / X / X
Existing / Language Type / 44 / Slovenian / Slovène / International / X / X
Existing / Language Type / 45 / Spanish / Espagnol / International / X / X
Existing / Language Type / 46 / Tagalog / Tagalog / International / X / X
Existing / Language Type / 47 / Tamil / Tamoul / International / X / X
Existing / Language Type / 48 / Telugu / Telougou / International / X / X
Existing / Language Type / 49 / Ukrainian / Ukrainien / International / X / X
Existing / Language Type / 50 / Urdu / Ourdou / International / X / X
Existing / Language Type / 51 / Vietnamese / Vietnamien / International / X / X
Existing / Language Type / 54 / Dari / Dari / International / X / X
Existing / Language Type / 55 / Delaware / Delaware / Native / X / X
Existing / Language Type / 56 / Farsi / Farsi / International / X / X
Existing / Language Type / 57 / Hmong / Hmong / International / X / X
Existing / Language Type / 58 / Igbo / Igbo / International / X / X
Existing / Language Type / 59 / Khmer / Khmer / International / X / X
Existing / Language Type / 60 / Kurdish / Kurde / International / X / X
Existing / Language Type / 61 / Lao / Laotien / International / X / X
Existing / Language Type / 62 / Lisane-Dawat / Lisane-dawat / International / X / X
Existing / Language Type / 63 / Marathi / Marathi / International / X / X
Existing / Language Type / 64 / Ojib-cree / Oji-cri / Native / X / X
Existing / Language Type / 65 / Oneida / Oneida / Native / X / X
Existing / Language Type / 66 / Oromo / Oromo / International / X / X
Existing / Language Type / 67 / Pashto / Pachto / International / X / X
Existing / Language Type / 68 / Pilipino / Pilipino / International / X / X
Existing / Language Type / 69 / Romanian / Roumain / International / X / X
Existing / Language Type / 70 / Somali / Somali / International / X / X
Existing / Language Type / 71 / Swedish / Suédois / International / X / X
Existing / Language Type / 72 / Tigrinya / Tigrina / International / X / X
Existing / Language Type / 73 / Turkish / Turc / International / X / X
Existing / Language Type / 74 / American Sign Lang / Langage gestuel américain / International / X / X
Existing / Language Type / 75 / Bosnian / Bosniaque / International / X / X
Existing / Language Type / 76 / Simplified Chinese / Chinois simplifié / International / X / X
Existing / Language Type / 77 / Malayalam / Malayâlam / International / X / X
Existing / Language Type / 78 / Thai / Thaï / International / X / X
Existing / Language Type / 79 / Swahili / Swahili / International / X / X
Existing / Language Type / 80 / Karen / Karen / International / X / X
Existing / Language Type / 81 / Bemba / Bemba / International / X / X
Existing / Language Type / 82 / Bahasa / Bahasa / International / X / X
Existing / Language Type / 83 / Hausa / Haoussa / International / X / X
Existing / Language Type / OTH / Other / Autre langue / International / X / X

2018-10-10OnSIS DRAFT Requirements – ERIPhase 2

BSID’s For Continuing Education School(s)

Below are draft requirements related toBSID’s for cotinuing education schools for both credit and non-credit programs.

OnSIS School Form Updates

Keepexisting ‘School Special Condition Type’ 8 – Summer School
Rename existing ‘School Special Condition Type’ 4 – Night to 4 – Continuing Education School
Close existing ‘School Special Condition Type’ M – Adult Continuing Education Day School
Add anew field ‘Continuing Education Program(s)’to the School Form to identify the programs offered at the Continuing Education school. Multiple programs can be selected. See sample list below:
Adult Credit – Night
Adult Credit – Day
Correspondence/Self Study/E-Learning
International Language Elementary (ILE) Program
Literacy/Numeracy
Adult Native Language Instruction
Update OnSIS to allow boards to request Summer Schools and/or Continuing Education Schools for both elementary and/or secondary panels.