Skip to main content
Skip table of contents

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

ELAStandard16.2.2Varchar2(10)Indicates student has met or not met the English Language Arts Standard. Used in Transcript 2008 and beyond report.
HigherEdPlacementAgreement16.2.2Varchar2(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.

MilitaryFamilyIndicator16.8.0Varchar2(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.

ExcludeFromCEDARS16.12.3BooleanExclude From CEDARS Reports Only indicator. Migrated from [Students.WA_ExcludeFromCEDARS].
ExcludeFromP22316.12.3BooleanExclude From P223 Reports Only indicator. Migrated from [Students.WA_ExcludeFromP223].
P223ExclReason16.12.3Varchar2(15)P223 Exclusion Reason. Migrated from [Students.WA_P223ExclReason].
SchoolChoice16.12.3Number(11,0)School Choice Option. Migrated from [Students.WA_SchoolChoice].
PrimarySchool16.12.3Varchar2(1)Student's Primary School indicator. Migrated from [Students.WA_PrimarySchool].
PriNighttimeRes16.12.3Varchar2(3)Primary Nighttime Residence (beginning 2011-2012). Migrated from [Students.WA_PriNighttimeRes].
ForeignExchange16.12.3Varchar2(3)Student Exchange Status (B24). Migrated from [Students.WA_ForeignExchange].
FosterCare16.12.3Varchar2(1)Is the Student in Foster Care? (invalid beginning 2013-2014). Migrated from [Students.WA_FosterCare].
CountyOfRes16.12.3Varchar2(10)Home County District Code. Migrated from [Students.CountyOfRes].
P223DistOfRes16.12.3Varchar2(10)Resident District Code to Report on P223. Only required if different from serving district. Migrated from [Students.P223DistOfRes].
KinderProgram16.12.3Varchar2(3)Kindergarten Program Enrollment (CEDARS). Migrated from [Students.WA_KinderProgram].
Immigrant16.12.3Varchar2(1)Immigrant indicator (invalid beginning 2014-2015). Migrated from [Students.WA_Immigrant].
InitialUSAEnrollment16.12.3DateInitial USA School Enrollment (B32). Migrated from [Students.WA_InitialUSAEnrollment].
NumMonthsUSASch16.12.3Number(11,0)Number Months US Attendance in School (invalid beginning 2014-2015). Migrated from [Students.WA_NumMonthsUSASch].
NumMonthsNonUSASch16.12.3Number(11,0)Number Months Non US Attendance in School. Migrated from [Students.WA_NumMonthsNonUSASch].
RunningStart16.12.3Varchar2(3)Running Start (RS) Enrollment. Migrated from [Students.RunningStart].
PrivateSchoolPartTime16.12.3Varchar2(3)Private School Student? (Part-Time Status and Services). Migrated from [Students.WA_PrivateSchoolPartTime].
PrivateSchoolServiceType16.12.3Varchar2(3)Private School Service Type? (Part-Time Status and Services). Migrated from [Students.WA_PrivateSchoolServiceType].
HomeBasedPartTime16.12.3Varchar2(3)Home-Based Student? (Part-Time Status and Services). Migrated from [Students.WA_HomeBasedPartTime].
HomeBasedServiceType16.12.3Varchar2(3)Home-Based Service Type? (Part-Time Status and Services). Migrated from [Students.WA_HomeBasedServiceType].
WASL_MathTeacher16.12.3Varchar2(40)WASL Mathematics Sort Order. Migrated from [Students.WA_WASL_MathTeacher].
WASL_RWTeacher16.12.3Varchar2(40)WASL Reading Writing Sort Order. Migrated from [Students.WA_WASL_RWTeacher].
WASL_ScienceTeacher16.12.3Varchar2(40)WASL Science Sort Order. Migrated from [Students.WA_WASL_ScienceTeacher].
TechPrepCompleter16.12.3Varchar2(1)Tech Prep Completer indicator (no longer used in reporting). Migrated from [Students.TechPrepCompleter].
CTEAssessment16.12.3Varchar2(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].
VocationalCompleter16.12.3Varchar2(1)Vocational Completer indicator (no longer used in reporting). Migrated from [Students.VocationalCompleter].
IndustryCert16.12.3Varchar2(1)Industry Certification indicator (no longer used in reporting). Migrated from [Students.IndustryCert].
KinderProgramHistoric16.12.3Varchar2(3)Kindergarten Program (07-08 CSRS report) (no longer used for state reporting). Migrated from [Students.KinderProgram].
Resubmit16.12.3Varchar2(1)Resubmit Student indicator (no longer used for state reporting). Migrated from [Students.WA_Resubmit].
PreSchool16.12.3Varchar2(1)Early Education Program indicator (Head Start, Early Start, or Pre-Kindergarten) (no longer used for state reporting). Migrated from [Students.WA_PreSchool].
LAPReading16.12.3Varchar2(1)Learning Assistance Program (LAP) Reading indicator (no longer used for state reporting). Migrated from [Students.WA_LAPReading].
LAPMath16.12.3Varchar2(1)Learning Assistance Program (LAP) Math indicator (no longer used for state reporting). Migrated from [Students.WA_LAPMath].
TASReading16.12.3Varchar2(1)Title I Targeted Assistance (TAS) Reading indicator (no longer used for state reporting). Migrated from [Students.WA_TASReading].
TASMath16.12.3Varchar2(1)Title I Targeted Assistance (TAS) Math indicator (no longer used for state reporting). Migrated from [Students.WA_TASMath].
Migrant16.12.3Varchar2(1)Services from Title I Migrant indicator (no longer used for state reporting). Migrated from [Students.WA_Migrant].
Gifted16.12.3Varchar2(1)Gifted/Highly Capable indicator (no longer used for state reporting). Migrated from [Students.WA_Gifted].
Section50416.12.3Varchar2(1)Accommodations from a Section 504 Plan indicator (no longer used for state reporting). Migrated from [Students.WA_Section504].
Grant21stCentury16.12.3Varchar2(1)21st Century Community Learning Program indicator (no longer used for state reporting). Migrated from [Students.WA_Grant21stCentury].
Supplemental16.12.3Varchar2(1)Supplemental Services indicator (no longer used for state reporting). Migrated from [Students.WA_Supplemental].
HomeBasedAncillaryService16.12.3Number(25,10)Home-Based Service Hours. Migrated from [Students.WA_HomeBasedAncillaryService].
PrivateAncillaryService16.12.3Number(25,10)Private School Service Hours. Migrated from [Students.WA_PrivateAncillaryService].
Socio_status16.12.3Varchar2(5)Free/Reduced-Price Meal Eligibility Status or Low Income. Migrated from [Students.socio_status].
IEPIsCurrent16.12.3Varchar2(3)IEP is current indicator (no longer used for state reporting). Migrated from [Students.IEPIsCurrent].
ReceivingService16.12.3Varchar2(3)Student is receiving service indicator (no longer used for state reporting). Migrated from [Students.ReceivingService].
BirthCountry16.12.3Varchar2(5)Birth Country. Migrated from [Students.WA_BirthCountry].
LanguageAtHome16.12.3Varchar2(5)Language Spoken At Home (Primary language the student speaks at home). Migrated from [Students.WA_LanguageAtHome].
EthnicityCollectionMethod18.3.0Varchar2(2)Ethnicity Collection Method.
RaceCollectionMethod18.3.0Varchar2(2)Race Collection Method.
ConfirmedTransfer18.5.0Varchar2(2)Confirmed Transfer In.

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.