S_SK_STU_X (ver 14.8.0)
This is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.8.0 | Number(11,0) | Primary key that relates the extended table to the [Students] table. |
AddToStudentEnrollment | 14.8.0 | VarChar2(1) | Flag for demographic update for the SK School Enrollments report. |
| AboriginalStatus | 16.8.2 | Varchar2(6) | Aboriginal Status. Migrated from [Students]SK_AboriginalStatus. |
| AlternateEmail | 16.8.2 | Varchar2(254) | Alternate Email. Migrated from [Students]SK_AlternateEmail. |
| BandAffiliationCode | 16.8.2 | Varchar2(3) | Band Affiliation Code. Migrated from [Students]SK_BandAffiliationCode. |
| BandAffiliationEndDate | 16.8.2 | Date | Band Affiliation End Date. Migrated from [Students]SK_BandAffiliationEndDate. |
| BandAffiliationStartDate | 16.8.2 | Date | Band Affiliation Start Date. Migrated from [Students]SK_BandAffiliationStartDate. |
| CountryOfBirth | 16.8.2 | Varchar2(2) | Country of Birth. Migrated from [Students]SK_CountryOfBirth. |
| CountryOfCitizenship1 | 16.8.2 | Varchar2(2) | First Country of Citizenship. Migrated from [Students]SK_CountryOfCitizenship1. |
| CountryOfCitizenship2 | 16.8.2 | Varchar2(2) | Second Country of Citizenship. Migrated from [Students]SK_CountryOfCitizenship2. |
| CountryOfOrigin | 16.8.2 | Varchar2(2) | Country of Origin. Migrated from [Students]SK_CountryOfOrigin. |
| CumulativeFolder | 16.8.2 | Boolean | "Is Cumulative Folder located at currently enrolled School?".Flag Migrated from [Students]SK_CumulativeFolder. |
| EALEndDate | 16.8.2 | Date | EAL Start Date. Migrated from [Students]SK_EALEndDate. |
| EALLevel | 16.8.2 | Varchar2(2) | EAL Proficiency Level. Migrated from [Students]SK_EALLevel. |
| EALStartDate | 16.8.2 | Date | EAL Start Date. Migrated from [Students]SK_EALStartDate. |
| ExchangeLength | 16.8.2 | Number(3,0) | Length of Exchange. Migrated from [Students]SK_ExchangeLength. |
| ExchangePgm | 16.8.2 | Varchar2(2) | Exchange Program. Migrated from [Students]SK_ExchangePgm. |
| FeesCollected | 16.8.2 | Boolean | Tuition Fees flag. Migrated from [Students]SK_FeesCollected |
| Health_Num | 16.8.2 | Number(9,0) | SASK Health Number. Migrated from [Students]SK_Health_Num. |
| Homebound | 16.8.2 | Boolean | Homebound flag. Migrated from [Students]SK_Homebound. |
| HomeLanguage1 | 16.8.2 | Varchar2(3) | First Home Language. Migrated from [Students]SK_HomeLanguage1. |
| HomeLanguage2 | 16.8.2 | Varchar2(3) | Second Home Language. Migrated from [Students]SK_HomeLanguage2. |
| ImmersionTypeCode | 16.8.2 | Varchar2(2) | Immersion Type. Migrated from [Students]SK_ImmersionTypeCode. |
| Mer | 16.8.2 | Varchar2(1) | Meridian. Migrated from [Students]SK_Mer. |
| PreferredName | 16.8.2 | Varchar2(200) | Student Preferred Name. Migrated from [Students]SK_PreferredName. |
| PreKEndDate | 16.8.2 | Date | Shared Space End Date. Migrated from [Students]SK_PreKEndDate. |
| PreKMinistryDesignated | 16.8.2 | Boolean | Ministry-Designated Space flag. Migrated from [Students]SK_PreKMinistryDesignated. |
| PreKSharedSpace | 16.8.2 | Boolean | Shared Space flag. Migrated from [Students]SK_PreKSharedSpace. |
| PreKStartDate | 16.8.2 | Date | Shared Space Start Date. Migrated from [Students]SK_PreKStartDate. |
| PrimaryEmail | 16.8.2 | Varchar2(254) | Primary Email. Migrated from [Students]SK_PrimaryEmail. |
| ProgramEnrollmentID | 16.8.2 | Varchar2(2) | Student Program Enrollment. Migrated from [Students]SK_ProgramEnrollmentID. |
| ProgramEntryDate | 16.8.2 | Date | Effective Start Date of the Program Enrollment. Migrated from [Students]SK_ProgramEntryDate. |
| QSec | 16.8.2 | Varchar2(2) | Quarter Section. Migrated from [Students]SK_QSec. |
| ReserveResidencyCode | 16.8.2 | Varchar2(3) | Reserve Residency Code. Migrated from [Students]SK_ReserveResidencyCode. |
| ReserveResidencyEndDate | 16.8.2 | Date | Reserve Residency End Date. Migrated from [Students]SK_ReserveResidencyEndDate. |
| ReserveResidencyStartDate | 16.8.2 | Date | Reserve Residency Start Date. Migrated from [Students]SK_ReserveResidencyStartDate. |
| Rge | 16.8.2 | Varchar2(3) | Range. Migrated from [Students]SK_Rge. |
| RL | 16.8.2 | Varchar2(3) | River Lot. Migrated from [Students]SK_RL. |
| SaskResident | 16.8.2 | Boolean | Saskatchewan Residency flag. Migrated from [Students]SK_SaskResident. |
| Sec | 16.8.2 | Varchar2(3) | Section. Migrated from [Students]SK_Sec. |
| TreatyEndDate | 16.8.2 | Date | Treaty End Date. Migrated from [Students]SK_TreatyEndDate. |
| TreatyNumber | 16.8.2 | Varchar2(20) | Treaty Number. Migrated from [Students]SK_TreatyNumber. |
| TreatyStartDate | 16.8.2 | Date | Treaty Start Date. Migrated from [Students]SK_TreatyStartDate. |
| TuitionStatus | 16.8.2 | Varchar2(2) | Tuition Status. Migrated from [Students]SK_TuitionStatus. |
| Twp | 16.8.2 | Varchar2(3) | Township. Migrated from [Students]SK_Twp. |
| ResidentType | 16.8.2 | Varchar2(3) | Resident Type. Migrated from [Students]SK_ResidentType. |