Skip to main content
Skip table of contents

S_ON_SGR_X ver 15.2.0

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

Column Name


Data Type





Primary key that relates the extended table to the StoredGrades table




Flag indicating whether the record is excluded from OCAS/OUAC reporting
Diploma_Category15.5.0Varchar2(2)Diploma category override (contains a diploma category number from 01 to 17, or 99 for optional)
Transcript_A17.1.0Number(1,0)Alternative Expectations Note Flag (Migrates from [StoredGrades]ON_Transcript_A)
Transcript_B17.1.0Number(1,0)Transcript Credit Adjustment Flag  (OCAS/OUAC Only) (Migrates from [StoredGrades]ON_Transcript_B)
Transcript_C17.1.0Number(1,0)Co-op Note Flag (Migrates from [StoredGrades]ON_Transcript_C)
Transcript_F17.1.0Number(1,0)French Note Flag (Migrates from [StoredGrades]ON_Transcript_F)
Transcript_H17.1.0Number(1,0)SHSM Note Flag (Migrates from [StoredGrades]ON_Transcript_H)
Transcript_I17.1.0Number(1,0)Interdisciplinary Studies Note Flag (Migrates from [StoredGrades]ON_Transcript_I)
Transcript_M17.1.0Number(1,0)Modified Curriculum Note Flag (Migrates from [StoredGrades]ON_Transcript_M)
Transcript_P17.1.0Number(1,0)Private School Credit Note Flag (Migrates from [StoredGrades]ON_Transcript_P)
Transcript_S17.1.0Number(1,0)Special Circumstances Note Flag (Migrates from [StoredGrades]ON_Transcript_S)
Transcript_T17.1.0Number(1,0)Team Taught Dual Credit Note Flag (Migrates from [StoredGrades]ON_Transcript_T)
Transcript_W17.1.0Number(1,0)Disclosure Mark Flag (Migrates from [StoredGrades]ON_Transcript_W)
Credit_Date17.1.0DateDate Completed (Migrates from [StoredGrades]ON_Credit_Date)
PLAR_Compulsory17.1.0Number(25,10)PLAR Compulsory (Migrates from [StoredGrades]ON_PLAR_Compulsory
PLAR_Type17.1.0VarChar2(1)PLAR Type (Migrates from [StoredGrades]ON_PLAR_Type)
PLAR_Status17.1.0VarChar2(2)PLAR Status Type (Migrates from [StoredGrades]ON_PLAR_Status)
Credit_Type17.1.0VarChar2(3)OnSIS Credit Type (Migrates from [StoredGrades]ON_Credit_Type)
Delivery_Type17.1.0VarChar2(3)Delivery Type (Migrates from [StoredGrades]ON_Delivery_Type)
School_Number17.1.0VarChar2(6)School Number (Migrates from [StoredGrades]ON_School_Number - This should be populated with the School BSID the Course is completed At (Do not populate with the school number)
OthCrsInfo_Cred_Recovery19.9.2.0VarChar2(10)Indicates whether the course is Credit Recovery, Set to 1 when Credit Recovery otherwise NULL.
OthCrsInfo_Ministry_Content19.9.2.0VarChar2(10)Indicates whether course is Ministry Developed Content. Set to 2 = Ministry Developed Content otherwise NULL
OthCrsInfo_UpgradCrdtCourse20.7.2.0VarChar2(10)Indicates whether course is Upgrading Credit Course. Set to 3 = Upgrading Credit Course otherwise NULL
CALCREPEATSONCRSNUM20.11.2.0Number(1,0)Calculate repeats on Course Number Flag
OthCrsInfo_Online whether course is Online. Set to 4 = Online otherwise NULL

JavaScript errors detected

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

If this problem persists, please contact our support.