District Setup

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Name of District

The name of the district.

[Prefs]Name=districtname

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OST, SHSM Record, STIX

District Number

Enter BSID number for the board.

This field is Mandatory.

[Prefs]Name=districtnumber

[Prefs]Value

OST, STIX, Student Record of Accumulated Instruction in French As a Second Language

District Address

The district address.

[Prefs]Name=districtaddress

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card

District City

The district city.

[Prefs]Name=districtcity

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card

District State/Province

The district state or province.

[Prefs]Name=districtstate

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card

District Postal Code

The district postal code.

[Prefs]Name=districtZip

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card

District Country

The district country.

[Prefs]Name=districtcountry

[Prefs]Value

Elementary Progress Report, Elementary Report Card, Secondary Report Card

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Select Year

Select the year you want to define the OnSIS Reporting Dates for. 

[S_ON_DISTRICTINFO_BY_YEAR_S]YearID

OnSIS Submissions

Set Default Dates

Click to set default dates for all count dates of the selected year.

[S, _ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Oct_Date, 

OnSIS_Mar_Date, OnSIS_Jun_Date, OnSIS_Aug_Date, 

OnSIS_CTCC_Date,  OnSIS_Oct_Start_Date

OnSIS Submissions

October

Enter count date for October OnSIS submissions.

[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Oct_Date

OnSIS Submissions

March

Enter count date for March OnSIS submissions.

[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Mar_Date

OnSIS Submissions

June (End of Year)

Enter count date for year end OnSIS submissions.

[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Jun_Date

OnSIS Submissions

August (Night and Summer)

Enter count date for Summer and Night OnSIS submissions.

[[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Aug_Date

OnSIS Submissions

August (ECPP)

Enter count date for ECPP OnSIS submissions.

[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_CTCC_Date

OnSIS Submissions

October Submission Period Start Date

Enter the start date for the October submission period.

If left undefined, the OnSIS submissions use a start date of July 1 of the selected school year.

[S_ON_DISTRICTINFO_BY_YEAR_S]OnSIS_Oct_Start_Date

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

October

Enter count date for October OnSIS submissions.

[Prefs]Name=ON_Oct_Date

[Prefs]Value

OnSIS Submissions

March

Enter count date for March OnSIS submissions.

[Prefs]Name=ON_Mar_Date

[Prefs]Value

OnSIS Submissions

June (End of Year)

Enter count date for year end OnSIS submissions.

[Prefs]Name=ON_Jun_Date

[Prefs]Value

OnSIS Submissions

August (Night and Summer)

Enter count date for Summer and Night OnSIS submissions.

[Prefs]Name=ON_Aug_Date

[Prefs]Value

OnSIS Submissions

August (ECPP)

Enter count date for ECPP OnSIS submissions.

[Prefs]Name=ON_Aug_Date

[Prefs]Value

OnSIS Submissions

October Submission Period Start Date

Enter the start date for the October submission period.

If left undefined, the OnSIS submissions use a start date of July 1 of the current school year.

[Prefs]Name = ON_Oct_Start_Date

[Prefs]Value

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Number Of Previous OnSIS Snapshots To Retain

Select a number between 0 and 20.

[Prefs]Name=ON_OnSIS_Snapshot_Retention

[Prefs]Value

OnSIS Demographic Snapshot

Enable PAE Import School Parameter

T or F

Controls whether the PAE import process displays a parameter allowing users to specify the school with which imported PAE records are associated. This flag should be selected only for schools with students in both elementary and secondary grade levels that have a single ministry BSID number (for example, a school that contains grades 5 - 12), but is set up in PowerSchool as two separate schools for the purposes of scheduling, reporting..etc.

[Prefs]Name=ON_PAE_Import_School_Flag

[Prefs]Value

OnSIS PAE Import

Exclude Elementary Achievements From OnSIS Submissions

T or F

Controls whether to include/exclude the student elementary achievements from the OnSIS submission for all the schools in the board.

This option is for boards that are not reporting students' achievements through PowerSchool.

[Prefs]Name=ON_ExcludeElemRC

[Prefs]Value

ONSIS Elementary School Submission

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Board Email Address

The board email address.

[Prefs]Name=ON_DistrictEmail

[Prefs]Value

Secondary Report Card

Board Website

The board website.

[Prefs]Name=ON_DistrictWebsite

[Prefs]Value

Secondary Report Card

Catholic Board Flag

T or F

Controls which version of progress reports and report cards are generated.

[Prefs]Name=ON_Catholic_Board_Flag

[Prefs]Value

Elementary Progress Report, Elementary Report Card

French Board Flag

T or F

[Prefs]Name=ON_French_Board_Flag

[Prefs]Value

OnSIS Submissions, OCAS/OUAC Transmissions

Exclude Teachers From Provincial Reporting

T or F

Check if the school educator assignment segments (and child segments) are to be excluded from OnSIS submissions.

[Prefs]Name=ON_Exclude_Teacher_Reporting

[Prefs]Value

OnSIS Submissions

Default French Language Program Type

Choose the default French language program.

The default value is used when the second language program type cannot be determined from a French class enrolment.

[Prefs]Name = ON_French_Pgm_Type

OnSIS Submissions

Secondary Report Card Examine Exclude From GPA Flag

T or F

Controls whether the secondary report card examines the exclude from GPA flag for a mark.

[Prefs]Name = ON_SRC_ExcludeFromGPA

Secondary Report Card

Secondary Report Card format OEN on all pages

T to F

Controls whether the OEN is printed as ###-###-### on all report pages.

[Prefs]Name = ON_SRC_FormatOEN

Secondary Report Card

Allow Class Code Edits

T or F

Controls whether the Class Code field on the Edit Section Information data entry page is enabled.

[Prefs]Name = AllowClassCodeEdit

OnSIS Create Class Codes

Show Literacy And Numeracy Parent/Guardian Contacts Only

T or F

Controls the content of the parent/guardian drop-down list on the Edit Class Enrollment and Enroll Student In A Class At Another School data entry pages.

[Prefs]Name = ON_LNPG_Contacts_Only

If T, the drop-down list contains only records from [S_Contacts_S] where [S_Contact_Relationship_C]Association = "LNPG".

If F, the drop-down list contains the contacts above plus [Students]Mother, Father, and Guardian contacts (if defined).

Continuing Education Registers (Literacy and Numeracy), OnSIS Submissions (Night, Summer)

Exclude Progress Report Card Absences flag

Select to exclude Progress Report Card Absences from term 1 absence calculations.

[Prefs]Name = ExcludeProgressReport

OnSIS Elementary Submissions.

Print ECPP Principal and Telephone on Report Cards

Select to Print ECPP School Principal name and telephone number on report cards.

[Prefs]Namw = ON_ECPP_Principal_Telephone_Flag

Elementary report cards, Secondary Report cards.

Create Only Summer School Class Enrollment Records.

This checkbox is only available for boards running PowerSchool 12.x and State reporting 18.4 or above.

T or F

Controls whether the remote summer school feature creates a re-enrollment record. When set to T, no re-enrollment records are created for summer school students; only the CC enrollment record is created.

[Prefs]Name = summerschoolallowclassonly

Use Student Contacts for Reports

T or F

Controls whether reports should use the Contacts page to report student's contacts or use the information on the student Demographic & Emergency Contacts pages to report student's contacts.

[Prefs]Name = SRUseContacts

Office Index Cards, STIX

Force Use Of School Search

T or F

This flag should be used by boards to disable school information fields (school name, address and language) on several pages and force user to populate those fields by searching and selecting a school through the new School BSID field.

School Felds are disabled on the following pages when the flag is selected: Enroll New Student, Enroll New Student Living in Same Household, Create New School Enrolment, Re-enroll Student, Transfer Info, Transfer Student Out., Province>General Info tab.

[Prefs]Name = ON_Force_School_Search

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Font Size For Comments

Enter the desired font size. This value overrides the report default of 10.

Although the report will use the shrink to fit feature when necessary to fit the comment in the box, an overflow may occur if the maximum number of characters allowed for each comment is not adjusted to account for the font size selected.

[Gen]Name=ON_KRC_Comment_Size

[Gen]ValueX

Kindergarten Report Card Initial Observation Report Card

Kindergarten Report Card: Four Frames Report (KCL-4F)

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Logo Image

Click Browse and select the image file to appear in the logo section on page 1 of the elementary progress report.

[Gen]Name=district_logo

[Gen]ValueX

Kindergarten & Elementary Progress Report

Kindergarten Communication of Learning Board Information Image

Click Browse and select the image file to be printed on the KLC-IO and KCL-4F reports.

The loaded file must be a .JPG or .JPEG file only.

The space available on the report will support an optimal image size of 533 pixels wide by 203 pixels high for both Catholic and public boards. The image used should be as close to this size as possible and not exceed this size. If a smaller image is used, the image will not fill the available space completely.

Large-size images could cause performance issues.

[Gen]Name=JK_K_Board_Info

[Gen]Value

Kindergarten Communication of Learning: Initial Observations (KCL-IO)

Kindergarten Communication of Learning: Four Frames (KCL-4F)

Progress Report Board Information Part 1 Image

Click Browse and select the image file to appear in the board information section on page 1 of the elementary progress report.

The loaded file must be a .JPG or .JPEG file only.

The space available on the report will support an optimal image size of 537 pixels wide by 140 pixels high for Catholic boards and 538 pixels wide by 205 pixels high for Public boards. The image used should be as close to this size as possible and not exceed this size. If a smaller image is used, the image will not fill the available space completely.

Large-size images could cause performance issues.

[Gen]Name=district_instructions_1

[Gen]Value

Elementary Progress Report

Progress Report Board Information Part 2 Image

Click Browse and select the image file to appear in the space designated for board section on page 2 of the elementary progress report.

The loaded file must be a .JPG or .JPEG file only.

The space available on the report will support an optimal image size of 537 pixels wide by 219 pixels high for both Catholic and Public boards. The image used should be as close to this size as possible and not exceed this size. If a smaller image is used, the image will not fill the available space completely.

Large-size images could cause performance issues.

[Gen]Name=district_instructions_2

[Gen]Value

Elementary Progress Report

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Load Codes/Subcodes

Select the checkbox on the right and click Submit

Refer to Incident Management below.

OnSIS Submission

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Pupil's Day School Override

Select the checkbox if previous school should be used as the Day School.

[S_ON_STU_X]Previous_School_Name.

Continuing Education Registers (Literacy and Numeracy), OnSIS Submissions (Night, Summer)

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Define Day 16 Dates

A page is displayed to setup Day 16 dates for the Quadmester and Octomester models.

It is expected that boards define all dates for both models before running the reports for 2020-2021 school year.

Boards using flip weeks are expected to also define Alternate Day 16 dates. If Day 16 Date falls in week A then Alternate Day 16 Date should fall on the alternate week - week B.

If dates are not defined, the Enrolments Fields report do not generate any records for schools with Quad/Octomester model.

Quadmester Setup

Select the four Quamester Day 16 dates for the year. Boards using flip weeks must also define Alternate Day 16 dates.

All dates must be within the school start and end dates.

S_ON_SIXTEENDAYDATES_S

Enrolment Fields, Enrolment Register and OnSIS Secondary Submission

Octomester Setup

Select the eight Octomester dates for the year. Boards using flip weeks must also define Alternate Day 16 dates.

All dates must be within the school start and end dates.

S_ON_SIXTEENDAYDATES_S

Enrolment Fields, Enrolments Register and OnSIS Secondary Submission

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code

The following types must be created:

B - Board Holiday

G - General Absence/Grant

N - Non-Instructional

PA - Professional Activity

H - Statutory Holiday

[Calendar_Day]Type

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

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Course Number

Local course identifier.

[Courses]Course_Number

OnSIS Submissions, STIX, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, Literacy & Numeracy, International Languages Elementary), Student Record of Accumulated Instruction in French As a Second Language

Course Name

The course name.

[Courses]Course_Name

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OST, SHSM Record, 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)

Alternate Course Number

This field must be populated as follows:

Secondary: The Ministry 5 character course code.

[Courses]Custom (alias Alt_Course_Number)

OnSIS Submissions, EQAO Submissions, OCAS/OUAC Transmissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit, International Languages Elementary), Student Record of Accumulated Instruction in French As a Second Language

Credit Hours

The credit hours.

[Courses]Credit_Hours

Secondary Report Card, OST, SHSM Record, Status Sheet, Potential Ontario Scholar Report, OnSIS Submissions, OCAS/OUAC Transmissions, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers (Summer School, Correspondence/Self-Study/Online, Adult Credit)

Credit Type

More than one credit type may be specified.

Credit types are used as the basis for credit assignment in graduation contract subject groups.

[Courses]Credit_Type

Secondary Report Card, OST, Status Sheet

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Ministry Course Name

Corresponding Ministry Course Name for this course.

[S_ON_CRS_X]Course_Name

OST, SHSM Record, 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).

Course Type

Choose a course type.

Valid values:

Elementary

• H - Homeroom

• S - Subject/Strand

• R - Religious Life

• E - Elective

• Blank - Used when students are enrolled in a course at main school for tracking purposes only and the student is cross enrolled at another school (learn@home Remote school).

Secondary

• M - Ministry Defined

• L - Locally Developed

• P - Placeholder

• O - Course Taken Out Of Board

• Blank - Used when students are cross enrolled in a course at main school for tracking purposes only and the student is enrolled at another school (learn@home Remote school).

[S_ON_CRS_X]Course_Type

OnSIS Submissions, Enrolment Report, Enrolment Reports, EQAO Extracts, STIX, French Cards

Subject Type

Choose a subject type.

Refer to Elementary Subject Type (for elementary school courses) entries in the ministry OnSIS Reference Table Spreadsheet.

[S_ON_CRS_X]Subject_Type

OnSIS Elementary Submissions, Student Record of Accumulated Instruction in French As a Second Language

Compulsory Flag

T or F

[S_ON_CRS_X]Compulsory

OnSIS Submissions

Institution

Choose an institution.

Refer to Institution Code in the ministry Dual Credit Course spreadsheet.

[S_ON_CRS_X]Institution

OnSIS Submissions

Language Program Type

Choose a language program type

Only used if not set at section level.

• C - Core

• E - Extended

• I - Immersion

• N - Intensive Core

[S_ON_CRS_X]Lang_Pgm_Type

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

Language Of Instruction

Choose the language in which the course is taught.

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

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

[S_ON_CRS_X]Instruction_Lang

OnSIS Submissions, Student Record of Accumulated Instruction in French As a Second Language

Instruction Mode

Select the Course Instruction Mode, if different than what is defined at school level.

Valid Values:

• (01) FT In-person learning

• (02) FT remote learning

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

[S_ON_CRS_X]InstructionMode

EQAO Grade 9 Math Extract

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Special Circumstances Note Flag

T or F

Only used if not set at student level.

[S_ON_CRS_X]Transcript_S

OST, Status Sheet, OCAS/OUAC Transmissions

Interdisciplinary Studies Note Flag

T or F

Only used if not set at student level.

[S_ON_CRS_X]Transcript_I

OST, Status Sheet, OCAS/OUAC Transmissions

French Note Flag

T or F

Only used if not set at student level.

[S_ON_CRS_X]Transcript_F

OST, Status Sheet, OCAS/OUAC Transmissions

Co-op Note Flag

T or F

Only used if not set at student level

[S_ON_CRS_X]Transcript_C

OST, Status Sheet, OCAS/OUAC Transmissions

Modified Curriculum Note Flag

T or F

Only used if not set at student level

[S_ON_CRS_X]Transcript_M

OST, Status Sheet, OCAS/OUAC Transmissions

Alternative Expectations Note Flag

T or F

Only used if not set at student level

[S_ON_CRS_X]Transcript_A

OST, Status Sheet, OCAS/OUAC Transmissions

Team Taught Dual Credit Note Flag

T or F

Only used if not set at student level

[S_ON_CRS_X]Transcript_T

OST, Status Sheet, OCAS/OUAC Transmissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Course Offering

Select a course offering.

Only used if not set at section level.

[S_ON_CRS_X]Course_Offering

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

Number Of Lessons/Work Units

Choose the number Of lessons or work Units

Only used if not set at section level.

To be used if below the default 20 lessons/work units.

[S_ON_CRS_X]ConEd_CompleteCrsLessons

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

Eligible for Small Class Adjustment

Check if eligible for adjustment.

[S_ON_CRS_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 a delivery code.

Valid values

• After School (1)

• Before School or Lunch time (2)

• Integrated Extended-Day Program (3)

• Late Afternoon and Evening Program (4)

• Weekend (5)

• Summer (6)

Only used if not set at the section level.

[S_ON_CRS_X]ConEd_Delivery_Type

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

Data Element

Additional Information

[Table]FieldName

Used in these Reports

IILE Register Type

Indicates whether the course is included in the International Languages Elementary register.

Valid values:

• <blank> (default)

• "International Languages Elementary Program"

Only used if not set at section level.

[S_ON_CRS_X]Register_Code

Continuing Education Registers (International/Indigenous Languages Elementary)

International/Indigenous Language

Choose a language.

Only used if not set at section level.

[S_ON_CRS_X]ConEd_InternationalLanguage

Continuing Education Registers (International/Indigenous Languages Elementary)

Other Language Description

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

[S_ON_CRS_X]OtherLanguageDesc

Continuing Education Registers (International/Indigenous Languages Elementary)

Time of Day Type

Enter the time of day for the IILE class

[S_ON_CRS_X]TimeOfDayType

Continuing Education Registers (International/Indigenous Languages Elementary)

IILE Delivery Code

Selecta delivery code

• After School (1)

• Before School or Lunch time (2)

• Integrated Extended-Day Program (3)

• Late Afternoon and Evening Program (4)

• Weekend (5)

• Summer (6)

'Only used if not set at the section level.

[S_ON_CRS_X]ILE_ConEd_DeliveryCode

Continuing Education Registers (International/Indigenous Languages Elementary)

Data Element

Additional Information

[Table]FieldName

Used in these Reports

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

Choose a range from 10 to 30.

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

[S_ON_CRS_X] IS_NumberSessionsCompleteCrs

Continuing Education Registers (Correspondence/Self-Study/Online, 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_CRS_X]IS_DurationSessionsMinutes

Continuing Education Registers (Correspondence/Self-Study/Online), Independent Study and e-Learning Register for Day School Pupils

Number of Work Units (required to complete course)

Choose a range from 1 to 30.

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

[S_ON_CRS_X]IS_WorkUnitsCompleteCrs

Continuing Education Registers (Correspondence/Self-Study/Online), Independent Study and e-Learning Register for Day School Pupils, OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Program Name

Local program name.

[Gen]Cat=specprog

[Gen]Name

OST, SHSM Record

Qualifies as special education program

T or F

[Gen]Cat=specprog

[Gen]SpedIndicator

OnSIS Submissions, EQAO Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

ESL/ELD Program Flag

T or F

[S_ON_GEN_SPECPROG_X]ESL_Flag

[Gen]Cat=specprog

OnSIS Submissions

French Exemption Flag

T or F

[S_ON_GEN_SPECPROG_X]FR_Exempt_Flag

[Gen]Cat=specprog

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OnSIS Submissions

French Program Flag

T or F

[S_ON_GEN_SPECPROG_X]French_Flag

[Gen]Cat=specprog

OnSIS Submissions

Native Language Flag

T or F

[S_ON_GEN_SPECPROG_X]NativeLang_Flag

[Gen]Cat=specprog

OnSIS Submissions

SHSM Program Flag

T or F

[S_ON_GEN_SPECPROG_X]SHSM_Flag

[Gen]Cat=specprog

OnSIS Submissions, OCAS/OUAC Transmissions, OST, Status Sheet

SAL Program Flag

T or F

[S_ON_GEN_SPECPROG_X]SAL_Flag

[Gen]Cat= specprog

OnSIS Submissions, Enrolment Report

Expulsion Program Flag

T or F

[S_ON_GEN_SPECPROG_X]Expulsion_Flag

OnSIS Submissions, Enrolment Fields Report, Enrolment Report

Available For OST/Status Sheet

T or F

[S_ON_GEN_SPECPROG_X]OST_Flag

[Gen]Cat=specprog

OST, Status Sheet

Data Element

Additional Information

[Table]FieldName

Used in these Reports

French Program Type

Choose a program type.

Applies only to programs where the French Program Flag is on.

Refer to the French related values for Second Language Program Type entries in the ministry OnSIS Reference Table Spreadsheet.

[Gen]Value2

[Gen]Cat=specprog

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Native Language Program Type

Choose a native language program type.

Applies only to programs where the Native Language Program Flag is on.

Refer to the Native Language related values (except NL-Native 027) for Second Language Program Type entries in the ministry OnSIS Reference Table Spreadsheet.

[Gen]Value2

[Gen]Cat=specprog

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

SAL Program Type

Choose the SAL program type.

Applies only to programs where the SAL Program Flag is on. Field is hidden otherwise.

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

[S_ON_GEN_SPECPROG_X] SAL_Program_Type

[Gen]Cat=specprog

OnSIS Submissions, Enrolment Report

Data Element

Additional Information

[Table]FieldName

Used in these Reports

SHSM Program Type

Choose a SHSM program type.

Applies only to programs where the SHSM Program Flag is on.

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

[Gen]Value2

[Gen]Cat=specprog

Secondary Report Card, SHSM Record, OCAS/OUAC Transmissions, OnSIS Submissions

Number Of Optional Certificates

Applies only to programs where the SHSM Program Flag is selected.

[Gen]ValueLi

[Gen]Cat=specprog

Secondary Report Card, SHSM Record, Status Sheet

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Certification Type

Select a SHSM certification type.

Refer to SHSM Certification Type in the ministry OnSIS Reference Table Spreadsheet.

[S_ON_GEN_SHSM_Cert_Map_C] Certification_Type

Secondary Report Card, SHSM Record, Status Sheet

Required Flag

T or F

[S_ON_GEN_SHSM_Cert_Map_C] Required_Flag

Secondary Report Card, SHSM Record, Status Sheet

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code set

Select the Code set type.

[CODESET]CODETYPE=EntryCode

Code

Enter the entry code.

See the OnSIS Reference Table Spreadsheet for valid values.

[CODESET]Code

Enrolment Report, OnSIS Submissions, Office Index Cards

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the entry code description.

See the OnSIS Reference Table Spreadsheet for valid values.

[CODESET]Description

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code

Display only field set on Codesets

[Gen]Name

Enrolment Report, OnSIS Submissions, Office Index Cards

Map Code To Ministry Code

Refer to Student Mobility Type (Admission) entries in the ministry OnSIS Reference Table Spreadsheet.

Note that an entry code should only be mapped to the 'IA' ministry code if the student was previously enrolled in the same school with no intervening enrollment at another school.

[Gen]Value2

Enrolment Report, OnSIS Submissions, Office Index Cards

Previous School Value Required

Select this box to indicate on several pages that the Previous School Value field is mandatory when this entry code is used.

[Gen]ValueLI

Sort Order

Display only field set on Codesets

[Gen]SortOrder

Drop-down list on student data entry page.

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code set

Select the Code set type.

[CODESET]CODETYPE=ExitCode

Code

Enter the exit code.

See the OnSIS Reference Table Spreadsheet for valid values.

[CODESET]Code

Enrolment Report, OnSIS Submissions, Student Transfer Report, Office Index Card

Display Value

Enter the code display value.

[CODESET]DisplayValue

Description

Enter the exit code meaning.

See the OnSIS Reference Table Spreadsheet for valid values.

[CODESET]Description

Sort Order

Enter a sort order to determine where the code displays on the page.

[CODESET] UIDisplayOrder

Drop-down list on student data entry page

Start Date

Enter a start date to activate this code.

[CODESET]EffectiveStartDate

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code

Display only field set on Codesets

[Gen]Name

Enrolment Report, OnSIS Submissions, Student Transfer Report, Office Index Card

Meaning

Enter a brief description for the code.

Sort Order

Display only field set on Codesets

[Gen]SortOrder

Drop-down list on student data entry page

Map Code To Ministry Code

Refer to Student Mobility Type (Retirement/Transfer) entries in the ministry OnSIS Reference Table Spreadsheet.

Two additional codes were added to the list of codes provided by the ministry. Those codes are used to indicate whether the student is transferred to a school within the same board or to a school outside of the school board:

• 64: Internal - Transfer prior to secondary school completion - To publicly funded elementary or secondary school at this board

• 64: External - Transfer prior to secondary school completion - To publicly funded elementary or secondary school at another

[Gen]Value2

Enrolment Report, OnSIS Submissions, Student Transfer Report, Office Index Card

Receiving School Value Required

Select this box to indicate on several pages that the Receiving School Value field is mandatory when this entry code is used.

[Gen]ValueLI

Data Element

Additional Information

[Table]FieldName

Used in these Reports

School Name

Maximum of 60 characters.

[Schools]Name

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

Is a Summer School

1 (yes) or 0 (no)

[Schools]issummerschool

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

School Address

[Schools]Address

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Office Index Card

School City

[Schools]SchoolCity

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Office Index Card

School State/Province

[Schools]SchoolState

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Office Index Card

School Postal/Zip Code

[Schools]SchoolZIP

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Office Index Card

School Phone Number

[Schools]SchoolPhone

Elementary Progress Report, Elementary Report Card, Secondary Report Card

School FAX Number

[Schools]SchoolFax

Secondary Report Card

School Number

The school number

[Schools]School_Number

OST, Status Sheet, OnSIS Submissions, New OEN Request, New OEN Import, OEN Validation Import, EQAO Submissions, OCAS/OUAC Transmissions, 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),STIX

Alternate School Number

If entered, used instead of school number.

[Schools]Alternate_School_Number

OST, Status Sheet, OnSIS Submissions, New OEN Request, New OEN Import, OEN Validation Import, EQAO Submissions, OCAS/OUAC Transmissions, 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), STIX

Exclude from State Reporting?

1 (yes) or 0 (no)

[Schools]State_ExcludeFromReporting

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)

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Name

The principal name.

[Schools]Principal

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OST, SHSM Record, Continuing Education Registers

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Council Chair

[S_ON_SCH_X]CouncilChair

Secondary Report Card

Alternate School Name

[S_ON_SCH_X]Alt_School_Name

Enrolment Report, Office Index Card, Potential Ontario Scholar Report, Status Sheet, SHSM Record, OST, Elementary Progress Report, Elementary Report Card, Secondary Report Card, OCAS/OUAC Transmissions

Is a Night (Continuing Education) School

T or F

[S_ON_SCH_X]IsNightSchool

OCAS/OUAC Transmissions, Enrolment Report, High Credit Calculations Report, Continuing Education Registers (Correspondence/Self-Study/Online, Adult Credit)

Is Online school

Select to indicate if the school offers only online courses. This field is not selected by default.

[S_ON_SCH_X]isOnlineSchool

OnSIS Data Validtions

Is an EQAO TIMSS School

T or F

Used to identify ministry selected schools participating in the Trends In International Mathematics And Science Study (TIMSS) assessment.

[S_ON_SCH_X]IsEQAO_TIMSS_School

EQAO Submissions

Is an EQAO PISA School

T or F

Used to identify ministry selected schools participating in the Programme For International Student Assessment (PISA) assessment.

[S_ON_SCH_X]IsEQAO_PISA_School

EQAO Submissions

Is an EQAO PIRLS School

T or F

Used to identify ministry selected schools participating in the Progress In International Reading Literacy Study (PIRLS) assessment.

[S_ON_SCH_X]IsEQAO_PIRLS_School

EQAO Submissions

Is an EQAO PCAP School

T or F

Used to identify ministry selected schools participating in the Pan Canadian Assessment Program (PCAP) assessment.

[S_ON_SCH_X]IsEQAO_PCAP_School

EQAO Submissions

School Is Closed

1 (closed) or 0 (not closed)

[S_ON_SCH_X]IsClosed_TF

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), STIX.

