Skip to main content
Skip table of contents

S_WA_REN_X (ver 16.8.0)

This table is an extension of the [REENROLLMENTS] table.

Column Name

Version

Data Type

Description

ReEnrollmentsDCID

16.8.0

Number(10,0)

Foreign Key

CountyOfRes16.12.3Varchar2(10)Home County District Code. Migrated from [ReEnrollments.CountyOfRes].
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 [ReEnrollments.CTEAssessment].
DistrictEntryDate16.12.3DateDistrict Entry Date. Migrated from [ReEnrollments.DistrictEntryDate].
ExcludeFromCEDARS16.12.3Number(1,0)Exclude From CEDARS Reports Only indicator. Migrated from [ReEnrollments.WA_ExcludeFromCEDARS].
ForeignExchange16.12.3Varchar2(3)Student Exchange Status (B24). Migrated from [ReEnrollments.WA_ForeignExchange].
FosterCare16.12.3Varchar2(1)Is the Student in Foster Care? (invalid beginning 2013-2014). Migrated from [ReEnrollments.WA_FosterCare].
Gifted16.12.3Varchar2(1)Gifted/Highly Capable indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Gifted].
Grant21stCentury16.12.3Varchar2(1)21st Century Community Learning Program indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Grant21stCentury].
HomeBasedAncillaryService16.12.3Number(25,10)Home-Based Service Hours. Migrated from [ReEnrollments.WA_HomeBasedAncillaryService].
HomeBasedPartTime16.12.3Varchar2(3)Home-Based Student? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_HomeBasedPartTime].
HomeBasedServiceType16.12.3Varchar2(3)Home-Based Service Type? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_HomeBasedServiceType].
Homeless_code16.12.3Varchar2(1)Homeless indicator (For 2010-2011). Migrated from [ReEnrollments.homeless_code].
Immigrant16.12.3Varchar2(1)Immigrant indicator (invalid beginning 2014-2015). Migrated from [ReEnrollments.WA_Immigrant].
IndustryCert16.12.3Varchar2(1)Industry Certification indicator (no longer used in reporting). Migrated from [ReEnrollments.IndustryCert].
InitialUSAEnrollment16.12.3DateInitial USA School Enrollment (B32). Migrated from [ReEnrollments.WA_InitialUSAEnrollment].
KinderProgram16.12.3Varchar2(3)Kindergarten Program Enrollment (CEDARS). Migrated from [ReEnrollments.WA_KinderProgram].
KinderProgramHistoric16.12.3Varchar2(3)Kindergarten Program (07-08 CSRS report) (no longer used for state reporting). Migrated from [ReEnrollments.KinderProgram].
LAPMath16.12.3Varchar2(1)Learning Assistance Program (LAP) Math indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_LAPMath].
LAPReading16.12.3Varchar2(1)Learning Assistance Program (LAP) Reading indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_LAPReading].
Migrant16.12.3Varchar2(1)Services from Title I Migrant indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Migrant].
MilitaryFamilyIndicator16.8.0Varchar2(2)Indicates the student has a parent or guardian in the military, either active or reserves.
NumMonthsUSASch16.12.3Number(11,0)Number Months US Attendance in School (invalid beginning 2014-2015). Migrated from [ReEnrollments.WA_NumMonthsUSASch].
NumMonthsNonUSASch16.12.3Number(11,0)Number Months Non US Attendance in School. Migrated from [ReEnrollments.WA_NumMonthsNonUSASch].
P223ExclReason16.12.3Varchar2(15)P223 Exclusion Reason. Migrated from [ReEnrollments.WA_P223ExclReason].
PreSchool16.12.3Varchar2(1)Early Education Program indicator (Head Start, Early Start, or Pre-Kindergarten) (no longer used for state reporting). Migrated from [ReEnrollments.WA_PreSchool].
PrimarySchool16.12.3Varchar2(1)Student's Primary School indicator. Migrated from [ReEnrollments.WA_PrimarySchool].
PriNighttimeRes16.12.3Varchar2(3)Primary Nighttime Residence (beginning 2011-2012). Migrated from [ReEnrollments.WA_PriNighttimeRes].
PrivateSchoolPartTime16.12.3Varchar2(3)Private School Student? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_PrivateSchoolPartTime].
PrivateSchoolServiceType16.12.3Varchar2(3)Private School Service Type? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_PrivateSchoolServiceType].
PrivateAncillaryService16.12.3Number(25,10)Private School Service Hours. Migrated from [ReEnrollments.WA_PrivateAncillaryService].
Resubmit16.12.3Varchar2(1)Resubmit Student indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Resubmit].
RunningStart16.12.3Varchar2(3)Running Start (RS) Enrollment. Migrated from [ReEnrollments.RunningStart].
SchoolChoice16.12.3Number(11,0)School Choice Option. Migrated from [ReEnrollments.WA_SchoolChoice].
SchoolEntryDate16.12.3DateSchool Entry Date. Migrated from [ReEnrollments.SchoolEntryDate].
Section50416.12.3Varchar2(1)Accommodations from a Section 504 Plan indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Section504].
Socio_status16.12.3Varchar2(5)Free/Reduced-Price Meal Eligibility Status or Low Income. Migrated from [ReEnrollments.socio_status].
State_ExcludeFromReporting16.12.3Number(1,0)Exclude From All State Reports indicator. Migrated from [ReEnrollments.State_ExcludeFromReporting].
Supplemental16.12.3Varchar2(1)Supplemental Services indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Supplemental].
TASMath16.12.3Varchar2(1)Title I Targeted Assistance (TAS) Math indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_TASMath].
TASReading16.12.3Varchar2(1)Title I Targeted Assistance (TAS) Reading indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_TASReading].
VocationalCompleter16.12.3Varchar2(1)Vocational Completer indicator (no longer used in reporting). Migrated from [ReEnrollments.VocationalCompleter].
WASL_MathTeacher16.12.3Varchar2(40)WASL Mathematics Sort Order. Migrated from [ReEnrollments.WA_WASL_MathTeacher].
WASL_RWTeacher16.12.3Varchar2(40)WASL Reading Writing Sort Order. Migrated from [ReEnrollments.WA_WASL_RWTeacher].
WASL_ScienceTeacher16.12.3Varchar2(40)WASL Science Sort Order. Migrated from [ReEnrollments.WA_WASL_ScienceTeacher].
P223DistOfRes17.6.0Varchar2(10)Resident District Code to Report on P223. Only required if different from serving district. Migrated from [ReEnrollments.P223DistOfRes].
TechPrepCompleter17.6.0Varchar2(1)Tech Prep Completer indicator (no longer used in reporting). Migrated from [ReEnrollments.TechPrepCompleter].
ExcludeFromP22317.6.0BooleanExclude From P223 Reports Only indicator. Migrated from [Students.WA_ExcludeFromP223].
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.