S_STU_SNACK_X (ver 20.3.2.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
---|---|---|---|
ReEnrollmentsDCID | 20.3.2.0 | Number(10,0) | Primary Key |
districtExitDate | 22.3.2.0 | Date | The month, day and year of the first day after the date a student last |
EconomicDisadvantaged | 20.3.2.0 | Number(1,0) | An indicator that the student is economic disadvantaged. |
ecProgram1 | 22.3.2.0 | Varchar2(4) | Early Childhood Enrollment 1 program code. |
ecProgram2 | 22.3.2.0 | Varchar2(4) | Early Childhood Enrollment 2 program code. |
ecProgram3 | 22.3.2.0 | Varchar2(4) | Early Childhood Enrollment 3 program code. |
ecProgram4 | 22.3.2.0 | Varchar2(4) | Early Childhood Enrollment 4 program code. |
ecProgram5 | 22.3.2.0 | Varchar2(4) | Early Childhood Enrollment 5 program code. |
ecProgram1desc | 22.3.2.0 | Varchar2(100) | Early Childhood Enrollment 1 program description. |
ecProgram2desc | 22.3.2.0 | Varchar2(100) | Early Childhood Enrollment 2 program code description. |
ecProgram3desc | 22.3.2.0 | Varchar2(100) | Early Childhood Enrollment 3 program code description. |
ecProgram4desc | 22.3.2.0 | Varchar2(100) | Early Childhood Enrollment 4 program code description. |
ecProgram5desc | 22.3.2.0 | Varchar2(100) | Early Childhood Enrollment 5 program code description. |
EndofTermStatus | 22.3.2.0 | Varchar2(10) | End of Term Status. The nature of the student’s progress at the end of a given school term. |
EnglishLearnerEligible | 20.3.2.0 | Number(1,0) | An indicator that the student is LEP eligible. |
EngLangInstProgramCode | 20.3.2.0 | Varchar2(10) | The student's LEP instructional program code. |
EngLangInstProgramDescr | 20.3.2.0 | Varchar2(100) | The student's LEP instructional program description. |
EntryTypeCode | 20.3.2.0 | Number(1,0) | The student's entry code. |
EntryTypeDescription | 20.3.2.0 | Varchar2(10) | The student's entry code description. |
ExitTypeCode | 20.3.2.0 | Varchar2(100) | The student's exit code. |
ExitTypeDescription | 20.3.2.0 | Varchar2(10) | The student's exit code description. |
FosterCare | 20.3.2.0 | Number(1,0) | An indicator that the student is in foster care. |
FTE | 22.3.2.0 | Number(25,10) | The full-time equivalency for which the student receives |
FTE52 | 22.3.2.0 | Number(25,10) | The full-time equivalency for which the student is eligible for special |
FTE53 | 22.3.2.0 | Number(25,10) | The full-time equivalency for which the student is eligible for special |
GradeLevel | 20.3.2.0 | Number(1,0) | The student's grade level. |
GradeDescription | 20.3.2.0 | Varchar2(100) | The student's grade level description. |
Homeless | 20.3.2.0 | Number(1,0) | An indicator that the student is homeless. |
lepExitDate | 22.3.2.0 | Date | The month, day and year that the student was no longer |
lepStateExitDate | 22.3.2.0 | Date | Upon completion of the MSDS EOY General collection, |
lepLangPrimary | 22.3.2.0 | Varchar2(4) | The student’s primary or native language code. |
lepLangHome | 22.3.2.0 | Varchar2(4) | LEP language code spoken in the home. |
lepLangHome2 | 22.3.2.0 | Varchar2(4) | LEP additional language code spoken in the home. |
lepLangHome3 | 22.3.2.0 | Varchar2(4) | LEP additional language code spoken by adult in the home. |
lepLangPrimarydesc | 22.3.2.0 | Varchar2(100) | The student’s primary or native language. |
lepLangHomedesc | 22.3.2.0 | Varchar2(100) | LEP language spoken in the home. |
lepLangHome2desc | 22.3.2.0 | Varchar2(100) | LEP additional language spoken by adult in the home. |
lepLangHomedesc3 | 22.3.2.0 | Varchar2(100) | LEP additional language spoken by adult in the home. |
Migrant | 20.3.2.0 | Number(1,0) | An indicator that the student is a migrant. |
ppAlternateEd9220 | 20.3.2.0 | Number(1,0) | An indicator that the student is in alternative education. |
ppAtRisk3060 | 20.3.2.0 | Number(1,0) | An indicator that the student is Section 31 at risk. |
ppEarlyCollege3500 | 20.3.2.0 | Number(1,0) | An indicator that the student is early/middle college participant. |
ppDevKinder9230 | 20.3.2.0 | Number(1,0) | An indicator that the student is in developmental kindergarten. |
ppImmmigrant9130 | 20.3.2.0 | Number(1,0) | An indicator that the student is an immigrant. |
ppInternational9120 | 20.3.2.0 | Number(1,0) | An indicator that the student is an international student. |
ppMilitaryConn9140 | 20.3.2.0 | Number(1,0) | An indicator that the student is military-connected. |
ppOutOfState9110 | 20.3.2.0 | Number(1,0) | An indicator that the student is an out-of-state resident. |
ppPupilCountExcp9222 | 20.3.2.0 | Number(1,0) | An indicator that the student is section 6(4)(I)(ii) pupil count exception. |
ppSeatTimeWaiver922 | 20.3.2.0 | Number(1,0) | An indicator that the student is seat-time waiver participant. |
ppSection5049210 | 20.3.2.0 | Number(1,0) | An indicator that the student is section 504. |
ppTitle16010 | 20.3.2.0 | Number(1,0) | An indicator that the student is Title I targeted assistance program. |
PreviousSchoolDistrict | 20.3.2.0 | Varchar2(10) | The four-digit LEA number of the previous school district. |
PreviousSchoolInCEP | 20.3.2.0 | Number(1,0) | The previous school in CEP. |
prevSchoolName | 22.3.2.0 | Varchar2(100) | The previously reporting entity (LEA, PSA or ISD school |
ReadDefIdentified | 22.3.2.0 | Number(1,0) | A reading deficiency was identified during the current school |
RefreshDate | 20.3.2.0 | Date | The date Snack-Pack data was last retrieved. |
seExitDate | 22.3.2.0 | Date | The month, day and year of the first day after the date a |
StudentRecordAsOfDate | 20.3.2.0 | Date | The date student record was updated in MI data hub. |
StudentSpecEdPlanDate | 20.3.2.0 | Date | The student's SPED Plan date. |
StuSpecEdPriDisCode | 20.3.2.0 | Varchar2(4) | The student's primary disability code. |
StuSpecEdPriDisDescr | 20.3.2.0 | Varchar2(100) | The student's primary disability description. |
StuSpecEdPriProgServCode1 | 20.3.2.0 | Varchar2(4) | The student's SPED program code. |
StuSpecEdPriProgServName1 | 20.3.2.0 | Varchar2(100) | The student's SPED program description. |
StuSpecEdPriProgServCode2 | 20.3.2.0 | Varchar2(4) | The student's SPED program code. |
StuSpecEdPriProgServName2 | 20.3.2.0 | Varchar2(100) | The student's SPED program description. |
StuSpecEdPriProgServCode3 | 20.3.2.0 | Varchar2(4) | The student's SPED program code. |
StuSpecEdPriProgServName3 | 20.3.2.0 | Varchar2(100) | The student's SPED program description. |
TotalDaysAttended | 20.3.2.0 | Number(11,0) | The total days the student attended. |
TotalDaysPossibleAttendance | 20.3.2.0 | Number(11,0) | The total possible days of attendance. |
TotalDaysRemoved | 22.3.2.0 | Number(25,10) | Sum of all primary, secondary and other days removed |