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.0 | Number(1,0) | Is a Night (Continuing Education) School (Migrates from [Schools]ON_IsNightSchool |
| Section23_Flag | 17.1.0 | Number(1,0) | Section 23 School Flag (Migrates from [Schools]ON_Section23_Flag) |
| OCAS_Apr | 17.1.0 | Date | OCAS April Date (Migrates from [Schools]ON_OCAS_Apr) |
| OCAS_Feb | 17.1.0 | Date | OCAS February Date (Migrates from [Schools]ON_OCAS_Feb) |
| OCAS_Jul | 17.1.0 | Date | OCAS July Date (Migrates from [Schools]ON_OCAS_Jul) |
| OCAS_Nov | 17.1.0 | Date | OCAS November Date (Migrates from [Schools]ON_OCAS_Nov) |
| OCAS_Oct | 17.1.0 | Date | OCAS October Date (Migrates from [Schools]ON_OCAS_Oct) |
| OUAC_TRN_1 | 17.1.0 | Date | OUAC Transmission 1 Date (Migrates from [Schools]ON_OUAC_TRN_1) |
| OUAC_TRN_1R | 20.10.2 | Date | OUAC Re-Transmission 1 Date |
| OUAC_TRN_2 | 17.1.0 | Date | OUAC Transmission 2 Date (Migrates from [Schools]ON_OUAC_TRN_2) |
| OUAC_TRN_3 | 17.1.0 | Date | OUAC Transmission 3 Date (Migrates from [Schools]ON_OUAC_TRN_3) |
| OUAC_TRN_4 | 17.1.0 | Date | OUAC Transmission 4 Date (Migrates from [Schools]ON_OUAC_TRN_4) |
| OUAC_TRN_5 | 17.1.0 | Date | OUAC Transmission 5 Date (Migrates from [Schools]ON_OUAC_TRN_5) |
| PR_End_Date | 17.1.0 | Date | Progress Report Attendance End Date (Migrates from [Schools]ON_PR_End_Date) |
| R1_End_Date | 17.1.0 | Date | First Report Card Attendance End Date (Migrates from [Schools]ON_R1_End_Date) |
| AM_Tardy_Period | 17.1.0 | VarChar2(3) | AM Tardy Check Period (Migrates from [Schools]ON_AM_Tardy_Period) |
| CouncilChair | 17.1.0 | VarChar2(100) | Council Chair (Migrates from [Schools]ON_CouncilChair) |
| OCAS_Contact_Extension | 17.1.0 | VarChar2(10) | Contact Phone Extension (Migrates from [Schools]ON_OCAS_Contact_Extension) |
| OCAS_Contact_Firstname | 17.1.0 | VarChar2(50) | Contact First Name (Migrates from [Schools]ON_OCAS_Contact_Firstname) |
| OCAS_Contact_Phone | 17.1.0 | VarChar2(30) | Contact Phone Number (Migrates from [Schools]ON_OCAS_Contact_Phone) |
| OCAS_Contact_Surname | 17.1.0 | VarChar2(50) | Contact Surname (Migrates from [Schools]ON_OCAS_Contact_Surname) |
| OCAS_Email | 17.1.0 | VarChar2(50) | Contact Email Address (Migrates from [Schools]ON_OCAS_Contact_Email) |
| PM_Tardy_Period | 17.1.0 | VarChar2(3) | PM Tardy Check Period (Migrates from [Schools]ON_ON_PM_Tardy_Period) |
| IsClosed_TF | 17.5.0 | Number(1,0) | Migrated from: [Schools]ON_IsClosed |
| Care_Trmt_Pgm_Type | 20.5.2 | VarChar2(1) | Care Treatment Program Type |
| Model_FirstHalf | 21.2.1 | VarChar2(3) | Model used for first half of school year |
| Model_SecondHalf | 21.2.1 | VarChar2(3) | Model used for second half of school year |
| UsesFlipWeeks | 21.3.2 | Number(1,0) | Flag indicating if this school uses flip weeks |
| Desig_SchoolsDCIDElem | 21.6.2.0 | Integer | Field is used to record Designated School for Elementary in Case of K-12 Schools. |
| ON_ExcludeElemRC | 21.12.1.0 | Number(1,0) | Field is used to record Exclude Elementary Achievements From OnSIS Submissions |