S_ON_STU_XML_School_Enrol_C ver 20.7.2.0
This table is a child table of Students and stores Student School Enrolment segment information.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 20.7.2.0 | Number(19) | Primary key |
StudentsDCID | 20.7.2.0 | Number(19) | Primary key that relates the extended table to the [Students] table |
Academic_Year | 20.7.2.0 | Varchar2(9 char) | The academic year of the submission |
| Action | 20.7.2.0 | Varchar2(6 char) | This is the action associated with this submission Valid values: ADD, UPDATE |
| ADE | 20.7.2.0 | Number(25,10) | Independent Study average daily enrolment |
| attendance_Type | 20.7.2.0 | Varchar2(2 char) | Attendance Type Valid values: FT, PT |
| BSID | 20.7.2.0 | Number(11) | Board School Identification number |
| Care_Trtmnt_Res_Type | 20.7.2.0 | Varchar2(8 char) | Create Treatment Residence Status |
| Class_Code | 20.7.2.0 | Varchar2(25 char) | This is used to uniquely identify the class |
| Comm_Involment_Accu_Hours | 20.7.2.0 | Varchar2(6 char) | Community Involvement Accumulated Hours to Date |
| Country_Type | 20.7.2.0 | Varchar2(3 char) | Country of Entry |
| Country_Type_Birth | 20.7.2.0 | Varchar2(3 char) | Country of Birth |
| Country_Type_Exit | 20.7.2.0 | Varchar2(3 char) | Country of Exit |
| Current_Residence_Country | 20.7.2.0 | Varchar2(3 char) | The student's current country of residence |
| Current_Residence_Province | 20.7.2.0 | Varchar2(3 char) | The student's current province of residence |
| Days_Absent_Ytd | 20.7.2.0 | Number(25,10) | Total Days absent (Year to date) |
| Designated_School_Number | 20.7.2.0 | Number(11) | Student’s designated school |
| Diploma_Certificate_Issued | 20.7.2.0 | Date | Diploma Certificate issuance date |
| Diploma_Type | 20.7.2.0 | Varchar2(3 char) | Used to uniquely identify the diplomas/certificate |
| EDP_Type | 20.7.2.0 | Varchar2(3 char) | Extended day program type |
| Enrolment_End_Date | 20.7.2.0 | Date | Enrolment end date |
| Enrolment_Start_Date | 20.7.2.0 | Date | Enrolment start date |
| French_Admission_Appro_Date | 20.7.2.0 | Date | French admission committee approval date |
| FTE | 20.7.2.0 | Number(25,10) | Full Time Equivalent |
| Gender_Desc | 20.7.2.0 | Varchar2(50 char) | Student's gender description |
| Gender_Type | 20.7.2.0 | Varchar2(7 char) | Student's gender |
| Grade_Designation_Type | 20.7.2.0 | Varchar2(8 char) | Grade Designation Type |
| Grade_Type | 20.7.2.0 | Varchar2(3 char) | Grade type |
| High_Credit_ADE | 20.7.2.0 | Number(25,10) | High credit independent study average daily enrolment |
| High_Credit_FTE | 20.7.2.0 | Number(25,10) | High credit full time equivalent |
| Indigenous_Self_Id | 20.7.2.0 | Varchar2(8 char) | Indigenous self identification |
| Language_Type | 20.7.2.0 | Varchar2(40 char) | Language type |
| Language_Type_Previous_Sch | 20.7.2.0 | Varchar2(3 char) | Language of Previous School |
| Literacy_Status_Type | 20.7.2.0 | Varchar2(1 char) | Literary Status |
| Local_School_Program_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicator for student enrolled in local school program |
| Main_School_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicator if enrolled in main school |
| Mature_Student_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicating if student is a Mature Student with regards to PLAR (T/F) |
| OEN | 20.7.2.0 | Varchar2(9 char) | Ontario Education Number |
| Ontario_Scholarship_Date | 20.7.2.0 | Date | Ontario scholarship approval date of student |
| Ontario_Scholarship_Flag | 20.7.2.0 | Varchar2(1 char) | Ontario Scholarship Approval |
| OYAP_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicating whether the student is enrolled in the Ontario Youth Apprenticeship Program (T/F) |
| Postal_Area_Type | 20.7.2.0 | Varchar2(10 char) | Postal Code |
| Promotion_Flag | 20.7.2.0 | Varchar2(1 char) | Indicates whether the student is promoted to the next grade |
| Province_State_Type | 20.7.2.0 | Varchar2(3 char) | Province of Entry |
| Province_State_Type_Birth | 20.7.2.0 | Varchar2(3 char) | Province of Birth |
| Province_State_Type_Exit | 20.7.2.0 | Varchar2(3 char) | Province of Exit |
| Reach_Ahead_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicating if student is a Reach Ahead Student (T/F) |
| Residence_Status_Type | 20.7.2.0 | Varchar2(3 char) | Residence Status |
| School_Student_Number | 20.7.2.0 | Varchar2(32 char) | School student number |
| SHSM_All_Req_Met_YYYYMM | 20.7.2.0 | Varchar2(7 char) | All Requirements Met Date as it appears on the SHSM Program |
| SHSM_Program_Type | 20.7.2.0 | Varchar2(40 char) | used to uniquely identify the SHSM Program |
| Special_Education_Flag | 20.7.2.0 | Varchar2(1 char) | Flag indicates if the student receives special education |
| Stu_Brd_Res_Stat_Type | 20.7.2.0 | Varchar2(3 char) | Board Residence Status |
| Student_Mobility_Type | 20.7.2.0 | Varchar2(3 char) | Entry Code |
| Student_Mobility_Type_Exit | 20.7.2.0 | Varchar2(20 char) | Exit Code |
| Submission_Period_Type | 20.7.2.0 | Varchar2(20 char) | Submission period type |
| Times_Late_Ytd | 20.7.2.0 | Number(25,10) | The number of times the student was late (Year to date) |
| Year_Of_Entry_To_Canada | 20.7.2.0 | Varchar2(7 char) | Date of entry into Canada. Format YYYY/MM |
| Diploma_Action | 21.4.2.0 | Varchar2(6 char) | Diploma Action |
| SHSM_Action | 21.4.2.0 | Varchar2(6 char) | SHSM Action |
| WhoCreated | 20.7.2.0 | Varchar2(100 char) | Who created the record |
| WhenCreated | 20.7.2.0 | Timestamp(6) | When record was created |
| WhoModified | 20.7.2.0 | Varchar2(100 char) | Who modified the record |
| WhenModified | 20.7.2.0 | Timestamp(6) | When was the record modified |
| Sal_FLag | 21.11.2 | Number(1,0) | When Student is a SAL student |