S_ON_SEN_X ver 15.8.0
This table is an extension of the [SpEnrollments] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
SpEnrollmentsDCID | 15.8.0 | Number(10,0) | Primary key that relates the extended table to the [SpEnrollments] table. |
| Exceptionality | 15.8.0 | Varchar2(6) | Exceptionality Code. Migrated from [SPEnrollments.ON_Exceptionality]. |
| IEP_Flag | 15.8.0 | Number(1,0) | Individual Education Plan (IEP) Flag. Migrated from [SpEnrollments.ON_IEP_Flag]. |
| IPRC_Date | 15.8.0 | Date | Identification Placement And Review Committee (IPRC) Review Date. Migrated from [SpEnrollments.ON_IPRC_Date]. |
| IPRC_Flag | 15.8.0 | Number(1,0) | Identification Placement And Review Committee Flag. Migrated from [SpEnrollments.ON_IPRC_Flag]. |
| Main_Flag | 15.8.0 | Number(1,0) | Main Exceptionality Flag. Migrated from [SpEnrollments.ON_Main_Flag]. |
| Placement | 15.8.0 | Varchar2(6) | Placement Code. Migrated from [SpEnrollments.ON_Placement]. |
| SAL_Exit_Reason | 15.8.0 | Varchar2(3) | Structured Alternative Learning (SAL) Exit Reason Code. Migrated from [SpEnrollments.ON_SAL_Exit_Reason]. |
| SAL_Status | 15.8.0 | Varchar2(3) | Structured Alternative Learning (SAL) Status Type Code. Migrated from [SpEnrollments.ON_SAL_Status]. |
| SHSM_Experiential_Date | 15.8.0 | Date | Specialist High Skills Major (SHSM) Experiential Learning Activity Date. Migrated from [SpEnrollments.ON_SHSM_Experiential_Date]. |
| SHSM_Pathway | 15.8.0 | Varchar2(3) | Specialist High Skills Major (SHSM) Pathway Code. Migrated from [SpEnrollments.ON_SHSM_Pathway]. |
| SHSM_Program_Date | 15.8.0 | Date | Specialist High Skills Major (SHSM) Program All Requirements Met Date. Migrated from [SpEnrollments.ON_SHSM_Program_Date]. |
| SHSM_ReachAhead_Date | 15.8.0 | Date | Specialist High Skills Major (SHSM) Reach Ahead Date. Migrated from [SpEnrollments.ON_SHSM_ReachAhead_Date]. |
| SHSM_SkillDev_Date | 15.8.0 | Date | Specialist High Skills Major (SHSM) Skills Development Date. Migrated from [SpEnrollments.ON_SHSM_SkillDev_Date]. |
| SHSM_Component | 18.6.0 | Varchar2(6) | SHSM Component: Ontario Skills Passport (OSP), Sector-Partner Contextualized Experience (SPC) |
| SPC_Coding | 18.6.0 | Boolean | SHSM SPC Component: Coding |
| SPC_Innovation | 18.6.0 | Boolean | SHSM SPC Component: Innovation, creativity and entrepreneurship |
| SPC_MathLit | 18.6.0 | Boolean | SHSM SPC Component: Mathematical Literacy |