S_ME_REN_X (ver 17.2.0)
This table is an extension of the [ReEnrollments] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ReenrollmentsDCID | 17.2.0 | Number(10,0) | Foreign Key to the ReEnrollments table. |
AlternateAssessment | 17.7.0 | VarChar2(1) | Indicates whether or not the student will be taking an alternate assessment for state assessment purposes. |
AlternativeEducationflag_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is an alternative education program student. |
BilingualEducation_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a bilingual student. |
EconmicStatusEligibEndDate | 17.7.0 | Date | The date the student is no longer eligible for a school lunch program. |
EconmicStatusEligibStartDate | 17.7.0 | Date | The date the student became eligible for a school lunch program. |
EnglishLearnerStartDate | 17.7.0 | Date | The start date for the student's status as an English Learner. |
EnrollmentEffectiveDate | 17.7.0 | Date | The date of change in status for Resident Town Code, Resident SAU ID, or Fiscal Responsibility Code. |
EnrollmentExitType | 17.7.0 | VarChar2(5) | The reason the student exited the school. |
EnrollmentStartStatus | 17.7.0 | VarChar2(5) | The reason the student started in the school. |
EnrollmentType | 17.7.0 | VarChar2(1) | The student's school enrollment type: Primary or Secondary |
EnrollmentTypeCode | 17.2.0 | VarChar2(1) | Codes indicating the student’s type of enrollment in the school. Migrated From: [ReEnrollments]ME_EnrollmentTypeCode |
ExitStatusCode | 17.2.0 | VarChar2(2) | Codes indicating the student’s exit status. Migrated From: [ReEnrollments]ME_ExitStatusCode |
FiscalResponsibility | 17.7.0 | VarChar2(1) |
|
GiftedTalentedAcademic_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a gifted and talented academic program student. |
GiftedTalentedArtistic_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a gifted and talented artistic program student. |
GradeLevelCode | 17.7.0 | VarChar2(2) | Indicates which school or agency is responsible for the student's special education funding. |
GradelvlOverRideCode | 17.2.0 | VarChar2(1) | Codes indicating the override grade level. Migrated From: [ReEnrollments]ME_gradelvlOverRide |
HeritageLanguage_YN | 17.7.0 | VarCharr2(1) | Indicates whether or not the student is instructed is in their native language. |
HomelessNightTimeResidence | 17.7.0 | VarChar2(15) | Indicates where a homeless student resides at night. |
HomeSchooledFlag_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a home schooled student. |
MilitaryConnection | 17.7.0 | VarChar2(25) | Indicates whether or not the student is a dependent of a military service member. |
PercentageSchoolDayCode | 17.7.0 | VarChar2(2) | Indicates percentage of time a home schooled student spends in public schools. |
ProficiencyContentArea | 17.7.0 | VarChar2(5) | Indicates the content area or guiding principle in which the student is proficient. |
ResidentSAUIDOverride | 17.7.0 | VarChar2(4) | The SAU Org ID when a student's resident SAU is overriden. |
ResidentTown | 17.7.0 | VarChar2(3) | The code for the student's town of residence |
SchoolLunchEligCode | 17.2.0 | VarChar2(1) | Codes indicating the student’s school lunch eligibility. Migrated From: [ReEnrollments]ME_SchoolLunchElig |
SchoolLunchEligibility | 17.7.0 | VarChar2(15) | Description of the student's lunch eligibility. Used in Synergy uploads. |
ShelteredEnglish_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is in a sheltered English program. |
Special_Education_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a special education student. Migrated From: [ReEnrollments]ME_SpecialEdFlag |
SPEDDisability | 17.7.0 | VarChar2(3) | Indicates the student's disability type. |
SPEDExitDate | 17.7.0 | Date | Date the student exited a special education program. |
SPEDExitReason | 17.7.0 | VarChar2(2) | Indicates the reason the student exited a special education. |
SPEDPlacement | 17.7.0 | VarChar2(15) | Indicates where the special education student has been placed. |
SPEDReasonForExit | 17.7.0 | VarChar2(20) | Indicates the reason the student left the special education program. |
SPEDStartDate | 17.2.0 | Date | Date the student started a special education program. Migrated From: [Students]ME_SpedStartDate |
Title1AELA_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a Title 1A English student. |
Title1AMath_YN | 17.7.0 | VarChar2(1) | Indicates whether or not the student is a Title 1A math student. |
UnaccompaniedYouth_YN | 17.7.0 | VarChar2(1) | indicates whether or not the student is an unaccompanied youth. |
ResidentTownCode | 18.2.0 | VarChar2(3) | Indicates the code of student's resident town. |
ResidentSAU_ID | 18.2.0 | VarChar2(5) | Indicates the ID of the SAU of the student's resident town. |
TraBilingEarlyExit_YN | 19.8.2.0 | VarChar2(1) | Transitional Bilingual Education or Early Exit Education |
DualLangTwoWayImmer_YN | 19.8.2.0 | VarChar2(1) | Dual Language or Two Way Immersion |
ESLELD_YN | 19.8.2.0 | VarChar2(1) | English as a Second Language or Language Development |
ContentClasses_YN | 19.8.2.0 | VarChar2(1) | Content Classes with Integrated ESL Support |
Newcomer_YN | 19.8.2.0 | VarChar2(1) | NewComer Programs |