S_ON_SGR_X ver 15.2.0
This table is an extension of the [StoredGrades] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StoredGradesDCID | 15.2.0 | Number(10,0) | Primary key that relates the extended table to the StoredGrades table |
ExcludeFrom_OCAS_OUAC | 15.2.0 | Varchar2(1) | Flag indicating whether the record is excluded from OCAS/OUAC reporting |
| Diploma_Category | 15.5.0 | Varchar2(2) | Diploma category override (contains a diploma category number from 01 to 17, or 99 for optional) |
| Transcript_A | 17.1.0 | Number(1,0) | Alternative Expectations Note Flag (Migrates from [StoredGrades]ON_Transcript_A) |
| Transcript_B | 17.1.0 | Number(1,0) | Transcript Credit Adjustment Flag (OCAS/OUAC Only) (Migrates from [StoredGrades]ON_Transcript_B) |
| Transcript_C | 17.1.0 | Number(1,0) | Co-op Note Flag (Migrates from [StoredGrades]ON_Transcript_C) |
| Transcript_F | 17.1.0 | Number(1,0) | French Note Flag (Migrates from [StoredGrades]ON_Transcript_F) |
| Transcript_H | 17.1.0 | Number(1,0) | SHSM Note Flag (Migrates from [StoredGrades]ON_Transcript_H) |
| Transcript_I | 17.1.0 | Number(1,0) | Interdisciplinary Studies Note Flag (Migrates from [StoredGrades]ON_Transcript_I) |
| Transcript_M | 17.1.0 | Number(1,0) | Modified Curriculum Note Flag (Migrates from [StoredGrades]ON_Transcript_M) |
| Transcript_P | 17.1.0 | Number(1,0) | Private School Credit Note Flag (Migrates from [StoredGrades]ON_Transcript_P) |
| Transcript_S | 17.1.0 | Number(1,0) | Special Circumstances Note Flag (Migrates from [StoredGrades]ON_Transcript_S) |
| Transcript_T | 17.1.0 | Number(1,0) | Team Taught Dual Credit Note Flag (Migrates from [StoredGrades]ON_Transcript_T) |
| Transcript_W | 17.1.0 | Number(1,0) | Disclosure Mark Flag (Migrates from [StoredGrades]ON_Transcript_W) |
| Credit_Date | 17.1.0 | Date | Date Completed (Migrates from [StoredGrades]ON_Credit_Date) |
| PLAR_Compulsory | 17.1.0 | Number(25,10) | PLAR Compulsory (Migrates from [StoredGrades]ON_PLAR_Compulsory |
| PLAR_Type | 17.1.0 | VarChar2(1) | PLAR Type (Migrates from [StoredGrades]ON_PLAR_Type) |
| PLAR_Status | 17.1.0 | VarChar2(2) | PLAR Status Type (Migrates from [StoredGrades]ON_PLAR_Status) |
| Credit_Type | 17.1.0 | VarChar2(3) | OnSIS Credit Type (Migrates from [StoredGrades]ON_Credit_Type) |
| Delivery_Type | 17.1.0 | VarChar2(3) | Delivery Type (Migrates from [StoredGrades]ON_Delivery_Type) |
| School_Number | 17.1.0 | VarChar2(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_Recovery | 19.9.2.0 | VarChar2(10) | Indicates whether the course is Credit Recovery, Set to 1 when Credit Recovery otherwise NULL. |
| OthCrsInfo_Ministry_Content | 19.9.2.0 | VarChar2(10) | Indicates whether course is Ministry Developed Content. Set to 2 = Ministry Developed Content otherwise NULL |
| OthCrsInfo_UpgradCrdtCourse | 20.7.2.0 | VarChar2(10) | Indicates whether course is Upgrading Credit Course. Set to 3 = Upgrading Credit Course otherwise NULL |
| CALCREPEATSONCRSNUM | 20.11.2.0 | Number(1,0) | Calculate repeats on Course Number Flag |
| OthCrsInfo_Online | 22.10.3.0 | Varchar(10) | Indicates whether course is Online. Set to 4 = Online otherwise NULL |