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 |