School Setup

Code

Enter the attendance code.

[Attendance_Code]Att_Code

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Description

Enter a description of the attendance code.

[Attendance_Code]description

Continuing Education Registers (Summer School, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Presence Status

Select Present or Absent.

[Attendance_Code]Presence_Status_CD

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Code Categories

Select the categories associated with the attendance code.

[Att_Code_Code_Entity]Code_EntityID

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Code

The following categories must be created:

• Tardy

• Grant

• Non-Instr

• Contact

• IndepStudy

• ConEd

• *CEUNFUNDED

*Used for unfunded, cancelled instructional sessions

Note: When counting consecutive absences, Attendance codes associated with CEUNFUNDED are ignored.

[Code_Entity]CE_Entity = att_attcodeentity

[Code_Entity]CE_Code

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Attendance Recording Methods

Ensure 'Meeting' method is selected.

[Prefs]Name  = att_recordmodemeet

[Prefs]Value

Elementary Progress Reports, Elementary Report Card, Daily Attendance Record, OnSIS Submissions

Count Meeting attendance recorded at another school for students enrolled at this school

Select if students enrolled in other schools should have that time included in attendance.

This flag is used when calculating the student's FTE.  FTE should be reported from the student's main school.

[Prefs]Name  = att_calccntattothschenrthissch

[Prefs]Value

Elementary Progress Reports, Elementary Report Card, Daily Attendance Record, OnSIS Submissions

Attendance Conversion Method

Choose the attendance conversion from the pop-up menu. You must first set up an attendance conversion to properly calculate attendance.

[Bell_Schedule]Attendance_Conversion_ID

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

Day Part

Select AM or PM for each period in schedule.

[Bell_Schedule]DayPartID

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

Schedule

Bell Schedule used for the day.

[Calendar_Day]Bell_Schedule_ID

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Continuing Education Registers (Summer School)

Tracks

Tracks that are in session should be selected to determine if the track day is in session for the student.

If the track is not selected on an in-session day, students in that track are in a non-instructional day.

[Calendar_Day]A

[Calendar_Day]B

[Calendar_Day]C

[Calendar_Day]D

[Calendar_Day]E

[Calendar_Day]F

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Continuing Education Registers (Summer School)

In Session

Determines if the day is instructional and the student attendance is looked at.

[Calendar_Day]Insession

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions, Continuing Education Registers (Summer School)

Type

Determines if the day of the month is a Holiday, Professional Activity Day, Grant or Non-Instruction Day. If the day is in-session and no type is selected, the day defaults to an Instruction Day.

[Calendar_Day]Type

Daily Attendance Record, Continuing Education Registers (Summer School)

Admission Status (or Full-Time Equivalency)

This must be defined to calculate attendance. Every student must have a valid full-time equivalency (internal field for students is FTEID)

[FTE]ID

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

FTE

The name of the attendance conversion

[Attendance_Conversion_Items]FTEID

Periods Present or Periods Absent

Depending on how the attendance preference is set up, define the number of periods in which the student must be present/absent to receive the attendance value for defined ADA.

[Attendance_Conversion_Items]Input_Value

[Attendance_Conversion_Items]conversion_mode_code = ‘periodPart’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

AM Attendance Value

If Period Present, enter the attendance value for ADA that students receives for the AM day part if they are present for the number of periods defined. If Period Absent, enter the attendance value for ADA that students receive for the AM day part if they absent for the number of periods defined.

The reports will use the Period Conversion View

[Attendance_Conversion_Items]Attendance_Value

[Attendance_Conversion_Items]DayPartID = [DayPart]ID where [DayPart]Name = ‘AM’

View

[PS_ADAADM_Meeting_PTOP]AttendanceValue

[PS_ADAADM_Meeting_PTOP]Potential_AttendanceValue

[PS_ADAADM_Meeting_PTOP]DayPartName = ‘AM’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

PM Attendance Value

If Period Present, enter the attendance value for ADA that students receives for the PM day part if they are present for the number of periods defined. If Period Absent, enter the attendance value for ADA that students receive for the PM day part if they absent for the number of periods defined.

The reports will use the Period Conversion View

[Attendance_Conversion_Items]Attendance_Value

[Attendance_Conversion_Items]DayPartID = [DayPart]ID where [DayPart]Name = ‘PM’

View

[PS_ADAADM_Meeting_PTOP]AttendanceValue

[PS_ADAADM_Meeting_PTOP]Potential_AttendanceValue

[PS_ADAADM_Meeting_PTOP]DayPartName = ‘PM’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

Minutes Present

Enter the minimum number of minutes a student must be present to receive the attendance value for ADA that you define.

[Attendance_Conversion_Items]Input_Value

[Attendance_Conversion_Items]conversion_mode_code = ‘timePart’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

AM Attendance Value

Enter the attendance value for ADA that students receive for the AM day part if they present based on the number of minutes entered in Minutes Present.

The reports will use the Time Conversion View

[Attendance_Conversion_Items]Attendance_Value

[Attendance_Conversion_Items]DayPartID = [DayPart]ID where [DayPart]Name = ‘AM’

View

[PS_ADAADM_Meeting_TTOP]AttendanceValue

[PS_ADAADM_Meeting_TTOP]Potential_AttendanceValue

[PS_ADAADM_Meeting_TTOP]DayPartName = ‘AM’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

PM Attendance Value

Enter the attendance value for ADA that students receive for the PM day part if they present based on the number of minutes entered in Minutes Present.

The reports will use the Time Conversion View

[Attendance_Conversion_Items]Attendance_Value

[Attendance_Conversion_Items]DayPartID = [DayPart]ID where [DayPart]Name = ‘PM’

View

[PS_ADAADM_Meeting_TTOP]AttendanceValue

[PS_ADAADM_Meeting_TTOP]Potential_AttendanceValue

[PS_ADAADM_Meeting_TTOP]DayPartName = ‘PM’

Elementary Progress Reports, Elementary Report Card, Secondary Report Card, Daily Attendance Record, OnSIS Submissions

Name Of School Year

For record designated as year term.

[Terms]Name

Enrolment Report, Daily Attendance Record, OnSIS Submissions

First Day Of Term

For terms associated with classes.

[Terms]FirstDay

Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Last Day Of Term

For terms associated with classes.

[Terms]LastDay

OST, SHSM Record, Status Sheet, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Mark Type

Select from the pop-up menu:

M1 (midterm 1)

M2 (midterm 2)

F (final)

If a mark is not a mid-term or final mark, do not select a value.

[S_ON_TRB_X]Mark_Type

Status Sheet, Potential Ontario Scholar, SHSM Record, Ontario Student Transcript, Secondary Report Card, OCAS/OUAC Transmissions

Reporting terms

Three Reporting Terms should be created: 

P, R1 and R2

Course Number

In elementary schools used for homeroom classes.

In secondary schools used for next year classes.

[Sections]Course_Number

Enrolment Report, Daily Attendance Record, Status Sheet, OnSIS Submissions, EQAO Submissions

Term

Used to identify eligible math classes for grade 9 EQAO submissions.

[Sections]TermID

EQAO Submissions

Teacher – Section Lead

Staff

[SectionTeacher]TeacherID

Where [SectionTeacher]sectionID = [Sections]ID

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Enrolment Report, Daily Attendance Record, OnSIS Submissions, EQAO Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Teacher – Section Lead

Role

LeadTeacher will have islocked set to 1

OnSIS Elementary also uses Name Setup as

ECE – Early Childhood Educators

[Roledef]islocked = 1

And/OR

[Roldedef]name

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Enrolment Report, Daily Attendance Record, OnSIS Submissions, EQAO Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Teacher – Section Lead

Start Date

[SectionTeacher]start_date

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Enrolment Report, Daily Attendance Record, OnSIS Submissions, EQAO Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Teacher – Section Lead

End Date

[SectionTeacher]end_date

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Enrolment Report, Daily Attendance Record, OnSIS Submissions, EQAO Submissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Section Number

In elementary schools used for homeroom classes.

In secondary schools used for next year classes

[Sections]Section_Number

Enrolment Report, Daily Attendance Record, Status Sheet, OnSIS Submissions, EQAO Submissions, STIX, Continuing Education Registers (Summer School)

Grade Level

Enter a number corresponding to the grade level.

[Sections]Grade_Level

OnSIS Submissions

Exclude From Attendance

If selected, this section will not be used for calculating instructional minutes

[Sections]Exclude_ADA

Enrolment Report

Class Type

Select from the pop-up menu.

Refer to Class Type entries in the ministry OnSIS Reference Table Spreadsheet.

[S_ON_SEC_X]Class_Type

OnSIS Submissions

Delivery Type

Select a delivery type.

Refer to Course Delivery Type entries in the ministry OnSIS Reference Table Spreadsheet.

Notes:

if Credit Recovery is selected below, Delivery Type must be one of the following:

• 1 - Regular day

• 8 - Summer

• 9 - Night

• 18 E-learning – not through provincial LMS,

• 19 - E-learning through provincial LMS

If Ministry Developed Content is selected below, Delivery Type must be 19 - E-learning through provincial LMS.

[S_ON_SEC_X]Delivery_Type

If [S_ON_SGR_X]OthCrsInfo_Credit_Recovery = 1, THEN

[S_ON_SEC_X]Delivery_Type must = 1, 8, 9, 18, or 19

If [S_ON_SGR_X]OthCrsInfo_Ministry_Content = 2, THEN

[S_ON_SEC_X]Delivery_Type must = 19

Status Sheet, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language, OnSIS Submissions, OCAS/OUAC Transmissions

Other Course Information

Credit Recovery (1)

Ministry Developed Content (2)

Upgrading Credit Course (3)

Online (4)

Credit Recovery: Indicates whether the section is used for credit recovery.

Ministry Developed Content: Indicates whether the section contains content developed by the ministry.

Select both options if the section is used for credit recovery and the content is ministry developed

Upgrading Credit Course: Identifies secondary courses that were upgraded by students during the summer,.  This value is applicable 2019-2020 onwards and is only visible for summer schools.

Online: Identifies whether the course is taken online.  This value is applicable 2022-2023 onwards.

Notes:

If Credit Recovery is selected, Delivery Type must be one of the following:

• 1 - Regular day

• 8 - Summer

• 9 - Night

• 18 E-learning – not through provincial LMS,

• 19 - E-learning through provincial LMS

If Ministry Developed Content is selected, Delivery Type must be 19 - E-learning through provincial LMS.

If Online is selected, Delivery Type must be one of the following:

• 2 – Independent Study

• 4 - Co-op

• 12 - DC: team-taught coll crs

• 16 - Correspond/Self-study

If Upgrading Credit Course’, then is selected Course Delivery Type must be one of the following:

1 – Regular

2 - Independent study

16 - Correspond/Self study

18 - E-learning - not through provincial LMS

19 - E-learning through provincial LMS. otherwise an error message is displayed under the field "Incorrect Other Course Information'

[S_ON_SEC_X]OthCrsInfo_Credit_Recovery = 1 When selected otherwise NULL

[S_ON_SEC_X]OthCrsInfo_Ministry_Content = 2 When selected otherwise NULL

[S_ON_SEC_X]OthCrsInfo_UpgradCrdtCourse = 3 when selected otherwise NULL

• 1 = Credit Recovery

• 2 = Ministry Developed Content

• 3 = Upgrading Credit Course

• 4 = Online

If [S_ON_SEC_X]OthCrsInfo_Credit_Recovery = 1, THEN

[S_ON_SEC_X]Delivery_Type must be in (1, 8, 9, 18, or 19)

If [S_ON_SEC_X]OthCrsInfo_Ministry_Content = 2, THEN

[S_ON_SEC_X]Delivery_Type must = 19

If [S_ON_SEC_X]OthCrsInfo_Online = 4, THEN

[S_ON_SEC_X]Delivery_Type must be in (2,4,12,16)

OnSIS Submissions

Classroom Type

Select from the pop-up menu.

Refer to Classroom Type entries in the ministry OnSIS Reference Table Spreadsheet.

[S_ON_SEC_X]Classroom_Type

OnSIS Submissions

Campus Number

The campus number can be up to 20 characters

 The following characters can be included:

• a-zA-Z0-9ÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌì ÔôÖöÓóÜüÙùÛûÚúÇçÿŸ/, ""';:=_.`~!@#%-$&^{}[](|)*+?\

• Accents are to be accepted.

Note: The following characters are not to be included:

• < and >

• Control characters (ESC, CTRL, Alt, TAB, Page Up, Page Down, Space, Insert)

[S_ON_SEC_X]Campus

OnSIS Submissions, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

Language Program Type

Select from the pop-up menu.

If not selected here, the course level setting is used.

• C - Core

• E - Extended

• I - Immersion

• N - Intensive Core

[S_ON_SEC_X]Lang_Pgm_Type

Elementary Progress Report, Elementary Report Card, OnSIS Submissions, EQAO Submissions, Student Record of Accumulated Instruction in French As a Second Language

Language Of Instruction

Select from the pop-up menu.

Refer to Language Type entries in the ministry OnSIS Reference Table Spreadsheet.

Only the English, French, and Native languages are available.

[Sections]Instruction_Lang

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OnSIS Submissions, EQAO Submissions, OCAS/OUAC Submissions, Student Record of Accumulated Instruction in French As a Second Language - French Cards

Class Name

If undefined, [Courses]Course_Name used.

[S_ON_SEC_X]Class_Name

Secondary Report Card, Continuing Education Registers, (Summer School, Correspondence/Self-Study/Online, Adult Credit, Adult Indigenous Language,  International Languages Elementary), OnSIS submissions.

Class Code

Generated by OnSIS Create Class Codes process.

Normally this field should not be changed manually. This field is editable only if a preference named "AllowClassCodeEdit" is present in the Prefs table with a value of 1. If the preference is not present or has a value other than 1 the field is read only.

[S_ON_SEC_X]Class_Code

OnSIS Submissions

Instruction Mode

Select the Section Instruction Mode, if different than the School/Course

Valid Values:

• (01) FT In-person learning

• (02) FT remote learning

• (03) Combination of in-person and remote learning

[S_ON_SEC_X]InstructionMode

EQAO Grade 9 Math Extract

Previous Year Class Flag

Select if the class is continued from the previous year.

[S_ON_SEC_X]Previous_Year_Class

OnSIS Submissions

Course Offering

Select from the pop-up menu.

If not defined, the course offering entered at the course level is used.

[S_ON_SEC_X]Course_Offering

[S_ON_CRS_X]Course_Offering

It is mandatory to set course offering for summer courses.

Continuing Education Registers (Correspondence/Self-Study/Online, Adult Credit, Literacy and Numeracy, Adult Indigenous Language)

Continuing Education (Summer) OnSIS submission ( Summer)

Class Start Date

Enter a date if the class start date used to determine number of sessions and ADE is different than the start date of the associated scheduling term.

The date must fall within the scheduling term.

[S_ON_SEC_X]ConEd_SectionStartDate

Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy and Numeracy, Adult Indigenous Language,  International Languages Elementary), OnSIS Submissions (Summer, Night)

