S_WY_STU_X (ver 14.10.0)
This table is an extension of the Students table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.10.0 | Number(10,0) | Primary Key |
| CurriculumWaiver | 14.10.0 | Varchar2(1) | Indicates if a student has received a Hathaway Scholarship Success Curriculum waiver. |
| ForeignLangProf | 14.10.0 | Varchar2(1) | Indicates students that have completed the foreign language proficiency requirements established by the district. |
| AlternateAssessment | 15.8.0 | Varchar2(1) | Indicates if the student has been identified to take the State Alternate Assessment test. Migrated from [Students.WY_AlternateAssessment]. |
| AssessmentForms | 15.8.0 | Varchar2(1) | Indicates the type of Special State Assessment Form required by the student. Migrated from [Students.WY_AssessmentForms]. |
| BirthCountry | 15.8.0 | Varchar2(2) | Birth Country of the student. Migrated from [Students.WY_BirthCountry]. |
| HomeLanguage | 15.8.0 | Varchar2(3) | Student's home language. Migrated from [Students.WY_HomeLanguage]. |
| HomelessNightResidence | 15.8.0 | Varchar2(2) | Primary nighttime residence of the student when the student was identified as homeless. Migrated from [Students.WY_HomelessNightResidence]. |
| MembershipType | 15.8.0 | Varchar2(1) | Membership type (Home/Concurrent) of the student. Migrated from [Students.WY_MembershipType]. |
| USEducationEntryDate | 15.8.0 | Date | Date the student first entered the public education system in the United States. Migrated from [Students.WY_US_EducationEntryDate]. |
| USEducationYrs | 15.8.0 | Number(11,0) | Indicates the number of years of education the student has completed in the United States. Migrated from [Students.WY_US_EducationYrs]. |
| VocConcen | 15.8.0 | Varchar2(1) | Indicates if the student is a vocational concentrator. Migrated from [Students.WY_VocConcen]. |
| MostRecentDistEntryDate | 15.8.0 | Date | Most recent district entry date of the student. Migrated from [Students.WY_mostRecentDistEntryDate]. |
| NameSuffix | 15.8.0 | Varchar2(10) | Student's suffix, if any. Migrated from [Students.name_suffix]. |
| CollegeCourseWork | 15.8.0 | Varchar2(1) | Indicates that the student has completed the required coursework. No longer used by the application. Migrated from [Students.wy_collegecoursework]. |
| ELL | 15.8.0 | Varchar2(1) | Indicates if the student is an English Language Learner under Title 3. Migrated from [Students.wy_ell]. |
| ELLMonitor | 15.8.0 | Varchar2(1) | ELL monitoring status of the student. Migrated from [Students.wy_ellmonitor]. |
| GiftedAndTalented | 15.8.0 | Varchar2(1) | Indicates if the student is in a Gifted/Talented program. Migrated from [Students.wy_giftedandtalented]. |
| GraduationAward | 15.8.0 | Varchar2(2) | Type of graduation award received by the student. No longer used by the application. Migrated from [Students.wy_graduationaward]. |
| GraduationDate | 15.8.0 | Date | Actual graduation date of the student. Migrated from [Students.wy_graduationdate]. |
| HalfDay | 15.8.0 | Varchar2(1) | Type of Kindergarten program (Full Day/Half Day) of the student. Migrated from [Students.wy_halfday]. |
| Homeless | 15.8.0 | Varchar2(1) | Indicates if the student is identified as homeless at any time during the current school year. Migrated from [Students.wy_homeless]. |
| IDEA | 15.8.0 | Varchar2(1) | Student's eligibility for an Individualized Education Plan (IEP) under IDEA. Migrated from [Students.wy_idea]. |
| Immigrant | 15.8.0 | Varchar2(1) | Indicates if the student is a immigrant. Migrated from [Students.wy_immigrant]. |
| LunchStatus | 15.8.0 | Varchar2(1) | Indicates the lunch status of the student. Migrated from [Students.wy_lunchstatus]. |
| Migrant | 15.8.0 | Varchar2(1) | Indicates if the student is a migrant. Migrated from [Students.wy_migrant]. |
| NationalScholarship | 15.8.0 | Varchar2(1) | Indicates if the student has a national scholarship. Migrated from [Students.wy_nationalscholarship]. |
| ProjectedGradYear | 15.8.0 | Varchar2(10) | Indicates the on-time graduation year. No longer used by the application. Migrated from [Students.wy_projectedgradyear]. |
| ScholarshipAward | 15.8.0 | Varchar2(25) | Indicates the level of Hathaway scholarship received by the student. Migrated from [Students.wy_scholarshipaward]. |
| Section504 | 15.8.0 | Varchar2(1) | Indicates if the student is a qualified individual under Section 504 of the Rehabilitation Act. Migrated from [Students.wy_section504]. |
| StateScholarship | 15.8.0 | Varchar2(1) | Indicates if the student has a state scholarship. Migrated from [Students.wy_statescholarship]. |
| StudentHomeSchooled | 15.8.0 | Varchar2(1) | Indicates if the student is home schooled. Migrated from [Students.wy_studenthomeschooled]. |
| StudentFosterCare | 17.6.0 | Varchar2(1) | Indicates if the student is in foster care |
| StudentMilitaryConnected | 17.6.0 | Varchar2(1) | Indicates if the student's parent or guardian is an active member of the U.S. Military Services. |
| Title1 | 15.8.0 | Varchar2(1) | Indicates if the student is in a Title 1 program. Migrated from [Students.wy_title1]. |
| TransEndorsement | 15.8.0 | Varchar2(15) | Transcript endorsement status of the student. Migrated from [Students.wy_transendorsement]. |
| HomelessUnaccompaniedYouth | 15.9.0 | Varchar2(1) | Indicates if the student is identified as a homeless unaccompanied youth at any time during the current school year. |
| VirtualEdStudent | 22.8.1 | Varchar2(1) | Indicates if the student has more than 50 percent of classes delivered as virtual or distance education |
| ResidentSchoolID | 23.3.2 | Varchar2(7) | Student's Resident School ID if this is different than the currently enrolled school. |