S_WI_STU_X (ver 14.6.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 14.6.0 | Number(10,0) | Primary Key. |
Address_Collection_Opt_In | 20.6.2.0 | Varchar2(1) | Address collection opt-in. |
BilingualESL_Monitored | 19.7.1.0 | Varchar2(1) | ELL or Bilingual Monitored description. |
BilingualESL_Program | 19.7.1.0 | Varchar2(15) | ELL or Bilingual Program. |
Birth_Country | 16.7.0 | Varchar2(60) | Country of Birth if born outside the US or Puerto Rico |
Born_Outside_US - Obsolete | 16.7.0 | Number(1,0) | Born outside the US or Puerto Rico. 1 = Yes, 0 = No. Obsolete for State Reporting as of SR installer version 19.5.1.0. |
Choice_Program_Participant | 15.11.1 | 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. (no longer used 17.10.0) |
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.(no longer used 17.10.0) |
ELLServed- Obsolete | 16.10.1 | Varchar2(5) | 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 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). |
ISES_Disability_Change_Date | 14.6.0 | Date | Date student's Primary Disability changed. (no longer used 17.10.0) |
ISES_EcoStatus_Change_Date | 14.6.0 | Date | Date student's Economic Status changed. |
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. |
Primary_Service_Provider | 16.12.3 | Varchar2(1) | Primary Service Provider. (Y = Yes, N or null = No.) |
Program_Schedule | 16.10.1 | Varchar2(10) | Program Schedule. |
PromotionHigherGrade - Obsolete | 16.10.1 | Varchar2(5) | Obsolete for state reporting as of SR installer version 20.4.4.0 |
ReasonOutofDistrict | 16.10.1 | Varchar2(8) | Reason out of District. |
Repeat_Grade_Indicator | 20.4.3.0 | Varchar2(2) | For students who have completed the school year, indicates if the student needs to repeat the grade level or not. |
ReturnRegularEd | 16.10.1 | Varchar2(5) | Special Ed Student Returning to Regular Education.(no longer used 17.10.0) |
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).(no longer used 17.10.0) |
Section504 | 16.10.1 | Varchar2(5) | Section 504 Indicator (Y=Yes, N= No, X=Parent Placed Private). |
State_Assessment_Type_SATA - Obsolete | 17.12.0 | Number (1,0) | Indicates if the student is required to take the alternate assessment. Obsolete for State Reporting as of SR installer version 21.9.2.0. |
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. |
Tribal_Affiliation_1 | 21.6.2 | Varchar2(5) | Indicates the student's Tribal Affiliation (maximum of three). |
Tribal_Affiliation_2 | 21.6.2 | Varchar2(5) | Not sent to WISEdata beginning 2022-23. Indicates the student's Tribal Affiliation (maximum of three). |
Tribal_Affiliation_3 | 21.6.2 | Varchar2(5) | Not sent to WISEdata beginning 2022-23. Indicates the student's Tribal Affiliation (maximum of three). |
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). |
YearsUSSchools | 16.10.1 | Varchar2(5) | Years in US Schools. |
WSLS_EnrollmentDate | 16.10.1 | Date | Student Enrollment Date in WSLS. |