Class End Date

Enter a date if the class end date used to determine number of sessions and ADE is different than the end date of the associated scheduling term.

The date must fall within the scheduling term.

[S_ON_SEC_X]ConEd_SectionEndDate

Continuing Education Registers (Summer School,Correspondence/Self-Study/Online, Adult Credit, Literacy and Numeracy, Adult Indigenous Language,  International Languages Elementary), OnSIS Submissions (Summer, Night)

Start Time

The start time of the class.

Start Time must be less the End Time

[S_ON_SEC_X]ConEd_SectionStartTime

Continuing Education Registers (Adult Credit, Summer School, International Languages Elementary, Literacy and Numeracy, Adult Indigenous Language)

End Time

The end time of the class.

Start Time must be less the End Time

[S_ON_SEC_X]ConEd_SectionEndTime

Continuing Education Registers (Adult Credit, Summer School, International Languages Elementary, Literacy and Numeracy, Adult Indigenous Language)

Total Instruction Minutes

The total number of minutes of instruction for a class.

Total Instruction minutes must be greater than Zero

[S_ON_SEC_X]ConEd_SectionInstrMinutes

Continuing Education Registers (Adult Credit, Summer School, International Languages Elementary, Literacy and Numeracy, Adult Indigenous Language)

Number Of Lessons/Work Units