Average Partial Enrollment Minutes Weekly

1 (yes) or 0 (no)

[S_ON_SCH_X]Avg_Minutes_Weekly_Flag

Enrolment Report (including legacy), Enrolment Fields Report, OnSIS Submissions, Day School Independent Study Register (including legacy).

Learning Preference

Select the School Learning preference. This value will be used for all students unless it is overwritten on the course/section/class enrolment level

Valid Values:

• (01) FT In-person learning

• (02) FT remote learning

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

EQAO Grade 9 Math Extract

Exclude Elementary Achievements From OnSIS Submissions

(Appears only for Elementary Schools)

T or F (Default- F)

Controls whether to include/exclude the student elementary achievements from the OnSIS submission for this the school

This option is for schools that are not reporting students' achievements through PowerSchool.

[Prefs]Name=ON_ExcludeElemRC

[Prefs]Value

ONSIS Elementary School Submission

Model used for first half of school year

Select the model used by the school in the current school year. If the school is using the semester model for the whole year, this field is not required. The field is required for all other schools.

Valid values: Blank, Semester (S), Quadmester (Q), Octomester (O), Quad/Octomester (B)

Quad/Octomester (B) should be used by schools that have students enrolled/Cross enrolled in full credit courses that are scheduled in Quadmester and others in Octomester. (This is not included in Civics and Careers 0.5 credit courses)

