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 |
| CountyOfRes | 16.12.3 | Varchar2(10) | Home County District Code. Migrated from [ReEnrollments.CountyOfRes]. |
| 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 [ReEnrollments.CTEAssessment]. |
| DistrictEntryDate | 16.12.3 | Date | District Entry Date. Migrated from [ReEnrollments.DistrictEntryDate]. |
| ExcludeFromCEDARS | 16.12.3 | Number(1,0) | Exclude From CEDARS Reports Only indicator. Migrated from [ReEnrollments.WA_ExcludeFromCEDARS]. |
| ForeignExchange | 16.12.3 | Varchar2(3) | Student Exchange Status (B24). Migrated from [ReEnrollments.WA_ForeignExchange]. |
| FosterCare | 16.12.3 | Varchar2(1) | Is the Student in Foster Care? (invalid beginning 2013-2014). Migrated from [ReEnrollments.WA_FosterCare]. |
| Gifted | 16.12.3 | Varchar2(1) | Gifted/Highly Capable indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Gifted]. |
| Grant21stCentury | 16.12.3 | Varchar2(1) | 21st Century Community Learning Program indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Grant21stCentury]. |
| HomeBasedAncillaryService | 16.12.3 | Number(25,10) | Home-Based Service Hours. Migrated from [ReEnrollments.WA_HomeBasedAncillaryService]. |
| HomeBasedPartTime | 16.12.3 | Varchar2(3) | Home-Based Student? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_HomeBasedPartTime]. |
| HomeBasedServiceType | 16.12.3 | Varchar2(3) | Home-Based Service Type? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_HomeBasedServiceType]. |
| Homeless_code | 16.12.3 | Varchar2(1) | Homeless indicator (For 2010-2011). Migrated from [ReEnrollments.homeless_code]. |
| Immigrant | 16.12.3 | Varchar2(1) | Immigrant indicator (invalid beginning 2014-2015). Migrated from [ReEnrollments.WA_Immigrant]. |
| IndustryCert | 16.12.3 | Varchar2(1) | Industry Certification indicator (no longer used in reporting). Migrated from [ReEnrollments.IndustryCert]. |
| InitialUSAEnrollment | 16.12.3 | Date | Initial USA School Enrollment (B32). Migrated from [ReEnrollments.WA_InitialUSAEnrollment]. |
| KinderProgram | 16.12.3 | Varchar2(3) | Kindergarten Program Enrollment (CEDARS). Migrated from [ReEnrollments.WA_KinderProgram]. |
| KinderProgramHistoric | 16.12.3 | Varchar2(3) | Kindergarten Program (07-08 CSRS report) (no longer used for state reporting). Migrated from [ReEnrollments.KinderProgram]. |
| LAPMath | 16.12.3 | Varchar2(1) | Learning Assistance Program (LAP) Math indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_LAPMath]. |
| LAPReading | 16.12.3 | Varchar2(1) | Learning Assistance Program (LAP) Reading indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_LAPReading]. |
| Migrant | 16.12.3 | Varchar2(1) | Services from Title I Migrant indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Migrant]. |
| MilitaryFamilyIndicator | 16.8.0 | Varchar2(2) | Indicates the student has a parent or guardian in the military, either active or reserves. |
| NumMonthsUSASch | 16.12.3 | Number(11,0) | Number Months US Attendance in School (invalid beginning 2014-2015). Migrated from [ReEnrollments.WA_NumMonthsUSASch]. |
| NumMonthsNonUSASch | 16.12.3 | Number(11,0) | Number Months Non US Attendance in School. Migrated from [ReEnrollments.WA_NumMonthsNonUSASch]. |
| P223ExclReason | 16.12.3 | Varchar2(15) | P223 Exclusion Reason. Migrated from [ReEnrollments.WA_P223ExclReason]. |
| 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 [ReEnrollments.WA_PreSchool]. |
| PrimarySchool | 16.12.3 | Varchar2(1) | Student's Primary School indicator. Migrated from [ReEnrollments.WA_PrimarySchool]. |
| PriNighttimeRes | 16.12.3 | Varchar2(3) | Primary Nighttime Residence (beginning 2011-2012). Migrated from [ReEnrollments.WA_PriNighttimeRes]. |
| PrivateSchoolPartTime | 16.12.3 | Varchar2(3) | Private School Student? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_PrivateSchoolPartTime]. |
| PrivateSchoolServiceType | 16.12.3 | Varchar2(3) | Private School Service Type? (Part-Time Status and Services). Migrated from [ReEnrollments.WA_PrivateSchoolServiceType]. |
| PrivateAncillaryService | 16.12.3 | Number(25,10) | Private School Service Hours. Migrated from [ReEnrollments.WA_PrivateAncillaryService]. |
| Resubmit | 16.12.3 | Varchar2(1) | Resubmit Student indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Resubmit]. |
| RunningStart | 16.12.3 | Varchar2(3) | Running Start (RS) Enrollment. Migrated from [ReEnrollments.RunningStart]. |
| SchoolChoice | 16.12.3 | Number(11,0) | School Choice Option. Migrated from [ReEnrollments.WA_SchoolChoice]. |
| SchoolEntryDate | 16.12.3 | Date | School Entry Date. Migrated from [ReEnrollments.SchoolEntryDate]. |
| Section504 | 16.12.3 | Varchar2(1) | Accommodations from a Section 504 Plan indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Section504]. |
| Socio_status | 16.12.3 | Varchar2(5) | Free/Reduced-Price Meal Eligibility Status or Low Income. Migrated from [ReEnrollments.socio_status]. |
| State_ExcludeFromReporting | 16.12.3 | Number(1,0) | Exclude From All State Reports indicator. Migrated from [ReEnrollments.State_ExcludeFromReporting]. |
| Supplemental | 16.12.3 | Varchar2(1) | Supplemental Services indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_Supplemental]. |
| TASMath | 16.12.3 | Varchar2(1) | Title I Targeted Assistance (TAS) Math indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_TASMath]. |
| TASReading | 16.12.3 | Varchar2(1) | Title I Targeted Assistance (TAS) Reading indicator (no longer used for state reporting). Migrated from [ReEnrollments.WA_TASReading]. |
| VocationalCompleter | 16.12.3 | Varchar2(1) | Vocational Completer indicator (no longer used in reporting). Migrated from [ReEnrollments.VocationalCompleter]. |
| WASL_MathTeacher | 16.12.3 | Varchar2(40) | WASL Mathematics Sort Order. Migrated from [ReEnrollments.WA_WASL_MathTeacher]. |
| WASL_RWTeacher | 16.12.3 | Varchar2(40) | WASL Reading Writing Sort Order. Migrated from [ReEnrollments.WA_WASL_RWTeacher]. |
| WASL_ScienceTeacher | 16.12.3 | Varchar2(40) | WASL Science Sort Order. Migrated from [ReEnrollments.WA_WASL_ScienceTeacher]. |
| P223DistOfRes | 17.6.0 | Varchar2(10) | Resident District Code to Report on P223. Only required if different from serving district. Migrated from [ReEnrollments.P223DistOfRes]. |
| TechPrepCompleter | 17.6.0 | Varchar2(1) | Tech Prep Completer indicator (no longer used in reporting). Migrated from [ReEnrollments.TechPrepCompleter]. |
| ExcludeFromP223 | 17.6.0 | Boolean | Exclude From P223 Reports Only indicator. Migrated from [Students.WA_ExcludeFromP223]. |
| ConfirmedTransfer | 18.5.0 | Varchar2(2) | Confirmed Transfer In. |