Select from the pop-up menu.

If not defined, the number of lessons/work units entered at the course level is used.

[S_ON_SEC_X]ConEd_CompleteCrsLessons

[S_ON_CRS_X]ConEd_CompleteCrsLessons

Continuing Education Registers (Correspondence/Self-Study/Online)

Eligible for Small Class Adjustment

Select if eligible for adjustment.

[S_ON_SEC_X]SmallClassAdjustmentEligible

Continuing Education Registers (Adult Credit)

Literacy and Numeracy Delivery Code

Only displayed if the current school year is 2015-2016 or earlier.

Select from the pop-up menu:

• After School (1)

• Before School or Lunch time (2)

• Integrated Extended-Day Program (3)

• Late Afternoon and Evening Program (4)

• Weekend (5)

• Summer (6)

If not defined the delivery type used at the course level is used.

[S_ON_SEC_X]ConEd_Delivery_Type

Continuing Education Registers (Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary)

ILE Register Type

Select from the pop-up menu:

• <blank> (default)

• "International Languages Elementary (ILE) Program"

If not defined, the register type entered at the course level is used.

Determines if the section is included in the International Languages Elementary  register.

[S_ON_SEC_X]Register_Code

Continuing Education Registers (International Languages Elementary)

International Language

Select from the pop-up menu.

