S_ON_CC_X ver 14.10.0
This table is an extension of the [CC] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
CCDCID | 14.10.0 | Number(10,0) | Primary key that relates the extended table to the CC table |
StudentID | 14.10.0 | Number(10,0) | Foreign key reference to Students table |
| WorkUnitsOctober | 14.10.0 | Number(11,0) | Independent Study Number of Work Units Completed as of October 31st |
| WorkUnitsMarch | 14.10.0 | Number(11,0) | Independent Study Number of Work Units Completed as of March 31st |
| WorkUnitsJune | 14.10.0 | Number(11,0) | Independent Study Number of Work Units Completed as of June 30th |
| Previous_Year_Class | 15.7.0 | Varchar2(1) | Flag indicating whether class is a continuation from the previous year |
| OCAS_Oct_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OCAS October transmission |
| OCAS_Nov_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OCAS November transmission |
| OCAS_Feb_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OCAS February transmission |
| OCAS_Apr_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OCAS April transmission |
| OUAC_TRN1_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OUAC transmission 1 |
| OUAC_TRN1R_ProjectedCourse | 20.10.2 | Number(1,0) | Projected course flag for OUAC Re-transmission 1 |
| OUAC_TRN2_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OUAC transmission 2 |
| OUAC_TRN3_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OUAC transmission 3 |
| OUAC_TRN4_ProjectedCourse | 15.9.0 | Number(1,0) | Projected course flag for OUAC transmission 4 |
| NumberOfCompletedUnits | 15.12.0 | Number(11,0) | Number Of Completed Work Units / Lessons Override |
| LNPG_Reference | 16.2.2 | Varchar(12) | Literacy and Numeracy Parent/Guardian Reference Number |
| Transcript_A | 16.3.0 | Number(1,0) | Alternative Expectations Note Flag. Migrated from [CC.ON_Transcript_A]. |
| Transcript_B | 16.3.0 | Number(1,0) | Transcript Credit Adjustment Note Flag. Migrated from [CC.ON_Transcript_B]. |
| Transcript_C | 16.3.0 | Number(1,0) | Co-op Note Flag. Migrated from [CC.ON_Transcript_C]. |
| Transcript_F | 16.3.0 | Number(1,0) | French Note Flag. Migrated from [CC.ON_Transcript_F]. |
| Transcript_H | 16.3.0 | Number(1,0) | Specialist High Skills Major (SHSM) Note Flag. Migrated from [CC.ON_Transcript_H]. |
| Transcript_I | 16.3.0 | Number(1,0) | Interdisciplinary Studies Note Flag. Migrated from [CC.ON_Transcript_I]. |
| Transcript_M | 16.3.0 | Number(1,0) | Modified Curriculum Note Flag. Migrated from [CC.ON_Transcript_M]. |
| Transcript_P | 16.3.0 | Number(1,0) | Private School Credit Note Flag. Migrated from [CC.ON_Transcript_P]. |
| Transcript_S | 16.3.0 | Number(1,0) | Special Circumstances Note Flag. Migrated from [CC.ON_Transcript_S]. |
| Transcript_T | 16.3.0 | Number(1,0) | Team Taught Dual Credit Note Flag. Migrated from [CC.ON_Transcript_T]. |
| IsIndependentStudy_Class | 16.12.1 | Varchar2(1) | Flag indicating whether a class is an independent study class. |