S_WA_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) | Foreign Key |
| ELAStandard | 16.2.2 | Varchar2(10) | Indicates student has met or not met the English Language Arts Standard. Used in Transcript 2008 and beyond report. |
| HigherEdPlacementAgreement | 16.2.2 | Varchar2(20) | Indicates student received level 3 or level 4 on Smarter Balanced Assessment. Used in Transcript 2008 and beyond report. |
IsUngraded | 14.11.0 | Boolean | Count Student as Ungraded in CRDC. |
LEPQualified | 14.11.0 | Boolean | Count Student as LEP Qualified in CRDC. |
| MilitaryFamilyIndicator | 16.8.0 | Varchar2(2) | Indicates the student has a parent or guardian in the military, either active or reserves. |
SealOfBiliteracy | 14.10.0 | Boolean | Indicates student has earned Washington State Seal of Biliteracy. |
| ExcludeFromCEDARS | 16.12.3 | Boolean | Exclude From CEDARS Reports Only indicator. Migrated from [Students.WA_ExcludeFromCEDARS]. |
| ExcludeFromP223 | 16.12.3 | Boolean | Exclude From P223 Reports Only indicator. Migrated from [Students.WA_ExcludeFromP223]. |
| P223ExclReason | 16.12.3 | Varchar2(15) | P223 Exclusion Reason. Migrated from [Students.WA_P223ExclReason]. |
| SchoolChoice | 16.12.3 | Number(11,0) | School Choice Option. Migrated from [Students.WA_SchoolChoice]. |
| PrimarySchool | 16.12.3 | Varchar2(1) | Student's Primary School indicator. Migrated from [Students.WA_PrimarySchool]. |
| PriNighttimeRes | 16.12.3 | Varchar2(3) | Primary Nighttime Residence (beginning 2011-2012). Migrated from [Students.WA_PriNighttimeRes]. |
| ForeignExchange | 16.12.3 | Varchar2(3) | Student Exchange Status (B24). Migrated from [Students.WA_ForeignExchange]. |
| FosterCare | 16.12.3 | Varchar2(1) | Is the Student in Foster Care? (invalid beginning 2013-2014). Migrated from [Students.WA_FosterCare]. |
| CountyOfRes | 16.12.3 | Varchar2(10) | Home County District Code. Migrated from [Students.CountyOfRes]. |
| P223DistOfRes | 16.12.3 | Varchar2(10) | Resident District Code to Report on P223. Only required if different from serving district. Migrated from [Students.P223DistOfRes]. |
| KinderProgram | 16.12.3 | Varchar2(3) | Kindergarten Program Enrollment (CEDARS). Migrated from [Students.WA_KinderProgram]. |
| Immigrant | 16.12.3 | Varchar2(1) | Immigrant indicator (invalid beginning 2014-2015). Migrated from [Students.WA_Immigrant]. |
| InitialUSAEnrollment | 16.12.3 | Date | Initial USA School Enrollment (B32). Migrated from [Students.WA_InitialUSAEnrollment]. |
| NumMonthsUSASch | 16.12.3 | Number(11,0) | Number Months US Attendance in School (invalid beginning 2014-2015). Migrated from [Students.WA_NumMonthsUSASch]. |
| NumMonthsNonUSASch | 16.12.3 | Number(11,0) | Number Months Non US Attendance in School. Migrated from [Students.WA_NumMonthsNonUSASch]. |
| RunningStart | 16.12.3 | Varchar2(3) | Running Start (RS) Enrollment. Migrated from [Students.RunningStart]. |
| PrivateSchoolPartTime | 16.12.3 | Varchar2(3) | Private School Student? (Part-Time Status and Services). Migrated from [Students.WA_PrivateSchoolPartTime]. |
| PrivateSchoolServiceType | 16.12.3 | Varchar2(3) | Private School Service Type? (Part-Time Status and Services). Migrated from [Students.WA_PrivateSchoolServiceType]. |
| HomeBasedPartTime | 16.12.3 | Varchar2(3) | Home-Based Student? (Part-Time Status and Services). Migrated from [Students.WA_HomeBasedPartTime]. |
| HomeBasedServiceType | 16.12.3 | Varchar2(3) | Home-Based Service Type? (Part-Time Status and Services). Migrated from [Students.WA_HomeBasedServiceType]. |
| WASL_MathTeacher | 16.12.3 | Varchar2(40) | WASL Mathematics Sort Order. Migrated from [Students.WA_WASL_MathTeacher]. |
| WASL_RWTeacher | 16.12.3 | Varchar2(40) | WASL Reading Writing Sort Order. Migrated from [Students.WA_WASL_RWTeacher]. |
| WASL_ScienceTeacher | 16.12.3 | Varchar2(40) | WASL Science Sort Order. Migrated from [Students.WA_WASL_ScienceTeacher]. |
| TechPrepCompleter | 16.12.3 | Varchar2(1) | Tech Prep Completer indicator (no longer used in reporting). Migrated from [Students.TechPrepCompleter]. |
| CTEAssessment | 16.12.3 | Varchar2(2) | Did the Student Take or Pass a State or Nationally Recognized Assessment Test of Technical Skill and Knowledge? (no longer used in reporting). Migrated from [Students.CTEAssessment]. |
| VocationalCompleter | 16.12.3 | Varchar2(1) | Vocational Completer indicator (no longer used in reporting). Migrated from [Students.VocationalCompleter]. |
| IndustryCert | 16.12.3 | Varchar2(1) | Industry Certification indicator (no longer used in reporting). Migrated from [Students.IndustryCert]. |
| KinderProgramHistoric | 16.12.3 | Varchar2(3) | Kindergarten Program (07-08 CSRS report) (no longer used for state reporting). Migrated from [Students.KinderProgram]. |
| Resubmit | 16.12.3 | Varchar2(1) | Resubmit Student indicator (no longer used for state reporting). Migrated from [Students.WA_Resubmit]. |
| PreSchool | 16.12.3 | Varchar2(1) | Early Education Program indicator (Head Start, Early Start, or Pre-Kindergarten) (no longer used for state reporting). Migrated from [Students.WA_PreSchool]. |
| LAPReading | 16.12.3 | Varchar2(1) | Learning Assistance Program (LAP) Reading indicator (no longer used for state reporting). Migrated from [Students.WA_LAPReading]. |
| LAPMath | 16.12.3 | Varchar2(1) | Learning Assistance Program (LAP) Math indicator (no longer used for state reporting). Migrated from [Students.WA_LAPMath]. |
| TASReading | 16.12.3 | Varchar2(1) | Title I Targeted Assistance (TAS) Reading indicator (no longer used for state reporting). Migrated from [Students.WA_TASReading]. |
| TASMath | 16.12.3 | Varchar2(1) | Title I Targeted Assistance (TAS) Math indicator (no longer used for state reporting). Migrated from [Students.WA_TASMath]. |
| Migrant | 16.12.3 | Varchar2(1) | Services from Title I Migrant indicator (no longer used for state reporting). Migrated from [Students.WA_Migrant]. |
| Gifted | 16.12.3 | Varchar2(1) | Gifted/Highly Capable indicator (no longer used for state reporting). Migrated from [Students.WA_Gifted]. |
| Section504 | 16.12.3 | Varchar2(1) | Accommodations from a Section 504 Plan indicator (no longer used for state reporting). Migrated from [Students.WA_Section504]. |
| Grant21stCentury | 16.12.3 | Varchar2(1) | 21st Century Community Learning Program indicator (no longer used for state reporting). Migrated from [Students.WA_Grant21stCentury]. |
| Supplemental | 16.12.3 | Varchar2(1) | Supplemental Services indicator (no longer used for state reporting). Migrated from [Students.WA_Supplemental]. |
| HomeBasedAncillaryService | 16.12.3 | Number(25,10) | Home-Based Service Hours. Migrated from [Students.WA_HomeBasedAncillaryService]. |
| PrivateAncillaryService | 16.12.3 | Number(25,10) | Private School Service Hours. Migrated from [Students.WA_PrivateAncillaryService]. |
| Socio_status | 16.12.3 | Varchar2(5) | Free/Reduced-Price Meal Eligibility Status or Low Income. Migrated from [Students.socio_status]. |
| IEPIsCurrent | 16.12.3 | Varchar2(3) | IEP is current indicator (no longer used for state reporting). Migrated from [Students.IEPIsCurrent]. |
| ReceivingService | 16.12.3 | Varchar2(3) | Student is receiving service indicator (no longer used for state reporting). Migrated from [Students.ReceivingService]. |
| BirthCountry | 16.12.3 | Varchar2(5) | Birth Country. Migrated from [Students.WA_BirthCountry]. |
| LanguageAtHome | 16.12.3 | Varchar2(5) | Language Spoken At Home (Primary language the student speaks at home). Migrated from [Students.WA_LanguageAtHome]. |
| EthnicityCollectionMethod | 18.3.0 | Varchar2(2) | Ethnicity Collection Method. |
| RaceCollectionMethod | 18.3.0 | Varchar2(2) | Race Collection Method. |
| ConfirmedTransfer | 18.5.0 | Varchar2(2) | Confirmed Transfer In. |