Values of this field are stored by year based on the term selected and stored in [S_ON_SCH_SchoolModel_C]Model_FirstHalf

Enrolment Fields report, Enrolment Report, OnSIS Secondary.

Model used for second half of school year

Select the model used by the school in the current school year. If the school is using the semester model for the whole year, this field is not required. The field is required for all other schools.

Valid values: Blank, Semester (S), Quadmester (Q), Octomester (O), Quad/Octomester (B)

Quad/Octomester (B) should be used by schools that have students enrolled/Cross enrolled in full credit courses that are scheduled in Quadmester and others in Octomester. (This is not included Civics and Careers 0.5 credit courses)

Values of this field are stored by year based on the term selected and stored in [S_ON_SCH_SchoolModel_C]Model_SecondHalf

Enrolment Fields report, Enrolment Report, OnSIS Secondary.

School uses Flip Weeks

Select this flag if school is using Quad/Octomester model and uses flip weeks in the current school year.

Values of this field are stored by year based on the term selected and stored in[S_ON_SCH_SchoolModel_C]UsesFlipWeeks

Enrolment Fields report, Enrolment Report, OnSIS Secondary.

Secondary Report Card Learning Skills Data Source

(Secondary schools only)

Choose a skills data source.

Valid values:

• Disabled (D)

