Data Validation Error Message and Rule Definitions
`Once a Data Validation process is run, data errors and warnings are displayed on the Start Page, Validation Errors Viewer, Data Views page. For each error code and message, the following table describes:
the error message code and message
why the error message was generated
the action required to correct the error
the severity of the error
the school type and/or submission period to which the rule applies
the source of the validation.
Error Definitions
The table below is sorted by Error Code alphabetically, and then numerically.
Student
Message Code | Message | Error is Generated if the Following is True | Action to Correct Error | Severity | Rules Apply To | Validation Source | Close Date |
|---|---|---|---|---|---|---|---|
MADEN0017b | Students enrolled in a Remedial Literacy and Numeracy program must have an enrolment record in a public elementary or secondary day school in the same academic year where the student grade is greater than 5. |
| To fix the error, either remove the student from the Literacy and Numeracy class or correct the student’s grade. | Critical | Night, Summer | Database | |
MADEN0024 | Students in grade 6 and enrolled in a Grade 7 or 8 Remedial Literacy and Numeracy program can only have 'ADE – Summer' reported. |
| The Start date of the following courses must be >= June 25. Navigate to the Student >All Enrolments, and fix: [list of [courses]course_number] (start_date) comma separated } | Critical | Night | Database | |
MCE0039 | If Final Mark is less than Passing Mark, then Earned Credit must be equal to 0. |
| Navigate to Student > Historical Grades and correct the data | Critical | Public Sec, Private Sec | OnSIS XML | |
MCE0050a | Dual Credit applies only to Grade 10, 11 and 12 students. |
| Fix the student's grade level on the Student > Ontario Provincial Information > Snapshot if it exists for the submission and on the Student\Transfer Information\Current or Previous Enrolment. | Critical | Public Sec | OnSIS XML | |
MCE0068 | Earned Credit Value must be a value between 0 and 5. | The value of STUDENT_CLASS_ENROLMENT/EARNED_CREDIT_VALUE field is lower than 0 or higher than 5. | Navigate to Student > Historical grades, select the course and correct the Earned Credit hours. Error found in: [list of ministrydefined/locallydefined course with the error] | Critical | Public Sec, Private Sec | OnSIS XML | |
MCE0070 | Invalid Course Delivery Type for Public Secondary Schools. | A student is enrolled in a section in a secondary school and the section delivery type is not one of the following:
| Navigate to Start Page > School > Sections, correct the Delivery Code for the following: {list of Course_number - Section} | Critical | Public Sec | Database | |
MCE0071 | Course Delivery Type is invalid for this school | A student is enrolled in a section in this school and the section delivery type is not one of the following:
| Navigate to Start Page > School > Sections, correct the Delivery Code for the following: {list of Course_number - Section}} | Critical | ECPP | Database | |
MCE0072a | Invalid Course Delivery Type for Summer Schools | A student is enrolled in a section in this summer school and the section delivery type is not one of the following:
| Navigate to Start Page > School > Sections, correct the Delivery Type for the following: {Course_number - Section}} | Critical | Summer | Database | |
MCE0073 | Invalid Course Delivery Type for Private Secondary Schools. | A student is enrolled in a section in this school and the section delivery type (STUDENT_CLASS_ENROLMENT.COURSE_DELIVERY_TYPE ) is not one of the following:
| Navigate to Start Page > School > Sections, correct the Delivery Code for the following: {Course_number - Section} | Critical | Private Secondary | OnSIS XML | |
MCE0081 | Invalid Course Delivery Type for Dual Credit Course, valid values are (01) Regular day and (21) DC: On-line | A course is a dual credit course and STUDENT_CLASS_ENROLMENT.COURSE_DELIVERY_TYPE is not one of
| Navigate to School > Sections > fix the Delivery type for the following: {list of class codes} | Critical | Public Secondary | OnSIS XML | |
MCE0082 | Invalid Course Delivery Type for MDC or LDC |
| Navigate to School > Sections > fix the Delivery type for the following: {list of class codes} | Critical | Public Secondary | OnSIS XML | |
MCE0097 | Invalid Course Delivery Type for Dual Credit Course. Valid value is (01) Regular day. | A course is a dual credit course and STUDENT_CLASS_ENROLMENT.COURSE_DELIVERY_TYPE is not (01) - Regular Day. | Navigate to School > Sections > fix the Delivery type for the following: {list of class codes} | Critical | Private Secondary | OnSIS XML | |
MCE0100 | Course delivery type must be “4 – Co-op” for DCO3O | Student is enrolled in DCO3O with an invalid delivery type:
| Navigate to Start Page > School > Sections and correct the Delivery Code for the section in which the student was enrolled. | Critical | Public Sec, | OnSIS XML | |
MDI0004
| Diploma = SSGD, OSSD, OSSD/SHSM or OSSD2 but Grade is less than 12 | Rules applies to e nrolled and non enrolled students If the Diploma segment is generated and the Type is in ( 1, 2, 3 or 4),and STUDENT_SCHOOL_ENROLLMENTS > GRADE_TYPE or STUDENT_NON-ENROLMENT > GRADE_TYPE is < 12 | Navigate to Student and review the student grade level or Review the Diploma date if it is incorrectly set. | Warning | Public & Private Sec | XML Validation | |
MDI0005 | if Diploma = OSSD OSSD/SHSM, OSSD/OYAP-FAST, or OSSD/SHSM/OYAP-FAST, then Literacy Status must = Successful in English, Successful in French, Adjudication or OLC/CCL or NA
|
AND
| Navigate to Student > Test Results and add the student's test scores. | Critical | Public Sec, Private Sec, Night, CCTC | Database | |
MDI0006 | If Diploma = OSSD or OSSD/SHSM, then Community Involvement Hours must be greater than or equal to 40 except students with Mature Flag checked on School Enrolment |
| Do one of the following:
or
| Critical | Public Sec, Private Sec, Night, ECPP | ||
MDI0006a | If Diploma = OSSD or OSSD/SHSM, then Community Involvement Hours must be greater than or equal to 40. | Non-enrolled students:
| Student, Ontario Provincial Information, Community Hours tab and correct errors | Critical | Public Sec, Private Sec | OnSIS XML | |
MDI0006c | If Diploma = OSSD or OSSD/SHSM, then Community Involvement Hours must be greater than or equal to 20 | Non-enrolled students:
| Student, Ontario Provincial Information, Community Hours tab and correct errors | Critical | Public Sec, Private Sec | OnSIS XML | |
MDI0006de
| Community Involvement Hours should be greater than 40 or Community Involvement Hours Waived flag or Mature Flag must be checked on School Enrolment If Diploma granted is OSSD or OSSD/SHSM or OSSD/FAST or OSSD/FAST/SHSM. | If the enrolled or non enrolled student's diploma is OSSD or OSSD/SHSM or OSSD/SHSM/FAST or OSSD/FAST, and neither their Mature Flag or Community Involvement Waived flag selected and Community Involvement hours are less than 40. | Student, Ontario Provincial Information, Community Hours tab and modify the community hours if applicable or mark the student as Mature by selecting the Mature Student Flag on the student General Information page. or select the Community Involvement Hours Waived Flag on the Student General Information page. | Critical | Public & Private Sec, Night, ECPP | Database | |
MDI0011 | Ontario Scholar student but Diploma is not OSSD, OSSD2, SSGD, OSSD/SHSM, OSSD/OYAP-FAST or OSSD/SHSM/OYAP-FAST
| The Ontario Scholarship Approval Date is defined for the student but the student is not working towards one of the listed diplomas. | Navigate to Student > Province - ON > General Info tab and correct either the student's Ontario Scholarship Approval Date or the Diploma Certificate Type. | Critical | Public Sec, Private Sec, CCTC, General Validations | Database | |
MDI0012 | Student is working towards his OSSD2 (2) and the student test results for |
|
| Warning | Public Sec, Private Sec, Night, CCTC | Database | |
MDI0014
| If Grade = 12 and Enrolment End Date is not null (has a value) and Special Education Flag is not True, then student should have received, in the current or any other submission period, an OSSD, OSSD2, SSGD, or OSSD/SHSM diploma. | This rule applies to Enrolled students only If STUDENT_SCHOOL_ENROLLMENTS > GRADE_TYPE is 12 and SPECIAL_EDUCATION_FLAG is not T (True) and STUDENT_SCHOOL_ENROLLMENTS> Enrollment_end_date is not Null and there is no Diploma Segment generated with Action = ADD or UPDATE or there is no record in the PAE file (ON_Diplomas) for the student. | Navigate to the Student, update the Student grade level, Student's Special Education programs or review the student's Diploma Date. | Warning | Public & Private Sec | OnSIS XML | |
MDI0016 | To be awarded an OSSD/SHSM Diploma, the student must have an SHSM Program record with the All Requirements Met Date <= to the Diploma Date of Issuance. |
For general validations, the diploma date must be a date between July 1 - June 30 of the selected academic school year for the student to be validated. | Navigate to Student\Special Programs\ Edit the SHSM program and populate All Requirements Met Date to a Date that is <= to Students's Diploma Date. | Critical | Public Sec, Night, General Validations. | Database | |
MDI0016a
| To be awarded an OSSD/SHSM Diploma, the student should have an SHSM Program record with the All Requirements Met Date <= to the Diploma Date of Issuance. | These rules apply to enrolled and non-enrolled students:
| Navigate to Student\Special Programs\ Edit the SHSM program and populate All Requirements Met Date to a Date that is <= to Students's Diploma Date. | Warning | Public Sec, Night, General Validations. | Database | |
MDI0018 | Ontario Scholar Date must be greater or equal to Diploma/Certificate Date. | The Ontario Scholar Date is prior to the Diploma/Certificate Date. | Navigate to Student > Province - ON > General Info tab > Graduation section and correct either the Ontario Scholarship Approval Date or the Diploma Certificate Date. | Critical | Public Sec, Private Sec, CCTC, General Validations | Database | |
MDI0025
| Diploma = OSSD or OSSD/SHSM and Literacy Status = OLC4O/CCL4O then student should complete OLC4O, OLC3O, CCL4O, or CCL3O course with a final mark >= 50 | The student is working towards OSSD or OSSD/SHSM Diploma and the student Literacy Status is OLC4O/CCL4O and student did not complete any of these courses OLC4O, OLC3O, CCL4O, or CCL3O with a final mark >= 50. | Navigate to the student > Academic Records > Test Results, Or Navigate to Historical Coruse Grades and check the final mark for the OLC/CCL course | Warning | Public & Private Sec, Night, ECPP - Secondary | Database | |
MDI0027 | Diploma/ Certificate type = SSGD or OSSD2; age, as of December 31 of the current academic year, must be greater than or equal to 18. |
| Navigate to Start Page > Student Selection > Select Student > State/Province Page > General Info > update student Diploma Or Navigate to student demographic to fix student birth date | Critical | Public & Private Sec, Night, CCTC-Secondary | Database | |
MDI0028 | If diploma data has been reported with diploma type = OSSD, OSSD/SHSM, OSSD/OYAP-FAST, OSSD/SHSM/OYAP-FAST OSSD2 or SSGD, then student transfer & retirement code, if reported, must be “Received OSSD or equivalent” Or ”Deceased”. |
| Navigate to Student, Transfer Info, Current Enrolment, Fix the student Exit code OR Navigate to Compliance, General Information page and update the Diploma Certificate Type | Critical | Public & Private Secondary | OnSIS XML | |
MDI0028A
| Student with transfer/ retirement mobility type of 61 should have OSSD or equivalent | STUDENT_SCHOOL_ENROLLMENTS > STUDENT_MOBILITY_TYPE_EXIT = 61 then either
| Navigate Student, School Enrolment, Enrolment History, Current Enrolment, Fix the student Exit code | Warning | Public & Private Sec | OnSIS XML | |
MDI0029 | If diploma data has been reported with certificate type = OSSC, then student transfer & retirement code, if reported, must be “Received OSSC”. |
| Navigate to Student>Transfer Info>Current Enrolment> Fix the student Exit code | Critical | Public & Private Secondary | OnSIS XML | |
MDI0030 | If diploma data has been reported with certificate type = COA, then student transfer & retirement code, if reported, must be “Received C of A”. |
| Navigate to Student>Transfer Info>Current Enrolment> Fix the student Exit code | Critical | Public & Private Secondary | OnSIS XML | |
MDI0030A
| Student with transfer/ retirement mobility type of 63 should have CofA | Applies only to enrolled students for all submissions If STUDENT_SCHOOL_ENROLLMENTS > STUDENT_MOBILITY_TYPE_EXIT = 63 and either
| Navigate to Student, Transfer Info, Current Enrolment. Fix the student Exit code or Navigate to Compliance, Genral Information and fix the Diploma Certificate Type assigned to the student | Warning | Public & Private Sec | OnSIS XML | |
MDI0037
| Student must have an OYAP-FAST Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the OSSD/OYAP-FAST Diploma Date of Issuance | If OSSD/OYAP-FAST is awarded, then the student should have an OYAP-FAST Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the Diploma Date of Issuance. Applies only to enrolled students: If the <Diploma>Certificate_Issued is not null and the diploma type is 5 or 6 then either
| Navigate to Student, Compliance, General Information to correct the Diploma Date. or if applicable, go to the Student OYAP-FAST Program and update the All Requirements Met date | Warning | Public Secondary and Night | OnSIS XML | |
MDI0038
| Student should have a SHSM Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the OSSD/SHSM/ OYAP-FAST Diploma Date of Issuance. AND an OYAP-FAST Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the OSSD/SHSM/FAST Diploma Date of Issuance. | If diploma awarded is OSSD/SHSM/OYAP-FAST, then the student should have a SHSM Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the Diploma Date of Issuance and an OYAP-FAST Program record, in the current or any previous submission period, with the All Requirements Met Date less than or equal to the Diploma Date of Issuance. Applies to:
| Navigate to student and either fix the student assigned diploma or fix the SHSM/OYAP-FAST All Requirement Met Dates | Warning | Public & Private Sec | OnSIS XML | |
MDI0039
| Diploma type of OSSD/OYAP-FAST or OSSD/SHSM/OYAP-FAST is not applicable to Private Schools | Diploma type of OSSD/OYAP-FAST or OSSD/SHSM/OYAP-FAST is not applicable to Private Schools:
| Navigate to the student and fix the student assigned diploma. | Critical | Private Secondary | Database | |
MDI0040
| Diploma type of OSSD/OYAP-FAST or OSSD/SHSM/OYAP-FAST is not applicable to ECPP. | Data validation rules:
| Navigate to the student and fix the student assigned diploma | Critical | ECPP | Database | |
MED0001 | The student must have only one main Exceptionality. | Student has more than one exceptionality with:
. | Navigate to Student > Special Programs > Special Education programs , edit active programs as of submission end date and make sure that the student has only one main exceptionality. | Critical | Public Elem, Public Sec | OnSIS XML | |
MED0002
| IPRC Flag and IPRC / Review Date are required. | Data validation rules: If IPRC flag is Yes, then IPRC / Review Date must be entered or If IPRC / Review Date is entered, then IPRC flag must be Yes. XML Validation: If IPRC_STUDENT_FLAG = T and IPRC_REVIEW_DATE Is not provided or IPRC_REVIEW_DATE has a date and IPRC_STUDENT_FLAG =F | Navigate to Student, Special Programs, Special Education programs, edit programs that are still active as of the submission count date, and fix the issue | Applied | Public Elem, Public Sec | ONSIS XML, Database | |
MED0003
| Non Identified Student flag and Main Exceptionality Flag both cannot be set to ON within and across special education records for the student. | This rule applies to active students only. Both the Non Identified Student Flag and the Main Exceptionality Flag are selected on one or more special education programs for the student. | Navigate to student > Special Programs > Special Education Programs and correct the programs that are still active as of the submission end date. | Warning | Public Elem, Public Sec | Database | |
MED0008
| Special Education data existed from the previous submission but does not exist in this submission. | Applies only to Active students where STUDENT_SCHOOL_ENROLMENT> ENROLMENT_END_DATE is NULL Applies to March and June submissions only Do not apply if the student has only records in the PAE file where ON_IDENTIFIED_STUDENT_FLAG = T warning displayed , if all records have a DELETE action Segment in the XML. i.e, all records in the PAE will be deleted in OnSIS when the XML is uploaded. | Navigate to the student> Courses and Programs> School Programs, and review the student’s Special Education data | Warning | Public Elem, Public Sec | OnSIS XML | |
MED0008A
| Student was reported as Non-Identified in the previous submission but a special Education record does not exist in the current submission. | Student is Active where STUDENT_SCHOOL_ENROLMENT> ENROLMENT_END_DATE is NULL If value in the previous submission period = “Non-Identified” → if the student has only records in the PAE file where NON_IDENTIFIED_STUDENT_FLAG = T, and there is no Special Eucation Segment records in the XML with Action ADD in this submssion where EXCEPTIONALITY_TYPE is Not Null | Navigate to the student > Courses and Programs > School Programs > Review the student Special Education data | Waring | Public Elem, Public Sec | OnSIS XML | |
MED0011
| The Special Education Placement / Instructional Setting data from the previous submission does not match the Special Education Placement / Instructional Setting data in this submission | For Active students where STUDENT_SCHOOL_ENROLMENT> ENROLMENT_END_DATE is NULL and the segment is generated with action UPDATE and for the same Exceptionality_type the SPECIAL_EDU_PLMNT_TYPE in PS does not match the PAE value. | Navigate to the student > Courses and Programs > School Programs > Review the student's Special Education data | Waring | Public Elem, Public Sec | OnSIS XML | |
MED0020
| Special Education Placement/ Instructional Setting type = Fully Self- contained, should not have any Class Type other than Special Education | For Active students where STUDENT_SCHOOL_ENROLMENT> ENROLMENT_END_DATE is NULL If the student has an exceptionality, in the PAE or in the XML with a SPECIAL_EDU_PLMNT_TYPE = F and has a class in the STUDET_CLASS_ENROLEMT where CLASS_TYPE != 'S' Note: classes with Action UPDATE and CLASS_END_DATE = submission start date are ignored. ( these are classes that are deleted (exist in PAE but not in PowerSchool) | Navigate to Student > Review student course registration | Warning | Public Elem, Public Sec | OnSIs XML | |
MED0024A
| PRC / Review Date is more than 42 days prior to the count date but IEP flag is set to no. Regulation 181/98 requires all students must have an IEP within 30 school days of the implementation of an IPRC placement decision. | Applies to October and March submissions only If IPRC_REVIEW_DATE is > 42 prior to the count date, and INDIVIDUAL_EDUCATION_PLAN_FLAG is F Note: only segments with Action ADD and UPDATE are examined. | Navigate to Student > Courses and Programs > School Programs > Review Special Education program | Waning | Public Elem, Public Sec | OnSIS XML | |
MED0024d | IEP flag must be checked if the student has an IPRC / Review Date prior to the October count date. Regulation 181/98 requires all students must have an IEP within 30 school days of the implementation of an IPRC placement decision. | This rule applies to active students only.
| Navigate to Student > Special Programs > Special Education programs and edit the programs that are still active as of the submission end date. | Critical | Public Elem, Public Secondary | OnSIS XML | |
MED0026
| Each student who receives a special education program or service is expected to have an IEP: | Warning displays for non-identified students if:
| Navigate to Student > Courses and Programs > School Programs > Review Special Education program | Warning | Public Elem, Public Sec | OnSIS XML | |
MED0028
| Students with multiple Special Education records must have the same IPRC Flag, IPRC / Review Date, Individual Education Plan Flag, Special Education Placement/ Instructional Setting, and Non-Identified Student Flag field values across all records. | If the student has multiple Special Education records, However, the following field values are not the same across all records:
| Navigate to Student > Courses and Programs > School Programs > Review Special Education programs | Warning | Public Elem, Public Secondary | OnSIS XML | |
MED0029
| Students with Special Education records from multiple schools within one board should have the same IPRC Flag, IPRC / Review Date, Individual Education Plan Flag, Special Education Placement/ Instructional Setting, and Non-Identified Student Flag field values across all schools. | The active student has multiple Special Education records, However, the following field values are not the same across all school records:
| Navigate to Student > Courses and Programs > School Programs > Review Special Education programs | Warning | Public Elem, Public Sec | Database | |
MOC0038 | Credit type must be “15 – Co-op” for DCO3O | Student is enrolled in DCO3O with an invalid OnSIS credit type:
| Navigate to Student, Historical Grades, DCO3O and correct the OnSIS Credit type. | Critical | Public Sec | OnSIS XML | |
MOF0002
| “All Requirements Met Date” is entered, student must have at least 8 co-operative credits in skilled trades and at least 1 RTA reported. | If “All Requirements Met Date” is entered, then the student must have at least 8 co-operative credits in skilled trades and 1 RTA reported. Applies to enrolled and non-enrolled students:
| Navigate to the Student OYAP-FAST Program and either remove the "All Requirements Met" date. add the student's RTA or verify their co-op credits on the Historical Grades page | Critical | Public Secondary, Night | OnSIS XML | |
MOF0005
| Number of cooperative education credits in skilled trades must be between 0 and 20 since the OYAP-FAST Participant is true under School Enrolment/School Enrolment (Non-Enrolled Student) | If OYAP-FAST Participant is true under School Enrolment/School Enrolment (Non-Enrolled Student), then Number of cooperative education credits in skilled trades must be between 0 and 20. Applies to enrolled and non-enrolled students:
| Navigate to the student and create an OYAP-FAST special program for the student. or Navigate to Student, Compliance, General Information page and unselect the OYAP-FAST Participant flag. | Critical | Public Secondary, Night | ||
MPL0012c | Maximum number of credits for PLAR Type of Equivalency and/or Individual assessment for Grade 9 or 10 credits and/or “Individual equivalency Assessment for Grade 11 or 12” has been exceeded. | Mature student flag is selected and the total PLAR courses credits earned with <PLAR_TYPE> 5 or 7 is more than 30 Total PLAR credits calculation:
| Maximum number of credits for PLAR Type of Equivalency and/or Individual assessment for Grade 9 or 10 credits and/or “Individual equivalency Assessment for Grade 11 or 12” has been exceeded. | Critical | Public & Private Secondary Night and ECPP general validation | Database | |
MPL0021 | Mature student cannot have PLAR entries with PLAR type “Challenge for Grade 10”. |
| Do one of the following: Navigate to Student > State/Province - ON > General Info tab and clear the Mature Student flag. OR Navigate to Student > State/Province - ON > Academics > Historical Grades and correct the PLAR type. | Critical | Public Sec, Private Sec | OnSIS XML | |
MPL0028 | PLAR Status = Unsuccessful, Total Credit Value must be 0. | For all PLAR entries
| Navigate to Student > Academics > Historical Grades to fix the errors. | Critical | Public Sec, Private Sec | OnSIS XML | |
MPL0030 | Course code must be PLE99 |
| Navigate to Student > Academics > Historical Grades and correct the course code. | Critical | Public Sec, Private Sec | OnSIS XML | |
MPL0032 | Maximum number of credits for PLAR Type of Individual assessment for 'Individual equivalency Assessment for Grade 11 or 12' has been exceeded | If the Mature Student flag is selected and the total PLAR course credits earned with <PLAR_TYPE> 7 or 8 are more than 14 after the student turns 18. Total PLAR credits calculation:
| Navigate to Student > Academics > Historical Grades to fix the errors. | Critical | Public & Private Sec, Night, CTCC, general validation | Database | |
MRC0051 | Grade in September, if provided must be between current grade and current grade + 2. | This rule is only applicable to the June submission.
| Navigate to Student > Scheduling Setup and modify the value in the Grade in September field. Note: If the OnSIS file is generated after running the EOY process, the Grade in September values are set to the student's current grade level. | Critical | Public Elem | OnSIS XML | |
MSA0003 | SAL student but Grade is not 7 or 8. |
Notes:
| Student's grade level as of the count date or effective date needs to be corrected or the student should not be enrolled in a SAL Special program. Navigate to either Student > Transfer Information > Current or Previous Enrolment to correct the student's grade level or to Student > Special Programs to delete the student's SALProgram that is current when the student is not in grade 7 or 8. | Critical | Public Elem, General Validations | Database | |
MSA0005a | SAL student but age is less than 14 or greater than or equal to 19 on the Count Date. |
Notes:
| Student's Date of Birth should be corrected or the student should not be enrolled in a SAL Special program. Navigate to Student > Demographics page to correct the student DOB or to Student > Special Programs to delete the student's SAL Program that is current as of the count date | Critical | Public Elem, Public Sec | Database | |
MSA0006 | Student cannot be identified as SAL student. |
Notes:
| Navigate to Student > Demographics page to correct the student DOB or to Student > Special Programs to delete the student's SAL Program that is current as of the count date or effective date. | Critical | Public Elem, Public Sec, General Validations | Database | |
MSA0012 | School Enrolment End Date is provided then SAL Program End Date must be less than or equal to School Enrolment End Date. |
| Navigate to Student > Special Programs > Edit SAL Program and update the SAL program end date. | Critical | Public Sec | OnSIS XML | |
MSA0014 | SAL Program End Date is entered then SAL Exit (Next steps after SAL Plan ends) is required. |
| Navigate to Student > Special Programs > Edit SAL Program and enter the SAL Exit Reason. | Critical | Public Sec | OnSIS XML | |
MSE0015 | The "Special Education" flag value in the previous submission does not match the current value. | For Active students where ENROLMENT_END_DATE is NULL If the value of the SPECIAL_EDUCATION_FLAG in the STUDENT_SCHOOL_ENROLMENT Segment differs from the corresponding value in the special education PAE file | Student > Courses and Programs > School Programs > Review Student Special Education Programs | Warning | Public and Private Elem, Public, and Private Sec | OnSIS XML | |
MSA0017 | SAL student must report at least one SAL Plan Component |
Notes:
| Navigate to Student > Special Programs > Edit SAL Program > Edit Ontario Provincial Information then add SAL Plan Component. | Critical | Public Elem Public Sec, General Validations | Database | |
MSA0019 | Record for previous year exists, SAL Status = First school year in SAL cannot be entered. | The student is enrolled in a Special Program at his or her main school (primary enrolment record exists for the student) WHERE
Notes:
| The student has a SAL program with Status = First Year in SAL in the current year and there are Sal Program entries for the student in previous years (where the programs entry date is less than the school start date). Navigate to Student > Special Programs > Edit SAL Program to correct the data. | Critical | Public Elem, Public Sec, General Validations | Database | |
MSA0023 | SAL Program type is 002 - >= 70 Minutes of Day School Instruction, then SAL Plan Component must include 001 – Day School Course/ Program. |
Notes:
| Navigate to Student > Special Programs > Edit SAL Program > Edit Ontario Provincial Information. Add SAL Plan Component "001 – Day School Course/Program."> | Critical | Public Elem, Public Sec, General Validations | Database | |
MSE0020 | A 'Class Code' must be entered for Elementary students. |
Notes:
| Make sure the student is enrolled in a Homeroom class as of the count date. Also, confirm that Create Class Codes has been run to generate OnSIS class codes for each class. | Critical | Public Elem, Private Elem, General Validations | Database | |
MSE0029 | 'Literacy Status' cannot be reported for students in Grade 9. |
| Modify the Student's grade level or Navigate to the Student > Academics > Test Results to correct the data. | Warning | General Validations | Database | |
MSE0033 | 'Previous Country' must be selected and 'Previous Province' must be blank for the selected 'Entry code'. |
| Navigate to Student > Transfer Information > Current or Previous Enrolment to correct the data. | Applied | Public Elem, Public Sec, Private Sec | Database | |
MSE0034 | 'Previous Province' must be selected and 'Previous Country' must be blank for the selected 'Entry Code'. |
| Navigate to Student > Transfer Information > Current or Previous Enrolment to correct the data. | Applied | Public Elem, Public Sec, Private Sec | Database | |
MSE0035 | If the 'Country (Birth)' is entered, then a 'Date of Entry into Canada (YYYY/MM)' must be entered if appropriate documentation is available to confirm this date for ministry funding and audit purposes. |
| Navigate to State/Province - ON > General Info tab to correct the data. | Critical | Public Elem, Public Sec, Night, ECPP | Database | |
MSE0035a | 'Country (Birth)' must be entered if 'Date of Entry into Canada (YYYY/MM)' is entered. |
| Navigate to State/Province - ON > General Info tab to correct the data. | Critical | Public Elem, Public Sec, Night, ECPP | Database | |
MSE0036 | 'Year of Entry (YYYY/MM)' must be > or = to 'Student Date of Birth' and < or = to the submission's Count Date. | "Date of Entry into Canada" is less than the student's Date of Birth or greater than the submission count date. | Navigate to either State/Province - ON > General Info tab or the student's General Demographics page to correct the data. | Applied | Public Elem, Private Elem, Public Sec, Private Sec, Night, ECPP | Database | |
MSE0045 | Grade Designation is only applicable for Grade 10-12. | Note: This rule is applied only to student's with a primary enrolment at the school running the report. The student is not in Grade 10, 11, or 12 but has a grade designation. | Navigate to Student >Transfer Information > Current Enrolment to correct the data. | Critical | Public Sec, Private Sec, General Validation | Database | |
MSE0052 | 'Previous Country' and/or 'Previous Province' should be blank for the 'Admission From' selected. |
| Navigate to Student >Transfer Information > Current or Previous Enrolment to correct the data. | Applied | OnSIS Elem, Public Sec, Private Sec Public Elem, Public Sec, Private Sec | Database | |
MSE0053 | Both 'Country (Destination)' and 'Province (Destination)' should be blank for the selected 'Transfer/Retirement Code'. |
| Navigate to Student >Transfer Information > Current or Previous Enrolment to correct the data. | Applied | OnSIS Elem, Public Sec, Private Sec | Database | |
MSE0059 | 'Grade Designation' must be entered for students in Grade 10-12. Please note that if this value is not defined OnSIS defaults this field to 1 (Years of Attendance) | This rule is applied only to student's with a primary enrolment at the school running the report.
| Navigate to Student >Transfer Information > Current or Previous Enrolment to set a value for Grade Designation Type. | Warning | Public Sec Private Sec, General Validations | Database | |
MSE0060 | 'Year of Entry (YY/MM)' cannot be after the 'Enrolment Start Date' | The student's year/month of entry into Canada is after the student's earliest enrollment start date in the school:
Note: No show student records are excluded from the validation. | Do one of the following:
| Critical | Public Elem, Private Elem, Public Sec, Private Sec, Night, ECPP, General Validations | Database | |
MSE0062 | Either the 'Country (Birth)' or the 'Province (Birth)' must be entered. | Both Country of Birth and Province of Birth fields are empty. | Navigate to State/Province - ON > General Info tab to correct the data. | Critical | Public Elem, Public Sec, ECPP | Database | |
MSE0063 | You must enter either the "Country (Permanent Residence)" or the "Province (Permanent Residence)" | Both Country (Permanent Residence) and Province (Permanent Residence) are empty. | Navigate to Student > Province-ON > General Info tab > Citizenship/Immigration and select a value for either Country (Permanent Residence) or Province (Permanent Residence) or both. | Critical | Private Elem, Private Sec, General Validations | Database | Sept 30, 2019 |
MSE0064 | If "Country (Permanent Residence)" is not blank, then "Year of Entry (YYYY/MM)" should be entered. | Country (Permanent Residence) field has a value but the Year of Entry field is empty. | Navigate to Student\Province-ON > General Info tab > Citizenship/Immigration and enter the student's Date Of Entry Into Canada | Warning | Private Elem, Private Sec, General Validations | Database | Sept 30, 2019 |
MSE0071 | Student “Board Residence Status” is not populated. Note: OnSIS reports set the Board Residence Status to 01 if it is not populated. | Board of Residence Status field is empty on the current school enrolment record on the effective date. This rule applies only to elementary and secondary students. | Navigate to Student > Province - ON > General Info tab and populate the Board Residence Status field.or Navigate to Student > Transfer Info > Current or Previous Enrollments and populate the Board Residence Status field. | Warning | General Validations | Database | |
MSE0077 | Board Residence Status = Online Learning is not a valid value for this student. Elementary students cannot have a 'Board Residence Status' = 'Online Learning'. |
Note: Applies only to elementary students; therefore, only elementary student are validated, even if non-elementary schools are chosen for General Validations. | Navigate to Student > Transfer Information > Current or Previous Enrolment to correct the Board Residence Status Value. | Critical | Public Elem, General Validations | Database | |
MSE0089 | Student must have a valid Ontario postal code. | The student's home address postal code is invalid or missing. | Navigate to Student > Demographics page and correct or add the student's postal code. | Critical | Public Elem, Private Elem, Public Sec, Private Sec, Night, ECPP | Database | |
MSE0099 | Elementary students must be between the ages of 2 and 21 as of December 31st of the academic year. | The elementary student's age is less than 2 years or greater than 21 as of the December 31st of the academic year. | Navigate to Student > Demographics page and correct the student's date of birth | Critical | Public Elem, Private Elem, General Validations | Database | |
MSE0100 | Secondary students must be between the ages of 9 and 96 as of December 31st of the academic year. | The secondary student is not between the ages of 9 and 96 as of December 31st of the academic year. | Navigate to Student > Demographics page and correct the student's date of birth. | Critical | Public Sec, Private Sec, General Validation | Database | |
MSE0104 | Invalid Transfer/Retirement code for Public Elementary School. | The student's Student Mobility Type Exit code is not valid. Valid Transfer/Retirement codes for Public Elementary Schools are:
| Navigate to Student > Transfer Information > Edit Current Enrollment and update the student's Exit Code. | Critical | Public Elem | OnSIS XML | |
MSE0123 | Residence Status Type 'Native Ancestry' is only applicable for Private schools. |
| Navigate to State/Province - ON > General Info tab to correct errors | Applied | Public Elem, Public Sec, Night, ECPP | Database | |
MSE0126 | If Student Age is 2 or 3 years as of December 31 of the academic year, then Exceptionality type must be reported. |
| Do one of the following:
| Critical | Public Elem | OnSIS XML | |
MSE0127 | If student age is 2 or 3 years as of December 31 of the academic year, then Grade must be JK. |
| Do one of the following:
| Critical | Public Elem, General Validations | Database | |
MSE0133A | If student age is 2 or 3 years as of December 31 of the academic year, then Attendance Type can only be 'Part time'. |
| Do one of the following:
| Critical | Public Elem | OnSIS XML | |
MSE0134 | If student age is 2 or 3 years as of December 31 of the academic year, then FTE must be >= 0.04 and <= 0.50 |
| Review OnSIS Elementary guide and Enrolments Fields report for FTE calculation. | Critical | Public Elem | OnSIS XML | |
MSE0143 | If OYAP flag is checked then student’s age, as of December 31 of the current academic year, must be greater than or equal to 16. |
| Do one of the following:
| Critical | Public Sec, Night, ECPP, General Validations | Database | |
MSE0144 | If OYAP flag is checked then student's grade must be Grade 11 or Grade 12. | The student's grade level is not 11 or 12 and the OYAP flag is selected on the student's Province - ON > General Info tab | Do one of the following:
| Critical | Public Sec, General Validations | Database | |
MSE0145 | OYAP flag is checked then student must have at least one class enrolment or Other Credits record in the current submission. |
| Uncheck the OYAP flag on Student > Ontario Provincial Information > Snapshot if a record exists for the submission count date and on Student > State/Province -ON > General Info tab or fix the student class enrolment. | Critical | Public Sec | OnSIS XML | |
MSE0154 | Extended Day Program type must not be reported for student that is 2 or 3 years as of December 31 of the academic year or grade is 1-8. | The student is 2 or 3 years old as of December 31 if the academic year or the student's grade is 1-8 | Do one of the following:
| Critical | Public Elem | Database | |
MSE0171, MSE0171a | Residence Status is not defined for the student. | The student's RESIDENCE_STATUS_TYPE is not reported | Navigate to Student > Province - ON > General Info OR to Student > Transfer Info and enter the student's Residence Status AND Navigate to Ontario Provincial Information > Snapshot (if it exists) and enter the student's Residence Status | Critical | Public Elem, Public Sec, , Night, Summer (171a = Private Sec) | OnSIS XML | |
MSE0174 MSE0174a | If Province (Current Residence) is Ontario, a Postal Code must be provided. | The CURRENT_RESIDENCE_Province is reported as Ontario but POSTAL_AREA_TYPE is not reported | Navigate to Student > Demographics and enter a postal code AND navigate to Ontario Provincial information > Snapshot (if it exists) and enter the postal code | Critical | Public Elem, Public Sec, Night, Summer (174a = Private Sec) | OnSIS XML | |
MSE0194 | For student attending Online School, Board Residence Status must be one of the following: -08 - Shared Students -09 - Online student. | The school is online school (where is Online school checkbox is selected) Students is enrolled in the school. If snapshot record exists and Board Residence Status is not 08 or 09 OR If [Students/Reenrollments]ON_Brd_Res_Status is not 09 or 08 where the count date is between the enrolment entry and exist date. ( or effective date for GV) | Navigate to student snapshot record (if created) and Student\Transfer Information\Current or Previous Enrolment to correct the Board Residence Status Value. Both records must have the correct Board Residence Status. | Critical | Public Secondary Online school, General validation | Database | |
MSE0199 | Number of credits for PLAR Type of “Individual equivalency Assessment for Grade 11 or 12” is more than 10. | Mature student flag is selected and total PLAR courses credits earned with <PLAR_TYPE> 7 + 8 is > 10 and the PLAR Attendance Type is not defined Total PLAR credits calc:
| Navigate to Student > Academics > Historical Grades to fix the errors. | Critical | Public and Private Secondary Night, CTCC, general validation | database | |
MSHSMC005 | The total SHSM Certification Hours for all SHSM Certifications reported for an SHSM Program must not exceed 999 | The student's total SHSM Certification hours for all SHSM Certificates for an SHSM Program are greater than 999.
| Navigate to Student > State/Province - ON > SHSM Certifications tab to correct the data. | Critical | Public Sec, Night | Database | |
MSHSMP004 | All Requirements Met Date is entered. Student must have completed at least one SHSM Certification prior to the All Requirements Met Date. |
Note: A student can complete certifications that are linked or not linked to a SHSM program; however, only certifications associated to the program are considered. | Navigate to Student > State/Province - ON > SHSM Certifications to correct the data. | Critical | Public, Sec, Night | Database | |
MSHSMP007 | SHSM Program is only applicable to students in Grades 11 and 12. |
Note: No Show students in SHSM Programs are excluded. | Modify the student's grade level or navigate to Student > Special Programs to delete the SHSM program. | Critical | Public Sec | Database | |
PS-000002 | Student is missing OEN. | The student's OEN field is empty. | Navigate to State/Province - ON > General Info tab to correct the data. | Error | Public Elem, Private Elem, Public Sec, Private Sec, Night, Summer, ECPP, General Validations | Database | |
PS-000003 | The SHSM Component cannot be blank if All Requirements Met Date is set for the student's SHSM program. |
Note: No Show students in SHSM programs are excluded. | Navigate to Student > Special Programs > Edit the SHSM program and populate SHSM Component field. | Error | Public OnSIS Sec, Private OnSIS Sec, Night | Database | |
PS-000004 | SHSM Skills And Work Habits Development (OSP) Date is missing for the student's SHSM program |
Note: No Show students in SHSM programs are excluded. | Navigate to Student > Special Programs > Edit the SHSM program and populate SHSM Skills And Work Habits Development (OSP) Date field. | Error | Public OnSIS Sec, Private OnSIS Sec, Night | Database | |
PS-000005 | If All Requirements Met Date is set and SHSM Component is SPC for the student's SHSM program, then at least one of the SPC component check boxes must be selected for the student |
Note: No Show students in SHSM programs are excluded. | Navigate to Student > Special Programs > Edit the SHSM program and select at least one of the 3 SPC components. | Error | Public OnSIS Sec, Private OnSIS Sec, Night | Database | |
PS-000006 | If All Requirements Date Met is entered for a SHSM Program, Experiential learning and career exploration activities and “Reach ahead” experiences requirements must be completed. |
Note: No Show students in SHSM programs are excluded. | Navigate to Student > Special Programs > Edit the SHSM Program and set the dates. | Error | Public OnSIS Sec, Night, General Validations | Database | |
PS-000007 | The start date of one or more of the student's classes is not marked as in-session day in the school calendar. | The start date of one or more of the student's classes is not marked as in-session day in the school calendar. | Navigate to Student > All Enrollments > Edit Enrollment record and correct the Enrol Date(s). | Error | General Validations | Database | |
PS-000008 | The student's Diploma Certificate Type or Diploma Certificate Requirements Met Date is not defined for the student | The student has an exit code of 61 (received OSSD) or 62 (received OSSC) or 63 (rec’d COA) but does not have the corresponding certificate type or diploma certificate granted date defined on the State/Province - ON > General Info tab. | Navigate to Student > State/Province - ON > General Info tab and enter the Certificate or Diploma Certificate Requirements Met Date. | Error | Public OnSIS Sec Private OnSIS Sec, Night | Database | |
PS-000012 | Incident Management - Student must have at least one behaviour assigned. | The student is an offender on an incident record but does not have a primary behavior assigned. | Navigate to Student > Administration > Incidents and add the primary behavior | Error | Elem, Sec, General Validations | Database | |
PS-000013 | Special Programs - Student is assigned to a program where the program exit date is less than the program entry date | The student is assigned to a special program where the progam exit date is less than the program entry date. | Navigate to Student > State/Province - ON > Special Programs and correct the dates. | Error | Public Elem Private Elem, Public Sec, Private Sec, General Validations | Database | |
PS-000014 | A student has earned their SHSM but has not earned their OSSD | The student has
| Either Navigate to the student General Info page to award the OSSD 1999 to the student (assuming all requirements are met) or Navigate to the student's special programs page > SHSM> and remove the ALL Requirement Met date for the SHSM | Error | Public Secondary | OnSIS XML | |
PS-MSE0030a | 'Destination Country' cannot be Canada. | Exit Code is 68 - Moved outside of Ontario and Destination Country is set to Canada. | Navigate to Student > Transfer Information > Current or Previous Enrolment | Critical | OnSIS Elem, Public Sec, Private Sec | Database | |
PS-MSE0030b | 'Destination Province' cannot be Ontario. | Exit Code is 68 - Moved outside of Ontario, Destination Province is set to Ontario. | Navigate to Student > Transfer Information > Current or Previous Enrolment | Critical | OnSIS Elem, Public Sec, Private Sec | Database | |
PS-A001 | Student with overlapping enrolment, this error will cause the Nightly attendance process to fail | Error is generated for students that have overlapping enrolments. | Navigate to the student's Transfer Info page and correct the students' school enrolments. | Error | Attendance | Database | |
PS-A002 | Student with missing Admission Status (FTE), this error will cause the AM/PM nightly process to fail. | Error is generated for students with missing Admission Status (FTE). | Navigate to the student's Transfer Info page and populate the Full-time Equivalency (Admission Status). | Error | Attendance | Database |
Educator
Message Code | Message | Error is Generated if the Following is True | Action to Correct Error | Severity | Rules Apply To | Validation Source | Close Date |
|---|---|---|---|---|---|---|---|
MSED021a | If "Teaching-Leading/ Non-Teaching" = "B - Teaching-Leading/ Non-Teaching", the educator must be attached to an active class in "Class Information" | If TEACHING_TYPE = 'B' and there is no segment in CLASS_ASSIGNMENT where:
| Fix the Educator Schedule | Critical | Public Secondary for October and March submission Cycle | OnSIS XML | |
MSED023
| If "Teaching/ Non Teaching" = "T - Teaching", record in "Assigned Subject Information" or in "Class Information" is required | Applies to October submission only If TEACHING_TYPE = T there should be at least one CLASS_ASSIGNMENT segment with Action of ADD/UPDATE. . | Fix the educator’s schedule | Critical | Public & Private Elem | OnSIS XML | |
MSED044
| If Teaching/Non-Teaching flag = Non-Teaching, then Instructional Type must have a value. | Rule applies to October for elementary and all submissions for secondary If the TEACHING-TYPE = N and an Instructional_TM segment exists with Action ADD and Instructional_TM_type is empty or the Instructional_TM segment is not generated for the educator. | Navigate to the staff assignment and add Instructional TM Type | Critical | Public and Private Elementary. public Secondary | OnSIS XML | |
MSED065
| Core Elementary Teacher Flag must = No (be unchecked), if the Educator is indicated with a Leave or Withdrawal Type Code |
| Fix the staff assignment record for the educator | Critical | Private & Public elementary schools | OnSIS XML | |
MSED072
| If educator is indicated with a Teaching/Non-Teaching value equal to “Not Applicable (N/A)”, Leave or Withdrawal Type Code must have a value. | Rule applies to all submissions for secondary, October submission for elementary if Teaching_type = NA and both Leave_type and Widrawal_type are blank. | Fix the staff assignment record | Critical | Public and Private Elementary and public Secondary | OnSIS XML | |
MSED091
| If Position type = ‘Early Childhood Educator’ or ‘Early Childhood Educator, LTO, and Teaching/Non Teaching = ‘Teaching-Leading’ then there must be a class assignment and no assigned subject. |
| Fix the staff assignment Position type | Critical | Public Elementary schools | OnSIS XML |