Skip to main content
Skip table of contents

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

districtExitDate22.3.2.0Date

The month, day and year of the first day after the date a student last
attended school, graduated or became known officially to have left the district’s educational setting.

EconomicDisadvantaged20.3.2.0Number(1,0)An indicator that the student is economic disadvantaged.
ecProgram122.3.2.0Varchar2(4)Early Childhood Enrollment 1 program code. 
ecProgram222.3.2.0Varchar2(4)Early Childhood Enrollment 2 program code. 
ecProgram322.3.2.0Varchar2(4)Early Childhood Enrollment 3 program code. 
ecProgram422.3.2.0Varchar2(4)Early Childhood Enrollment 4 program code. 
ecProgram522.3.2.0Varchar2(4)Early Childhood Enrollment 5 program code. 
ecProgram1desc22.3.2.0Varchar2(100)Early Childhood Enrollment 1 program description. 
ecProgram2desc22.3.2.0Varchar2(100)Early Childhood Enrollment 2 program code description. 
ecProgram3desc22.3.2.0Varchar2(100)Early Childhood Enrollment 3 program code description. 
ecProgram4desc22.3.2.0Varchar2(100)Early Childhood Enrollment 4 program code description. 
ecProgram5desc22.3.2.0Varchar2(100)Early Childhood Enrollment 5 program code description. 
EndofTermStatus22.3.2.0Varchar2(10)End of Term Status. The nature of the student’s progress at the end of a given school term.
EnglishLearnerEligible20.3.2.0Number(1,0)An indicator that the student is LEP eligible.
EngLangInstProgramCode20.3.2.0Varchar2(10)The student's LEP instructional program code.
EngLangInstProgramDescr20.3.2.0Varchar2(100)The student's LEP instructional program description.
EntryTypeCode20.3.2.0Number(1,0)The student's entry code.
EntryTypeDescription20.3.2.0Varchar2(10)The student's entry code description.
ExitTypeCode20.3.2.0Varchar2(100)The student's exit code.
ExitTypeDescription20.3.2.0Varchar2(10)The student's exit code description.
FosterCare20.3.2.0Number(1,0)
An indicator that the student is in foster care.
FTE22.3.2.0Number(25,10)

The full-time equivalency for which the student receives
genderal educational programs and/or services from the operating district.

FTE5222.3.2.0Number(25,10)

The full-time equivalency for which the student is eligible for special
education programs or services provided only to students with disabilities who do not qualify for Section 53 membership.

FTE5322.3.2.0Number(25,10)

The full-time equivalency for which the student is eligible for special
education programs or services, provided only to students with disabilities who qualify for Section 53 membership under specific criteria.

GradeLevel20.3.2.0Number(1,0)
The student's grade level.
GradeDescription20.3.2.0Varchar2(100)The student's grade level description.
Homeless20.3.2.0Number(1,0)
An indicator that the student is homeless.
lepExitDate22.3.2.0Date

The month, day and year that the student was no longer
engaged in either an EL or an ESL program or service.

lepStateExitDate22.3.2.0Date

Upon completion of the MSDS EOY General collection,
the State of Michigan will automatically exit WIDA proficient students in grades K-12 with an EL Exit date of June 30 of the current school year.

lepLangPrimary22.3.2.0Varchar2(4)

The student’s primary or native language code.

lepLangHome22.3.2.0Varchar2(4)LEP language code spoken in the home.
lepLangHome222.3.2.0Varchar2(4)LEP additional language code spoken in the home.
lepLangHome322.3.2.0Varchar2(4)LEP additional language code spoken by adult in the home.
lepLangPrimarydesc22.3.2.0Varchar2(100)The student’s primary or native language.
lepLangHomedesc22.3.2.0Varchar2(100)LEP language spoken in the home.
lepLangHome2desc22.3.2.0Varchar2(100)LEP additional language spoken by adult in the home.
lepLangHomedesc322.3.2.0Varchar2(100)LEP additional language spoken by adult in the home.
Migrant20.3.2.0Number(1,0)
An indicator that the student is a migrant.
ppAlternateEd922020.3.2.0Number(1,0)
An indicator that the student is in alternative education.
ppAtRisk306020.3.2.0Number(1,0)
An indicator that the student is Section 31 at risk.
ppEarlyCollege350020.3.2.0Number(1,0)
An indicator that the student is early/middle college participant.
ppDevKinder923020.3.2.0Number(1,0)
An indicator that the student is in developmental kindergarten.
ppImmmigrant913020.3.2.0Number(1,0)
An indicator that the student is an immigrant.
ppInternational912020.3.2.0Number(1,0)
An indicator that the student is an international student.
ppMilitaryConn914020.3.2.0Number(1,0)
An indicator that the student is military-connected.
ppOutOfState911020.3.2.0Number(1,0)
An indicator that the student is an out-of-state resident.
ppPupilCountExcp922220.3.2.0Number(1,0)
An indicator that the student is section 6(4)(I)(ii) pupil count exception.
ppSeatTimeWaiver92220.3.2.0Number(1,0)
An indicator that the student is seat-time waiver participant.
ppSection504921020.3.2.0Number(1,0)
An indicator that the student is section 504.
ppTitle1601020.3.2.0Number(1,0)
An indicator that the student is Title I targeted assistance program.
PreviousSchoolDistrict20.3.2.0Varchar2(10)The four-digit LEA number of the previous school district.
PreviousSchoolInCEP20.3.2.0Number(1,0)
The previous school in CEP.
prevSchoolName22.3.2.0Varchar2(100)

The previously reporting entity (LEA, PSA or ISD school
district).

ReadDefIdentified22.3.2.0Number(1,0)

A reading deficiency was identified during the current school
year.

RefreshDate20.3.2.0DateThe date Snack-Pack data was last retrieved.
seExitDate22.3.2.0Date

The month, day and year of the first day after the date a
student last participated in special education programs or services because of the reason reported in Special Education Exit Reason.

StudentRecordAsOfDate20.3.2.0DateThe date student record was updated in MI data hub.
StudentSpecEdPlanDate20.3.2.0DateThe student's SPED Plan date.
StuSpecEdPriDisCode20.3.2.0Varchar2(4)The student's primary disability code.
StuSpecEdPriDisDescr20.3.2.0Varchar2(100)The student's primary disability description.
StuSpecEdPriProgServCode120.3.2.0Varchar2(4)The student's SPED program code.
StuSpecEdPriProgServName120.3.2.0Varchar2(100)The student's SPED program description.

StuSpecEdPriProgServCode2

20.3.2.0

Varchar2(4)

The student's SPED program code.

StuSpecEdPriProgServName220.3.2.0Varchar2(100)The student's SPED program description.
StuSpecEdPriProgServCode320.3.2.0Varchar2(4)The student's SPED program code.
StuSpecEdPriProgServName320.3.2.0Varchar2(100)The student's SPED program description.
TotalDaysAttended20.3.2.0Number(11,0)The total days the student attended.
TotalDaysPossibleAttendance20.3.2.0Number(11,0)
The total possible days of attendance.
TotalDaysRemoved22.3.2.0Number(25,10)

Sum of all primary, secondary and other days removed
for discipline, for the current school year.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.