Derived Fields
Continuing Education - Summer School Register
Continuing Education - Register of Enrolment in Correspondence/Self-Study/Online Courses
Continuing Education - Register of Enrolment in Correspondence/Self-Study/e-learning Courses (Legacy)
Continuing Education - Register of Enrolment in Continuing Education Credit Courses
Continuing Education - Register of Enrolment in the Literacy and Numeracy Program
Continuing Education - Register of Enrolment in Adult Indigenous Language Instruction
Continuing Education - Register of Enrolment in the International and Indigenous Languages Elementary (IILE) Program
Continuing Education - Report Summary Page

OnSIS Reports

OnSIS Pending Area Extract Import
Ontario Data Status: Viewing Summaries Of OnSIS Related Data
OnSIS Create Class Codes
Run OnSIS Demographic Snapshot
OnSIS Student ADE Report

International & Indigenous Languages Elementary (IILE) Summary Report

International & Indigenous Languages Elementary (IILE) Details Report

OnSIS Elementary School Submission Report
OnSIS Secondary School Submission Report
OnSIS Night School Submission Report
OnSIS Summer School Submission Report
OnSIS ECPP Submission Report
OnSIS June Suspension/Expulsion Submission Report

Data Validation

Enabling and Disabling Validation Rules
Data Validation Error Message and Rule Definitions

OnSIS Verification Reports

OnSIS Verification Summary - Section A
OnSIS Verification Detail - Section A
OnSIS Verification Summary - Section B
OnSIS Verification Detail - Section B
OnSIS Verification Summary - Section C1
OnSIS Verification Details - Section C1
OnSIS Verification Summary - Section D
OnSIS Verification Detail - Section D
OnSIS Verification Summary - Section F
OnSIS Verification Details - Section F
OnSIS Verification Summary - Section G1
OnSIS Verification Detail - Section G1
OnSIS Verification Summary- Section G2
OnSIS Verification Detail - Section G2
OnSIS Verification Summary - Section J
OnSIS Verification Detail - Section J
OnSIS Verification Summary - Section N
OnSIS Verification Detail - Section N
OnSIS Verification Summary - Section T
OnSIS Verification Detail - Section T
OnSIS Verification Summary- Section U
OnSIS Verification Detail - Section U
OnSIS Verification Summary - Section E
OnSIS Verification Details - Section E

OnSIS October Board Report

Provincial Reports

Kindergarten Communication of Learning: Initial Observations
Elementary Progress Report (1-6) - Gradebook
Elementary Progress Report (7-8)
Kindergarten Communication of Learning Report Card
Elementary Report Card (1-6)
Elementary Report Card (7-8)
Ontario Student Transcript Report
EQAO Extracts
OCAS Transmission
OUAC Transmission
OCAS - Electronic Transcript
Community Involvement Certificate Eligibility Report
Enrolment Reports
Enrolment Report (Secondary Quad/Octomesters Setup)
Enrolment Fields Report
Enrolment Register and FTE Snapshot
Student Public Health Unit (STIX) Data Extract
Student Status Sheet Report
New OEN Request
New OEN Import
OEN Validation Request
OEN Validation Import
Ontario Secondary School Literacy Test (OSSLT) Outcomes Import
Secondary Report Cards - GradeBooks
Student Test Score Import
Student Diploma Deficiency Report
Independent Study and Online Learning Register for Day School Pupils
Independent Study and e-Learning Register for Day School Pupils (Legacy)
Office Index Card
OSSD Diploma Date Calculations
SHSM/OYAP-FAST All Requirements Met Date Calculations
Graduation Cohort (Diploma Completion) Report

Import Results

New OEN Import Results
OEN Validation Import Results
OSSLT Outcomes Import Results
OUAC Reference File Import Results
Student Test Score Import Results

Potential Ontario Scholars Report
Specialist High Skills Major (SHSM) Record
Yearly Attendance Card Report
OUAC Reference File Import
Notification of Student Transfer Report
SHSM Student Data Report
Day/Class Consecutive Absence Report
Completed Lessons/Work Units Report
Student Record of Accumulated Instruction in French As a Second Language

Legacy Reports

Enrolment Report (Legacy)
Secondary Report Cards - GradeBook Midterm
Elementary Progress Report (1 - 6)