• Gradebook (G)

• Standard Grades (S)

[S_ON_SCH_X]SRC_Data_Source

Secondary Report Card

Progress Report Attendance End Date

(Elementary schools only)

Enter the progress report end date to Indicate which attendance dates are used to define days absent and times late. This must be updated each year.

[S_ON_SCH_X]PR_End_Date

Elementary Progress Report, Elementary Report Card

First Report Card Attendance End Date

(Elementary schools only)

Enter the first report card end date to Indicate which attendance dates are used to define days absent and times late. This must be updated each year.

[S_ON_SCH_X]R1_End_Date

Elementary Progress Report, Elementary Report Card

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Surname

Enter the legal last name of the contact person sending the transmission.

[S_ON_SCH_X]OCAS_Contact_Surname

OCAS/OUAC Transmissions

First Name

Enter the legal first name of the contact person sending the transmission.

[S_ON_SCH_X]OCAS_Contact_FirstName

OCAS/OUAC Transmissions

Phone Number

Enter the telephone number where the contact person sending the transmission can be reached, or a message can be left.

Only digits are allowed.

Valid formats are:

• nnnnnnnnnn

• (nnn) nnn-nnnn, nnn-nnn-nnnn,

• +1-nnn-nnn-nnnn, +1nnnnnnnnnn