If not defined, the course offering entered at the course level is used.

[S_ON_SEC_X]ConEd_InternationalLanguage

Continuing Education Registers (International Languages Elementary)

Other Language Description

When International Language is “Other (OTH)”, enter the language description.

[S_ON_SEC_X]OtherLanguageDesc

Continuing Education Registers (International Languages Elementary)

Time of Day Type

Enter the time of day for the International Language Elementary (ILE) class

[S_ON_SEC_X]TimeOfDayType

Continuing Education Registers (International Languages Elementary)

ILE Delivery Code

Select from the pop-up menu:

• After School (1)

• Before School or Lunch time (2)

• Integrated Extended-Day Program (3)

• Late Afternoon and Evening Program (4)

• Weekend (5)

• Summer (6)

If not defined the delivery type used at the course level is used.

[S_ON_SEC_X]ILE_ConEdDelivery_Type

Continuing Education Registers (International Languages Elementary)

Independent Study Class Flag

Select if the class is an independent study class.

[S_ON_SEC_X]IsIndependentStudy_Class

OnSIS, Enrolment Report, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, Adult Indigenous Language,  International Languages Elementary), Enrolment Fields Report

Number of Scheduled Teacher Contact Sessions (required to complete course)

Select from the pop-up menu with range from 10 to 30.

If not defined, the number of sessions entered at the course level is used.

[S_ON_SEC_X] IS_NumberSessionsCompleteCrs

Independent Study and e-Learning Register for Day School Pupils

Duration of each Scheduled Teacher Contact session (minutes)

Requires a minimum value of 30.

If not defined, the number of minutes entered at the course level is used.

[S_ON_SEC_X]IS_DurationSessionsMinutes

Independent Study and e-Learning Register for Day School Pupils

Number of Work Units (required to complete course)

Select from the pop-up menu with a range from 1 to 30.

If not defined, the number of sessions entered at the course level is used.

[S_ON_SEC_X]IS_WorkUnitsCompleteCrs

Independent Study and e-Learning Register for Day School Pupils, OnSIS

The individual fields in this section will be defined in a later documentation release.

Create a graduation set for each SHSM program offered by the board. If the credit requirements for a SHSM program change, a new graduation set for that program must be created.

Appendix D contains a description of how generally graduation sets are configured to describe SHSM program credit requirements. Refer to the ministry's sector-specific guides for credit requirements specific to a particular program.

The individual fields in this section will be defined in a later documentation release.

Secondary Report Card, OST, SHSM Record, Status Sheet