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 |