[S_ON_SCH_X]OCAS_Contact_Phone

OCAS/OUAC Transmissions

Phone Extension

Enter the telephone extension number where the contact person sending the transmission can be reached, or a message can be left.

[S_ON_SCH_X]OCAS_Contact_Extension

OCAS/OUAC Transmissions

Contact Email Address

The email address of the contact person sending the transmission.

[S_ON_SCH_X]OCAS_Email

OCAS/OUAC Transmissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

OCAS October Date

[S_ON_SCH_X]OCAS_Oct

OCAS/OUAC Transmissions

OCAS November Date

[S_ON_SCH_X]OCAS_Nov

OCAS/OUAC Transmissions

OCAS February Date

[S_ON_SCH_X]OCAS_Feb

OCAS/OUAC Transmissions

OCAS April Date

[S_ON_SCH_X]OCAS_Apr

OCAS/OUAC Transmissions

OCAS July Date

[S_ON_SCH_X]OCAS_Jul

OCAS/OUAC Transmissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

OUAC Transmission 1 Date

[S_ON_SCH_X]OUAC_TRN_1

OCAS/OUAC Transmissions

OUAC Re-Transmission 1 Date

This date must be greater than the OUAC Transmission 1 Date

[S_ON_SCH_X]OUAC_TRN_1R

