S_MB_STU_X (ver 14.9.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
| StudentsDCID | 14.9.0 | Number (10,0) | Primary key that relates the extended table to the [Students] table |
| NewcomerAssessment | 14.9.0 | Varchar2(2) | Newcomer EAL Assessment Level Code |
NewcomerAdditionalFrench | 14.9.0 | Varchar2(1) | Needs Additional French Language Support Flag |
NewcomerYear | 14.9.0 | Number (11,0) | Newcomer Year |
| AboriginalID1 | 16.12.1 | Varchar2(3) | Aboriginal Cultural Group Code. Migrated from [Students.MB_AboriginalID1]. |
| AboriginalID2 | 16.12.1 | Varchar2(3) | Aboriginal Cultural-Linguistic Identity Code 1. Migrated from [Students.MB_AboriginalID2]. |
| AboriginalID3 | 16.12.1 | Varchar2(3) | Aboriginal Cultural-Linguistic Identity 2 Code. Migrated from [Students.MB_AboriginalID3]. |
| AboriginalOtherDesc | 16.12.1 | Varchar2(25) | Aboriginal Other Description. Migrated from [Students.MB_AboriginalOtherDesc]. |
| CareOfCFS | 16.12.1 | Number (1,0) | Care Of Child And Family Services Flag. Migrated from [Students.MB_CareOfFCS]. |
| Eligible | 16.12.1 | Number (11,0) | Eligibility Percentage. Migrated from [Students.MB_Eligible]. |
| HasDiploma | 16.12.1 | Number (1,0) | Has Diploma Flag. Migrated from [Students.MB_HasDiploma]. |
| Ministry_Grad_Plan_GPVersionID | 16.12.1 | Number (11,0) | Foreign key reference to GPVersion table identifying the student's graduation contact. Migrated from [Students.MB_Ministry_Grad_Plan]. |
| NumberOfEnhancedCourses1 | 16.12.1 | Number (11,0) | Number Of Enhanced Courses 1. Migrated from [Students.MB_NumberOfEnhancedCourses1]. |
| NumberOfEnhancedCourses2 | 16.12.1 | Number (11,0) | Number Of Enhanced Courses 2. Migrated from [Students.MB_NumberOfEnhancedCourses2]. |
| PreviousSurname | 16.12.1 | Varchar2(35) | Previous Surname. Migrated from [Students.MB_PreviousSurname]. |
| PrincipalComments | 16.12.1 | Varchar2(4000) | Principal's Comments. Migrated from [Students.MB_PrincipalComments]. |
| ResidentDivision | 16.12.1 | Varchar2(4) | Resident Division Code. Migrated from [Students.MB_ResidentDivision]. |
| SpecialNeeds | 16.12.1 | Varchar2(3) | Special Needs Code. Migrated from [Students.MB_SpecialNeeds]. |
| StudentProgram1 | 16.12.1 | Varchar2(3) | Language Program Code 1. Migrated from [Students.MB_StudentProgram1]. |
| StudentProgram2 | 16.12.1 | Varchar2(3) | Language Program Code 2. Migrated from [Students.MB_StudentProgram2]. |
| StudentProgram3 | 16.12.1 | Varchar2(3) | Language Program Code 3. Migrated from [Students.MB_StudentProgram3]. |
| StudentProgram4 | 16.12.1 | Varchar2(3) | Language Program Code 4. Migrated from [Students.MB_StudentProgram4]. |
| TransferInToDistrict | 16.12.1 | Number (1,0) | Transfer In From Outside District Flag. Migrated from [Students.MB_TransferInToDistrict]. |
| TransferOutOfDistrict | 16.12.1 | Number (1,0) | Transfer Out Of District Flag. Migrated from [Students.MB_TransferOutOfDistrict]. |
| Transportation | 16.12.1 | Varchar2(3) | Transportation Code. Migrated from [Students.MB_Transportation]. |