Provincial Reporting Setup

Understanding the Setup Table

Staff Setup

Co-Teaching Roles
Educator Assignments By School
PowerTeacher
Staff - School Affiliations

Student Setup

General Information
Literacy/Numeracy Parents
OnSIS Snapshot
French Card
Community Hours
SHSM Certifications
Independent Study Work Units
Completed Work Units/Lessons

District Setup

Load Reporting Images
Ontario - Discipline Codes and Subcodes Load Information
Define Day 16 Dates

School Setup

OnSIS API Reporting Setup

OnSIS Batch File Submissions

Ontario-Specific Legacy Custom Field Migration to Database Extensions

Field Set: State ON Students Fields Version 1
Field Set: State ON ReEnrollments Fields Version 1
Field Set: State ON SpEnrollments Fields Version 1
Field Set: State ON Gen SPECPROG Fields Version 1
Field Set: State ON Courses Fields Version 1
Field Set: State ON Sections Fields Version 1
Field Set: State ON CC Fields Version 1
Field Set: State ON Schools Fields Version 1
Field Set: State ON Storedgrades Fields Version 1

Ontario-Specific Virtual Table Migrations

Field Set: State ON Virtual ON_Community_Hours
Field Set: State ON Virtual ON_Educator_Assign
Field Set: State ON Virtual ON_Lang_Inst_Minutes
Field Set: State ON Virtual ON_SAL_Component
Field Set: State ON Virtual ON_SHSM_Cert
Field Set: State ON Virtual ON_SHSM_Cert_Map

Appendices

Appendix A - Codes and Specifications

OnSIS Codes
OnSIS Dual Credit Course Spreadsheet
EQAO File Specification
OCAS and OUAC File Specification

Appendix B - Incident Management Configuration

Incident Management Code Setup
OnSIS Segment Generation

Appendix C - Graduation Planner Configuration

Implementation
Graduaton Planner Configuration (OSSD 2024 onwards)

Appendix D - Graduation Set Configuration

Credit Requirements
Certification Requirements

Appendix E - Standards Configuration

Ontario Standards Import
Create New Conversion Scale
Identify the Conversion Scale IDs
Prepare the Templates for Import
Import the Standards Using Quick Import

Appendix F - Literacy Requirement
Appendix G - Differences Between PowerSchool Graduation Planner Progress And Provincial Reporting Graduation Planner Progress

Appendix H - SHSM Progress

Best Fit Logic
Progress Page

Appendix I - Common Functions And Views

_ON_LNPG_CONTACTS_
Get Contacts
Get Contact Phones
Get Graduation School Name
Get Graduation School Number
Get Section Num Classes
Get Student Gender Report Values
Get Student Online Learning Requirement

Appendix J - Assigning Credit To Diploma Categories

Diploma Categories
Explicit Category Assignment
Category Assignment Processing

Appendix K - EYE Licensed Child Care Facilities Import
Appendix L - Course Repeats Logic
Appendix M - Schools using Quad/Octomesters Models - 2020-2021 FTE Modifications

Appendix O - How to ....

OnSIS Reporting Process and Best Practices
SHSM Programs

Appendix P - Ontario Schools Reference File Import Instructions
Appendix N - OCAS Automated Electronic Transcript Webservice - Setup
Pending Area Extract (PAE) Tables

Virtual Tables

Ontario Class Assignments: ON_Assign_Class
Ontario Community Hours: ON_Community_Hours
Ontario Educator Assignment: ON_Educator_Assign
Ontario Educator Roles: ON_Educator_Role
Ontario Instructional Time Type: ON_Instructional_TM
Ontario Language Program Instructional Minutes ON_Lang_Inst_Minutes
Ontario Literacy and Numeracy Program Blocks: ON_Literacy_Numeracy
Ontario SAL Component: ON_SAL_Component
Ontario SHSM Certification: ON_SHSM_Cert
Ontario SHSM Certification Mapping: ON_SHSM_Cert_Map
Ontario Temporary Letter Of Authourization: ON_TLA

Breadcrumbs

Home
Ontario Compliance Help
Appendices
Appendix A - Codes and Specifications

OnSIS Dual Credit Course Spreadsheet

Institution Code

Privacy Statement

Powered by Scroll Sites & Atlassian Confluence