Skip to main content
Skip table of contents

S_ON_SCH_X ver 21.1.0

This table is an extension of the [Schools] table.

Column Name

Version      

Data Type

Description

SchoolsDCID

14.10.0

Number(10,0)

Primary key that relates the extended table to the Schools table

IsEQAO_TIMSS_School

14.10.0

Varchar2(1)

Flag for schools doing assessments for TIMMS (Trends in International Mathematics and Science Study)

IsEQAO_PIRLS_School

14.11.1

Varchar2(1)

Flag for schools doing assessments for PIRLS (Progress in International Reading Literacy Study)

IsEQAO_PIRA_School

14.11.1

Varchar2(1)

Flag for schools doing assessments for PISA (Programme for International Student Assessment)

SRC_Data_Source

14.12.0

Varchar2(1)

Secondary Report Card Learning Skills Data Source containing the value 'D' (disabled), 'G' (gradebook), or 'S' (standard grades)

Alt_School_Name

15.8.2

Varchar2(60)

Alternate School Name

 Avg_Minutes_Weekly_Flag

15.10.0

Number(1,0)

Flag indicating whether minutes for partial enrollment should be averaged on a weekly basis

IsEQAO_PCAP_School

16.1.0

Number(1,0)

Flag for schools doing assessments for PCAP (Pan Canadian Assessment Program)

Designated_SchoolsDCID

16.6.0

Integer

Foreign key reference to the Schools table.  The referenced school must not be one for which [Schools]ON_Section23_Flag is true  The BSID for the referenced school is reported to OnSIS as the designated school number.  Only used if the value of [S_ON_STU_X]Designated_SchoolsDCID is undefined for a CTCC student.

OCAS_FirstTransmission

16.8.0

Number(1,0)

Flag indicating if it is first OCAS transmission

OUAC_FirstTransmission

16.8.0

Number(1,0)

Flag indicating if it is first OUAC transmission

IsNightSchool  17.1.0Number(1,0)Is a Night (Continuing Education) School (Migrates from [Schools]ON_IsNightSchool
Section23_Flag17.1.0Number(1,0)

Section 23 School Flag (Migrates from [Schools]ON_Section23_Flag)

OCAS_Apr17.1.0Date OCAS April Date (Migrates from [Schools]ON_OCAS_Apr)
OCAS_Feb17.1.0Date OCAS February Date (Migrates from [Schools]ON_OCAS_Feb)
OCAS_Jul17.1.0Date OCAS July Date (Migrates from [Schools]ON_OCAS_Jul)
OCAS_Nov17.1.0Date OCAS November Date (Migrates from [Schools]ON_OCAS_Nov)
OCAS_Oct17.1.0Date OCAS October Date (Migrates from [Schools]ON_OCAS_Oct)
OUAC_TRN_117.1.0Date OUAC Transmission 1 Date (Migrates from [Schools]ON_OUAC_TRN_1)
OUAC_TRN_1R20.10.2Date OUAC Re-Transmission 1 Date
OUAC_TRN_217.1.0Date OUAC Transmission 2 Date (Migrates from [Schools]ON_OUAC_TRN_2)
OUAC_TRN_317.1.0Date OUAC Transmission 3 Date (Migrates from [Schools]ON_OUAC_TRN_3)
OUAC_TRN_417.1.0Date OUAC Transmission 4 Date (Migrates from [Schools]ON_OUAC_TRN_4)
OUAC_TRN_517.1.0Date OUAC Transmission 5 Date (Migrates from [Schools]ON_OUAC_TRN_5)
PR_End_Date17.1.0Date

Progress Report Attendance End Date (Migrates from [Schools]ON_PR_End_Date)

R1_End_Date17.1.0Date

First Report Card Attendance End Date (Migrates from [Schools]ON_R1_End_Date)

AM_Tardy_Period17.1.0VarChar2(3)AM Tardy Check Period (Migrates from [Schools]ON_AM_Tardy_Period)
CouncilChair17.1.0VarChar2(100) Council Chair (Migrates from [Schools]ON_CouncilChair)
OCAS_Contact_Extension17.1.0VarChar2(10)Contact Phone Extension (Migrates from [Schools]ON_OCAS_Contact_Extension)
OCAS_Contact_Firstname17.1.0VarChar2(50)Contact First Name (Migrates from [Schools]ON_OCAS_Contact_Firstname)
OCAS_Contact_Phone17.1.0VarChar2(30)Contact Phone Number (Migrates from [Schools]ON_OCAS_Contact_Phone)
OCAS_Contact_Surname17.1.0VarChar2(50)Contact Surname (Migrates from [Schools]ON_OCAS_Contact_Surname)
OCAS_Email17.1.0VarChar2(50)Contact Email Address (Migrates from [Schools]ON_OCAS_Contact_Email)
PM_Tardy_Period17.1.0VarChar2(3)PM Tardy Check Period (Migrates from [Schools]ON_ON_PM_Tardy_Period)
IsClosed_TF17.5.0Number(1,0)Migrated from: [Schools]ON_IsClosed
Care_Trmt_Pgm_Type20.5.2VarChar2(1)Care Treatment Program Type
Model_FirstHalf21.2.1VarChar2(3)

Model used for first half of school year

Model_SecondHalf21.2.1VarChar2(3)

Model used for second half of school year

UsesFlipWeeks21.3.2Number(1,0)Flag indicating if this school uses flip weeks
Desig_SchoolsDCIDElem21.6.2.0IntegerField is used to record Designated School for Elementary in Case of K-12 Schools.
ON_ExcludeElemRC21.12.1.0Number(1,0)Field is used to record  Exclude Elementary Achievements From OnSIS Submissions



JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.