OCAS/OUAC Transmissions

OUAC Transmission 2 Date

[S_ON_SCH_X]OUAC_TRN_2

OCAS/OUAC Transmissions

OUAC Transmission 3 Date

[S_ON_SCH_X]OUAC_TRN_3

OCAS/OUAC Transmissions

OUAC Transmission 4 Date

[S_ON_SCH_X]OUAC_TRN_4

OCAS/OUAC Transmissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

OCAS First Transmission Flag

Before running the first OCAS transmission for the current school year, select this checkbox.

When this checkbox is selected, the OCAS Transmissions report clears the previous year's transmission dates in the [S_ON_SCH_X] table:

OCAS_OCT

OCAS_NOV

OCAS_FEB

OCAS_APR

OCAS_JUL

After the first transmission has been successfully submitted (i.e. it is no longer necessary to run the first transmission), uncheck the checkbox so that the report does not clear the transmission dates for subsequent transmissions.

[S_ON_SCH_X]OCAS_FirstTransmission

OCAS/OUAC Transmissions

OUAC First Transmission Flag

Before running the first OUAC transmission for the current school year, select this checkbox.

When this checkbox is selected, the OUAC Transmissions report clears the previous year's transmission dates in the [S_ON_SCH_X] table:

OUAC_TRN_1

OUAC_TRN_1R

OUAC_TRN_2

OUAC_TRN_3

OUAC_TRN_4

After the first transmission has been successfully submitted (i.e. it is no longer necessary to run the first transmission), uncheck the checkbox so that the report does not clear the transmission dates for subsequent transmissions.

[S_ON_SCH_X]OUAC_FirstTransmission

OCAS/OUAC Transmissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Grade Level

Enter a number corresponding to the grade level.

[S_ON_SCH_Lang_Inst_Minutes_C]Grade_Level

OnSIS Submissions, Student Record of Accumulated Instruction in French As a Second Language

Language Program Type

Choose a language program type.

• FSF - Core French

• FEF - Extended French

• FIF - Immersion French

  • Note: When Immersion French is selected, five optional fields are displayed. See below for details.

• NLA - Native Language

[S_ON_SCH_Lang_Inst_Minutes_C] Program_Type

OnSIS Submissions, Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day Of Instruction

If the student's Language Program Type is Core French, Extended French, Immersion French or Native Language, enter the minutes per day of instruction here.

If the student's Language Program Type is Immersion French and there is more than one subject, see Options for Subjects Taught in French, below.

[S_ON_SCH_Lang_Inst_Minutes_C] Minutes_Of_Instruction

OnSIS Submissions, Student Record of Accumulated Instruction in French As a Second Language

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Minutes Per Day of Instruction - 2 subjects

If the student is taught two subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction2

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 3 subjects

If the student is taught three subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction3

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 4 subjects

If the student is taught four subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction4

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 5 subjects

If the student is taught five subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction5

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 6 subjects

If the student is taught six subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction6

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 7 subjects

