Skip to main content
Skip table of contents

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.0Varchar2(9 char)

The academic year of the submission

Action20.7.2.0Varchar2(6 char)This is the action associated with this submission
Valid values: ADD, UPDATE
ADE20.7.2.0
Number(25,10)

Independent Study average daily enrolment

attendance_Type20.7.2.0
Varchar2(2 char)Attendance Type
Valid values: FT, PT
BSID20.7.2.0
Number(11)Board School Identification number
Care_Trtmnt_Res_Type20.7.2.0
Varchar2(8 char)Create Treatment Residence Status
Class_Code20.7.2.0
Varchar2(25 char)This is used to uniquely identify the class
Comm_Involment_Accu_Hours20.7.2.0
Varchar2(6 char)Community Involvement Accumulated Hours to Date
Country_Type20.7.2.0
Varchar2(3 char)

Country of Entry

Country_Type_Birth20.7.2.0
Varchar2(3 char)Country of Birth
Country_Type_Exit20.7.2.0
Varchar2(3 char)Country of Exit
Current_Residence_Country20.7.2.0
Varchar2(3 char)The student's current country of residence
Current_Residence_Province20.7.2.0
Varchar2(3 char)The student's current province of residence
Days_Absent_Ytd20.7.2.0
Number(25,10)Total Days absent (Year to date)
Designated_School_Number20.7.2.0
Number(11)Student’s designated school
Diploma_Certificate_Issued20.7.2.0
DateDiploma Certificate issuance date
Diploma_Type20.7.2.0
Varchar2(3 char)Used to uniquely identify the diplomas/certificate
EDP_Type20.7.2.0
Varchar2(3 char)

Extended day program type

Enrolment_End_Date20.7.2.0
Date

Enrolment end date

Enrolment_Start_Date20.7.2.0
DateEnrolment start date
French_Admission_Appro_Date20.7.2.0
Date

French admission committee approval date

FTE20.7.2.0Number(25,10)Full Time Equivalent
Gender_Desc20.7.2.0Varchar2(50 char)Student's gender description
Gender_Type20.7.2.0Varchar2(7 char)Student's gender
Grade_Designation_Type20.7.2.0Varchar2(8 char)Grade Designation Type
Grade_Type20.7.2.0Varchar2(3 char)Grade type
High_Credit_ADE20.7.2.0Number(25,10)High credit independent study average daily enrolment
High_Credit_FTE20.7.2.0Number(25,10)High credit full time equivalent
Indigenous_Self_Id20.7.2.0Varchar2(8 char)Indigenous self identification
Language_Type20.7.2.0Varchar2(40 char)Language type
Language_Type_Previous_Sch20.7.2.0Varchar2(3 char)Language of Previous School
Literacy_Status_Type20.7.2.0Varchar2(1 char)Literary Status
Local_School_Program_Flag20.7.2.0Varchar2(1 char)Flag indicator for student enrolled in local school program
Main_School_Flag20.7.2.0Varchar2(1 char)Flag indicator if enrolled in main school
Mature_Student_Flag20.7.2.0Varchar2(1 char)Flag indicating if student is a Mature Student with regards to PLAR (T/F)
OEN20.7.2.0Varchar2(9 char)Ontario Education Number
Ontario_Scholarship_Date20.7.2.0DateOntario scholarship approval date of student
Ontario_Scholarship_Flag20.7.2.0Varchar2(1 char)Ontario Scholarship Approval
OYAP_Flag20.7.2.0Varchar2(1 char)Flag indicating whether the student is enrolled in the Ontario Youth Apprenticeship Program (T/F)
Postal_Area_Type20.7.2.0Varchar2(10 char)

Postal Code

Promotion_Flag20.7.2.0Varchar2(1 char)Indicates whether the student is promoted to the next grade
Province_State_Type20.7.2.0Varchar2(3 char)Province of Entry
Province_State_Type_Birth20.7.2.0Varchar2(3 char)Province of Birth
Province_State_Type_Exit20.7.2.0Varchar2(3 char)Province of Exit
Reach_Ahead_Flag20.7.2.0Varchar2(1 char)Flag indicating if student is a Reach Ahead Student (T/F)
Residence_Status_Type20.7.2.0Varchar2(3 char)Residence Status
School_Student_Number20.7.2.0Varchar2(32 char)School student number
SHSM_All_Req_Met_YYYYMM20.7.2.0Varchar2(7 char)All Requirements Met Date as it appears on the SHSM Program
SHSM_Program_Type20.7.2.0Varchar2(40 char)used to uniquely identify the SHSM Program
Special_Education_Flag20.7.2.0Varchar2(1 char)Flag indicates if the student receives special education
Stu_Brd_Res_Stat_Type20.7.2.0Varchar2(3 char)Board Residence Status
Student_Mobility_Type20.7.2.0Varchar2(3 char)

Entry Code

Student_Mobility_Type_Exit20.7.2.0Varchar2(20 char)Exit Code
Submission_Period_Type20.7.2.0Varchar2(20 char)

Submission period type

Times_Late_Ytd20.7.2.0Number(25,10)The number of times the student was late (Year to date)
Year_Of_Entry_To_Canada20.7.2.0Varchar2(7 char)Date of entry into Canada. Format YYYY/MM
Diploma_Action21.4.2.0Varchar2(6 char)Diploma Action
SHSM_Action21.4.2.0Varchar2(6 char)SHSM Action
WhoCreated20.7.2.0Varchar2(100 char)Who created the record
WhenCreated20.7.2.0Timestamp(6)When record was created
WhoModified20.7.2.0Varchar2(100 char)Who modified the record
WhenModified20.7.2.0Timestamp(6)When was the record modified
Sal_FLag21.11.2Number(1,0)When Student is a SAL student
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.