S_ON_STU_XML_NON_ENROL_C
This table is a child table of Students and stores Student Non Enrolment segment information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 21.5.3.0 | Number(19) | Primary key |
StudentsDCID | 21.5.3.0 | Number(19) | Primary key that relates the extended table to the [Students] table |
Academic_Year | 21.5.3.0 | Varchar2(9 char) | The academic year of the submission |
| Submission_Period_Type | 21.5.3.0 | Varchar2(20 char) | Submission period type |
| BSID | 21.5.3.0 | Number(11) | Board School Identification number |
| OEN | 21.5.3.0 | Varchar2(9 char) | Ontario Education Number |
| Action | 21.5.3.0 | Varchar2(6 char) | This is the action associated with this submission Valid values: ADD |
| Grade_Type | 21.5.3.0 | Varchar2(3 char) | Grade Type |
| Main_School_Flag | 21.5.3.0 | Varchar2(1 char) | Main School Flag |
| Literacy_Status_Type | 21.5.3.0 | Varchar2(1 char) | Literacy Status Type |
| Comm_Involment_Accu_Hours | 21.5.3.0 | Varchar2(6 char) | Community Involvement Accumulated Hours |
| Ontario_Scholarship_Flag | 21.5.3.0 | Varchar2(1 char) | Ontario Scholarship Flag |
| Ontario_Scholarship_Date | 21.5.3.0 | Date | Ontario Scholarship Date |
| Special_Education_Flag | 21.5.3.0 | Varchar2(1 char) | Special Education Flag |
| Gender_Type | 21.5.3.0 | Varchar2(7 char) | Gender Type |
| Gender_Desc | 21.5.3.0 | Varchar2(50 char) | Gender Description |
| Diploma_Type | 21.5.3.0 | Varchar2(3 char) | Diploma Type |
| Diploma_Certificate_Issued | 21.5.3.0 | Date | Diploma Certificate Issued |
| SHSM_Program_Type | 21.5.3.0 | Varchar2(40 char) | SHSM Program Type |
| SHSM_All_Req_Met_YYYYMM | 21.5.3.0 | Varchar2(7 char) | SHSM All Requirement Met Date |
| WhoCreated | 21.5.3.0 | Varchar2(100 char) | Who created the record |
| WhenCreated | 21.5.3.0 | Timestamp(6) | When record was created |
| WhoModified | 21.5.3.0 | Varchar2(100 char) | Who modified the record |
| WhenModified | 21.5.3.0 | Timestamp(6) | When was the record modified |