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. |