S_WI_REN_X (ver 16.3.2)
This table is an extension of the [ReEnrollments] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ReEnorllmentsDCID | 16.3.2 | Number(19) | Foreign Key |
BilingualESL_Program | 19.7.1.0 | Varchar2(15) | ELL or Bilingual Program. |
BilingualESL_Monitored | 19.7.1.0 | Varchar2(1) | ELL or Bilingual Monitored description. |
Choice_Program_Participant | 16.3.2 | Number(1,0) | Choice Program Participant (1 = Yes, 0 = No). |
CompletedSchoolTerm | 16.10.1 | Varchar2(5) | Completed School Term (Y=Yes, N= No). |
CountDateStatus | 16.10.1 | Varchar2(5) | 3rd Friday of September Count Date Status. (P = Receiving Educational Services - Present on Count Date, A = Receiving Educational Services - Absent on Count Date, N =Not Receiving Educational Services and No Exit Date Prior to Count Date). |
Count_Date_Status_Jan | 22.9.3.0 | Varchar2(5) | 2nd Friday of January Count Date Status - Choice Students Only. (P = Receiving Educational Services - Present on Count Date, A = Receiving Educational Services - Absent on Count Date, N =Not Receiving Educational Services and No Exit Date Prior to Count Date). |
Count_Date_Status_May | 22.11.1.0 | Varchar2(5) | Obsolete - 23.8.2.0 - 1st Friday of May Count Date Status - Pilot Districts Only. (P = Receiving Educational Services - Present on Count Date, A = Receiving Educational Services - Absent on Count Date, N =Not Receiving Educational Services and No Exit Date Prior to Count Date). |
Credential | 16.10.1 | Varchar2(5) | High School Completion Credential. (R = Regular, E = High School Equivalency Diploma, C =Other High School Completion Credentials). |
DisabilityCode | 16.10.1 | Varchar2(6) | Primary disability for the student. |
EarlyInterveningServices | 16.10.1 | Varchar2(5) | Coordinated Early Intervening Services (Y=Yes, N= No). |
Economic_Status | 16.10.1 | Varchar2(5) | Economically Disadvantaged Status. |
Educational_Environment | 16.10.1 | Varchar2(5) | Educational Environment Classification. |
ELLServed- Obsolete | 16.10.1 | Varchar2(5) | ELL Served Obsolete for state reporting as of SR installer version 20.4.1.0 |
EnglishProfCode | 16.10.1 | Varchar2(5) | English Language Proficiency Classification. |
EnglishProfCodeIsCurYear | 20.4.1.0 | Number (1,0) | Indicates the student has taken the screen test in the current year. |
EnglishProfScore | 16.10.1 | Number(25,10) | Composite English Language Proficiency Level. |
ExitType | 16.10.1 | Varchar2(6) | Exit Type. |
ExpectedTransferDistrict | 16.10.1 | Varchar2(8) | Expected Transfer District. |
ExpectedTransferSchool | 16.10.1 | Varchar2(8) | Expected Transfer School. |
Homeless | 16.10.1 | Varchar2(5) | Homeless Status (Y=Yes, N= No, X=Parent Placed Private). |
Home_Schooled | 19.5.1.0 | Varchar2(1) | Obsolete - 24.2.1.0 - Home Schooled Home Schooled Indicator (Y=Yes, N=No) |
IEP_Begin_Date | 16.7.1 | Date | Not collected at this time. |
IEP_End_Date | 16.7.1 | Date | Not collected at this time. |
IEP_Review_Date | 16.7.1 | Date | Not collected at this time. |
ImmigrantT3 | 16.10.1 | Varchar2(5) | Immigrant (Title III) (Y=Yes, N= No, X=Parent Placed Private). |
LongTermUSStudent | 16.10.1 | Varchar2(5) | Long Term US Student Indicator (Y=Yes, N= No). |
Migrant | 16.10.1 | Varchar2(5) | Migrant (Y=Yes, N= No, X=Parent Placed Private). |
Neglected_and_Delinquent | 16.7.1 | Number(1,0) | Not collected at this time. |
OptionalLocalUse | 16.10.1 | Varchar2(50) | Optional Local Use. |
Parent_In_Military | 18.0.4 | String | A student characteristic indicating the student has a parent or guardian who is a member of the armed forces on active duty, serves full-time National Guard duty, or is a traditional member of the National Guard or Reserve. |
ParentPlacedPrivate | 16.10.1 | Varchar2(5) | Parent Placed Private (Y=Yes, N= No). |
Payer | 16.10.1 | Varchar2(10) | Payer. |
Program_Schedule | 16.10.1 | Varchar2(10) | Program Schedule. |
PromotionHigherGrade - Obsolete | 16.10.1 | Varchar2(5) | For students who have completed the school year, indicates if the student is being promoted to the next grade level. Obsolete for state reporting as of SR installer version 20.4.4.0 |
ReasonOutofDistrict | 16.10.1 | Varchar2(8) | Reason out of District. |
Removal_Date | 16.10.1 | Date | Removal Period Start Date. |
Repeat_Grade_Indicator | 20.4.3.0 | Varchar2(1) | For students who have completed the school year, indicates if the student needs to repeat the grade level or not. Replacing PromotionHigherGrade. |
ReturnRegularEd | 16.10.1 | Varchar2(5) | Special Ed Student Returning to Regular Education (Y=Yes, N= No). |
SchoolInResidenceDistrict | 16.10.1 | Varchar2(8) | School in District of Residence (student is non-resident AND Reason out of District is RES). |
SE_CountDate_Status | 16.3.2 | Varchar2(5) | October 1 Count Date Status. (P = Receiving Educational Services - Present on Count Date, A = Receiving Educational Services - Absent on Count Date, N = Not Receiving Educational Services and No Exit Date Prior to Count Date) |
SecondaryDisability | 16.10.1 | Varchar2(48) | Secondary Disability(s). |
Section504 | 16.10.1 | Varchar2(5) | Section 504 Indicator (Y=Yes, N= No, X=Parent Placed Private). |
State_Assessment_Type_SATA | 17.12.0 | Number (1,0) | Indicates if the student is required to take the alternate assessment. |
TestStatus | 16.10.1 | Varchar2(5) | Testing Status (no longer used 17.12.0, replaced by State_Assessment_Type_SATA). |
ThirdPartyAgency | 16.10.1 | Varchar2(8) | Third Party Agency Code. |
ThirdPartySchool | 16.10.1 | Varchar2(8) | Third Party School/Program Code. |
Visa_Type | 16.7.1 | Varchar2(5) | Visa Type. (F1 = Foreign Student Visa, M1 = Foreign Student pursuing vocational or non-academic studies Visa, H1 = Employment Visa, B1 =Business Visa, B2 = Tourist Visa, J1 = Exchange Scholar Visa, OV = Other Visa) |
WSLS_EnrollmentDate | 16.10.1 | Date | Student Enrollment Date in WSLS. |
YearsUSSchools | 16.10.1 | Varchar2(5) | Years in US Schools. |