If the student is taught seven subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction7

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 8 subjects

If the student is taught eight subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction8

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 9 subjects

If the student is taught nine subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction9

Student Record of Accumulated Instruction in French As a Second Language

Minutes Per Day of Instruction - 10 subjects

If the student is taught ten subjects in French, enter the minutes per day of instruction.

[S_ON_SCH_Lang_Inst_Minutes_C]Minutes_Of_Instruction10

Student Record of Accumulated Instruction in French As a Second Language

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Literacy Numeracy Type

Choose a type.

• L - Literacy

• N - Numeracy

[ON_Literacy_Numeracy]user_defined_text (alias Type)

OnSIS Submissions

Grade Level

Enter a number corresponding to the grade level.

[ON_Literacy_Numeracy]user_defined_integer (alias Grade_Level)

OnSIS Submissions

Number Of Blocks Per Week

[ON_Literacy_Numeracy]user_defined_numeric (alias Blocks_Per_Week)

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

AM Tardy Check Period

Enter the number (not code) of the period to be checked to determine whether a student is considered AM tardy. If undefined a student is deemed AM tardy if a tardy attendance code is found in any AM period.

[S_ON_SCH_X]AM_Tardy_Period

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

PM Tardy Check Period

Enter the number (not code) of the period to be checked to determine whether a student is to be considered PM tardy. If undefined a student is deemed PM tardy if a tardy attendance code is found in any PM period.

[S_ON_SCH_X]PM_Tardy_Period

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

Data Element

Additional Information

[Table]FieldName

Used in these Reports

ECPP School Flag

T or F

Indicates whether a school is a ECPP facility.

[S_ON_SCH_X]Section23_Flag

EQAO Submissions

OnSIS ECPP School Submission

Program Type

This field is only visible for ECPP facilities.

The program type offered by the ECPP facility.

Valid Values:

• Blank

• Residential (1)

• Day Treatment (2)

• Both (3)

Note: if this field is set to Residential (1) or Both (3), PowerSchool calculates the number of days the student resided in the facility; otherwise, Null is submitted to OnSIS.

[S_ON_SCH_X]Care_Trmt_Pgm_Type

OnSIS ECPP School Submission

Designated School

Select a school from the list of opened public schools. This field is mandatory for ECPP facilities.

This list is based on the highest grade of the ECPP facilities and listed by [school number(BSID)]. Secondary public schools are displayed when the highest grade is 12 and Elementary public schools when the highest grade is 8.

Notes:

• For a school to appear in this list, ECPP School Flag and School is Closed must not be selected for the school.

• To allow this value to be overwritten if required for some students, this field is also available at the student level, on the Student General Info tab.

[S_ON_SCH_X]Designated_SchoolsDCID

OnSIS ECPP School Submission

Designated School (Elem)

Select a school from the list of opened public schools.

This field is only visible to ECPP schools with both elementary and secondary grade levels. The field is used to specify the elementary designated school. Use Designated School to specify the Secondary Designated school.

[S_ON_SCH_X]Desig_SchoolsDCIDElem

Submission

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Log Type

Set up entry for "OSR Request".

[Gen]Cat=logtype

[Gen]Name

Office Index Card

Log Code

Set up entries for:

• RCVD - Received

• RQST - Requested

• SENT - Sent

[Gen]Cat=subtype

[Gen]Name

Office Index Card

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Name

Click New to set up tests. Add one for English and another for French as follows:

• OSSLT-E

• OSSLT-F

OSSLT results are imported into one of these tests.

[Test]Name

Secondary Report Card, OST, Status Sheet, OnSIS Submissions, EQAO Submissions, OCAS/OUAC Submissions

Score Name

Click New to set up a score name of "Outcome".

OSSLT results will be imported into this score in the Alpha Box.

[TestScore]Name

Secondary Report Card, OST, Status Sheet, OnSIS Submissions, EQAO Submissions, OCAS/OUAC Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Codes And Subcodes

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

These should be loaded using the Load Codes/Subcodes link on the Edit District Info page.

The loaded configuration is described in Appendix B.

OnSIS Submissions

Name

Add incident type "OnSIS Discipline"

[Incident_LU_Code]Code_Type=incidenttypecode

[Incident_LU_Sub_Code]Incident_Category

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

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

Create a graduation contract for each type of the following diplomas and certificates associated with students in the board:

OSSD - Ontario Secondary School Diploma, 1999 and later

OSSD2 - Ontario Secondary School Diploma, before 1999

SSGD - Secondary School Graduation Diploma

SSHGD - Secondary School Honours Graduation Diploma

OSSC - Ontario Secondary School Certificate

The configuration specific to each type of graduation contract is described in Appendix C.

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

Secondary Report Card, OST, SHSM Record, Status Sheet, OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Standards

All Ontario Provincial standards must be set up for the district.

There are three sets of standards to be imported.

Elementary 1-6

Elementary 7-8

Secondary 9-12

Refer to Appendix E for more information on how to import the standards from an Excel spreadsheet.

[Standards]Identifier

[Standards]ID

[Standards]Courses

Elementary Progress Report, Elementary Report Card, Secondary Report Card, OnSIS Submissions, Continuing Education Registers (Correspondence/Self-Study/Online)

Conversion Scales

There are eleven standards conversion scales that must be set up.

• Null

• Yes/No (blank)

• Learning Skills and Work Habits

• Grades 1-6 Final Marks

• Grades 7-8 Final Marks

• Progress Report Grades

• ESL/ELP/IEP Status

• ESL/ELD, IEP, BOTH and NA

• NA

• 20 Point Scale

• 30 Point Scale

Refer to Appendix E for more information on how to setup each conversion scale.

N/A

Elementary Progress Report, Elementary Report Card, Secondary Report Card, Independent Study and e-Learning Register for Day School Pupils, Continuing Education Registers, Continuing Education Registers (Correspondence/Self-Study/Online)

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Order

Set the order of the values as they should appear when in the student Gender drop-down list.

[CodeSet]UIDisplayOrder

OnSIS Submissions

Code

Select the student's gender.

Valid values are:

• F (Female)

• M (Male)

• N (Prefer Not to Disclose)

You can set up one or all of the following:

• S (Prefer to Specify): If you set up this value, a gender description must be entered when this option is selected.

  • Note: Do not define this code if you want to have control over the gender descriptions reported to OnSIS. Instead, set up O (Other), as described below.

• O (Other): If you set up this value, a description must be selected from a predefined list of descriptions. For information about creating the gender description drop-down list, refer to "Creating Gender Description Code Sets" below.

• Any other one character code can be set up (for example, 1 (TransBoy), 2 (Transgirl),3....A,B,C...and so on). When this is the case, users do not have the option to enter or select a description; instead, the Description Value (see below) is used for reporting. Choose this option if you want new genders to be listed in the gender drop-down list.

[CodeSet]Code

OnSIS Submissions

Display Value

Choose the gender value to be displayed.

[CodeSet]DisplayValue

OnSIS Submissions

Description

This is the long description of the Gender.

This value is reported to OnSIS when the code is not F, M, N,  or O and the reported value is S. Must not exceed 50 characters; otherwise, truncated.

• Valid Characters:

  • a-zA-ZÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌìÔôÖöÓóÜüÙùÛûÚúÇçÿŸÑñò _:.0-9'~-

  • Accents are accepted

  • Numbers are allowed

[CodeSet]Description

OnSIS Submissions

Reported Value

Define a Reported Value if the value to be reported is different than the code.

Optional for gender codes F, M, N and S, mandatory for all other codes.

[CodeSet]ReportedValue

OnSIS Submissions

Excluded

Use to exclude this gender code from being reported. When selected, the gender type and any corresponding description are not sent to OnSIS.

[CodeSet]ExcludeFromStateReporting

OnSIS Submissions

Start Date

If you want the defined gender to only be used starting on a specific date, set this date to a future date.

If the code should be immediately available for selection, leave this date blank.

[CodeSet]EffectiveStartDate

OnSIS Submissions

End date

Set this to the date after which this code should no longer be used; the gender code will not be available for selection after this date.

Expired gender codes that are already assigned to students are still reported to OnSIS.

[CodeSet]EffectiveEndDate

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Order

Use to set the order of the gender description values as they should appear in the gender description drop-down list for the Gender option O (Other).

[CodeSet]UIDisplayOrder

OnSIS Submissions

Code

The Gender Description code; for example, S1, S2, S3.

[CodeSet]Code

OnSIS Submissions

Display Value

Use for the Gender Short Description. This value is used on the gender description dropdown list for the Gender option O (Other).

[CodeSet]DisplayValue

OnSIS Submissions

Description

Use for the Gender Long Description. This is the value to be reported to OnSIS when Gender option "O" is selected for the student.

The description must not exceed 50 characters or it will be   truncated.

• Valid Characters:

  • a-zA-ZÀàÄäÂâÁáÈèÉéÊêËëÎîÏïÌìÔôÖöÓóÜüÙùÛûÚúÇçÿŸÑñò _:.0-9'~-

  • Accents are to be accepted

  • Numbers are allowed

[CodeSet]Description

OnSIS Submissions

Excluded

Select if you want to exclude this gender description from OnSIS reporting

[CodeSet]ExcludeFromStateReporting

OnSIS Submissions

Start Date

If you want the description to only be used starting on a specific date, set this date to a future date.

If the description should be immediately available for selection, leave this date blank.

[CodeSet]EffectiveStartDate

OnSIS Submissions

End Date

Set this to the date after which this description should no longer be used; the gender description will not be available for selection after this date.

Expired gender descriptions that are already assigned to students are still reported to OnSIS.

[CodeSet]EffectiveEndDate

OnSIS Submissions

Parent Code

Set to O.

[CodeSet]ReportedValue

OnSIS Submissions

Parent Code Set

Select Gender

[CodeSet]ParentCodeSetID

OnSIS Submissions

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Code Value

Enter the code as you want it to appear in the student Learning Preferences drop-down list. This field is required.

Valid EQAO values are:

01 (for Full-time in-person learning),

02 (for Full-time remote learning)

03 (for Combination of in-person and remote learning).

EQAO

Description

Enter a description of the code as you want it to appear in the student Learning Preferences drop-down list.

EQAO

Sort Order

Enter a number to determine the order in which you want the code to appear in the student Learning Preferences drop-down list relative to other codes. The lower the sort order number, the higher the item appears on the menu.

Effective Start Date

Enter the date the code becomes valid. This field is optional.

Effective End date

Enter the date the code is no longer valid. This field is optional.

Alternate Report Code

Enter a code that can be used to send to EQAO as an alternative to Code Value. This field is optional.

If you already have codes that is different than what is valid for EQAO. Use this field to map your codes to the EQAO codes

Valid EQAO values:

01 (for Full-time in-person learning),

02 (for Full-time remote learning)

03 (for Combination of in-person and remote learning).

Set As default

Select this option to set this Code Value as the default within the code set.

Data Element

Additional Information

[Table]FieldName

Used in these Reports

Order

Set the order of the values as they should appear when in the student language drop-down list.

[CodeSet]UIDisplayOrder

Code

The language code value is stored here. Required.

[CodeSet]Code

Display Value

The language value to be displayed.

[CodeSet]DisplayValue

Description

The long description of the language.

[CodeSet]Description

Reported Value

Refers to the value used by Provincial Reporting, if populated, as an alternative to the Code value. Currently, this code set is not used by the Provincial Reporting.

[CodeSet]ReportedValue

Excluded

Use to exclude this Language code from being reported. When selected, the Language type and any corresponding description are not sent to OnSIS.

[CodeSet]ExcludeFromStateReporting

Start Date

If you want the defined language to only be used starting on a specific date, set this date to a future date.

If the code should be immediately available for selection, leave this date blank.

[CodeSet]EffectiveStartDate

End date

Set this to the date after which this code should no longer be used; the language code will not be available for selection after this date.

[CodeSet]EffectiveEndDate

Parent Code

Displays Parent Code value for the selected Parent Code

Parent code Set

Reference to the Parent Code Set ID. Indexed. Null indicates this is a CodeSet Category.

Refer to the Code Sets page to manage codeset.