S_ME_STU_X (ver 17.2.0)
This table is an extension of the [Students] table.
Column Name | Version | Data Type | Description |
|---|---|---|---|
StudentsDCID | 17.2.0 | Number(10,0) | Foreign Key to the Students table. |
AdultEducationFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is an adult education program student. Migrated From: [Students]ME_AdultEducationFlag |
Alias | 17.2.0 | VarChar2(50) | Indicates student's alias or nickname. Migrated From: [Students]ME_Alias |
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.2.0 | VarChar2(1) | Indicates whether or not the student is an alternative education program student. Migrated From: [Students]ME_AlternativeEducationflag |
BilingualEducation_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a bilingual student. Migrated From: [Students]ME_BilingualEducation |
BirthMotherFirstName | 17.2.0 | VarChar2(50) | First name of student's birth mother. Migrated From: [Students]ME_BirthMotherFirstName |
BirthOrderCode | 17.2.0 | VarChar2(1) | Codes indicating the student's birth order. Migrated From: [Students]ME_BirthOrderCode |
Chapter504StatusFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a Chapter 504 student. Migrated From: [Students]ME_Chapter504StatusFlag |
CitizenshipCode | 17.2.0 | VarChar2(2) | Codes indicating the student's citizenship. Migrated From: [Students]ME_CitizenshipCode |
CityTownOfBirth | 17.2.0 | VarChar2(25) | Indicates a city or town of birth. Migrated From: [Students]ME_CityTownOfBirth |
CountryOfBirth | 17.2.0 | VarChar2(2) | Indicates a country of birth. Migrated From: [Students]ME_CountryOfBirth |
CountryOfCitizenship | 17.2.0 | VarChar2(2) | Indicates a country of citizenship. Migrated From: [Students]ME_CountryOfCitizenship |
CountryOfResidency | 17.2.0 | VarChar2(2) | Indicates a country of residency. Migrated From: [Students]ME_CountryOfResidency |
CountyOfBirth | 17.2.0 | VarChar2(2) | Indicates a country of birth. Migrated From: [Students]ME_CountyOfBirth |
DateFirstEnrolledESL | 17.2.0 | Date | Date the student was first enrolled in ESL program. Migrated From: [Students]ME_DateFirstEnrolledESL |
EarlyKindergarten_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is an early kindergarten student. Migrated From: [Students]ME_EKinder |
EconomicStatusEligibEndDate | 17.7.0 | Date | The date the student became eligible for a school lunch program. |
EconomicStatusEligibStartDate | 17.7.0 | Date | The date the student is no longer 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 enrollment type for this school enrollment. Migrated From: [Students]ME_EnrollmentTypeCode |
ESLOnlyEducation_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student has ESL only education program. Migrated From: [Students]ME_ESLOnlyEducation |
ExceptionalityCode | 17.2.0 | VarChar2(2) | Codes indicating the student's exceptionality program codes. Migrated From: [Students]ME_ExceptionalityCode |
ExitStatusCode | 17.2.0 | VarChar2(2) | Codes indicating the student’s exit status. Migrated From: [Students]ME_ExitStatusCode |
FiscalResponsibility | 17.7.0 | VarChar2(1) | Indicates which school or agency is responsible for the student's special education funding. |
ForeignExchange_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a foreign exchange program student. Migrated From: [Students]ME_ForeignExchange |
GiftedTalentedAcademic_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a gifted and talented academic program student. Migrated From: [Students]ME_GiftedTalentedAcademic |
GiftedTalentedArtistic_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a gifted and talented artistic program student. Migrated From: [Students]ME_GiftedTalentedArtistic |
GradeLevelCode | 17.7.0 | VarChar2(2) | Student's current grade level. |
GradelvlOverRideCode | 17.2.0 | VarChar2(1) | Codes indicating the student's override grade levels. Migrated From: [Students]ME_gradelvlOverRide |
GradYearType | 17.2.0 | VarChar2(9) | Graduation year type. Migrated From: [Students]ME_GradYearType |
Guardian1NameFirst | 17.2.0 | VarChar2(25) | First name of the student’s 1st parent or guardian. Migrated From: [Students]ME_Guardian1NameFirst |
Guardian1NameLast | 17.2.0 | VarChar2(25) | Last name of the student’s 1st parent or guardian. Migrated From: [Students]ME_Guardian1NameLast |
Guardian2NameFirst | 17.2.0 | VarChar2(25) | First name of the student’s 2nd parent or guardian. Migrated From: [Students]ME_Guardian2NameFirst |
Guardian2NameLast | 17.2.0 | VarChar2(25) | Last name of the student’s 2nd parent or guardian. Migrated From: [Students]ME_Guardian2NameLast |
HeritageLanguage_YN | 17.2.0 | VarCharr2(1) | Indicates whether or not the student is instructed is in their native language. Migrated From: [Students]ME_HeritageLanguage |
HomeLanguageCode | 17.7.0 | VarChar2(3) | Indicates the most commonly spoken language used by the student and the members of the student's family for everyday interactions at home. |
HomeSchooledFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a home schooled student. Migrated From: [Students]ME_HomeSchooledFlag |
HomelessCode | 17.2.0 | VarChar2(2) | Codes indicating student's homeless status. Migrated From: [Students]ME_HomelessCode |
HomelessNightTimeResidence | 17.7.0 | VarChar2(15) | Indicates where a homeless student resides at night. |
ImmigrantFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is an immigrant student. Migrated From: [Students]ME_ImmigrantFlag |
LEPBilingualEd_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is participating in LEP bilingual education. Migrated From: [Students]ME_LEPBilingualEd |
LEPExitDate | 17.2.0 | Date | Date the student exited the LEP program. Migrated From: [Students]ME_LEPExitDate |
LEPReclassAssessment | 17.2.0 | VarChar2(4) | Indicates the student’s LEP re-class assessment. Migrated From: [Students]ME_LEPReclassAssessment |
LEPReclassMethodCode | 17.2.0 | VarChar2(1) | Indicates the student’s LEP re-class method. Migrated From: [Students]ME_LEPReclassMethod |
LEPSubmersionEdFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is participating in LEP submersion education. Migrated From: [Students]ME_LEPSubmersionEdFlag |
LEP_EnglishOnlyFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is participating in LEP English only. Migrated From: [Students]ME_LEP_ESLOnlyEdFlag |
LanguageCode | 17.2.0 | VarChar2(3) | Indicates language codes. Migrated From: [Students]ME_Language |
MedicaidEndDate | 17.2.0 | Date | Date the student's Medicaid eligibility ends. Migrated From: [Students]ME_MedicaidEndDate |
MedicaidID | 17.2.0 | VarChar2(9) | Student's Medicaid ID. Migrated From: [Students]ME_MedicaidID |
MedicaidReleaseDate | 17.2.0 | Date | Date the student’s Medicaid record release was signed. Migrated From: [Students]ME_MedicaidReleaseDate |
MedicaidStartDate | 17.2.0 | Date | Date the student's Medicaid eligibility starts. Migrated From: [Students]ME_MedicaidStartDate |
MedicaidVerificationDate | 17.2.0 | Date | Date the student's Medicaid eligibility is verified. Migrated From: [Students]ME_MedicaidVerificationDate |
MigrantFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a migrant student. Migrated From: [Students]ME_MigrantFlag |
MilitaryConnection | 17.7.0 | VarChar2(25) | Indicates whether or not the student is a dependent of a military service member. |
MotherMaidenName | 17.2.0 | VarChar2(50) | Mother maiden name. Migrated From: [Students]ME_MotherMaidenName |
NameSuffixCode | 17.2.0 | VarChar2(3) | Student's name suffix type. Migrated From: [Students]ME_NameSuffixCode |
PercentageSchoolDayCode | 17.2.0 | VarChar2(2) | Indicates percentage of time a home schooled student spends in public schools. Migrated From: [Students]ME_PSD |
ProficiencyContentArea | 17.7.0 | VarChar2(5) | Indicates the content area or guiding principle in which the student is proficient. |
RefugeeFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a refugee student. Migrated From: [Students]ME_RefugeeFlag |
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 |
RetainedGradeFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is retained in the grade. Migrated From: [Students]ME_RetainedGradeFlag |
SchoolLunchEligCode | 17.2.0 | VarChar2(1) | Code indicating the student’s lunch eligibility. Migrated From: [Students]ME_SchoolLunchElig |
SchoolLunchEligibility | 17.7.0 | VarChar2(15) | Description of the student's lunch eligibility. Used in Synergy uploads. |
ShelteredEnglish_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is in a sheltered English program. Migrated From: [Students]ME_ShelteredEnglish |
Special_Education_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a special education student. Migrated From: [Students]ME_SpecialEdFlag |
SPEDDisability | 17.7.0 | VarChar2(3) | Indicates the student's disability type. |
SPEDExitDate | 17.2.0 | Date | Date the student exited a special education program. Migrated From: [Students]ME_SpedExitDate |
SPEDExitReason | 17.2.0 | VarChar2(2) | Indicates the reason the student exited a special education. Migrated From: [Students]ME_SpedExitReason |
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. |
SPEDSettingCode | 17.2.0 | VarChar2(1) | Indicates educational settings for a special education student. Migrated From: [Students]ME_SpedSetting |
SPEDStartDate | 17.2.0 | Date | Date the student started a special education program. Migrated From: [Students]ME_SpedStartDate |
StartStatus | 17.2.0 | VarChar2(2) | Codes indicating the reason the student started enrollment in the school. Migrated From: [Students]ME_StartStatus |
StateAgencyClientFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a client of a state agency. Migrated From: [Students]ME_StateAgencyClientFlag |
StateAgencyStateWardFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a ward of the state. Migrated From: [Students]ME_StateAgencyStateWardFlag |
StateOfBirth | 17.2.0 | VarChar2(2) | Student's state of birth. Migrated From: [Students]StateOfBirth |
StateWardFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is is a ward of the state. Migrated From: [Students]ME_StateWardFlag |
Suffix | 17.7.0 | VarChar2(10) | Student's name suffix |
SupplementalEdServices_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is receiving supplemental educational services. Migrated From: [Students]ME_SupplementalEdServices |
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. |
Title1AFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a Title 1 A program student. Migrated From: [Students]ME_Title1AFlag |
Title1CFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a Title 1 C program student. Migrated From: [Students]ME_Title1CFlag |
Title3Flag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is a Title 3 program student. Migrated From: [Students]ME_Title3Flag |
UnaccompaniedYouth_YN | 17.7.0 | VarChar2(1) | indicates whether or not the student is an unaccompanied youth. |
USArrivalDate | 17.2.0 | Date | Date the student arrived to the USA. Migrated From: [Students]ME_USArrivalDate |
USSchoolDate | 17.2.0 | Date | Date the immigrant student first enrolled in a US school. Migrated From: [Students]ME_USSchoolDate |
VocationalFlag_YN | 17.2.0 | VarChar2(1) | Indicates whether or not the student is participating in vocational program. Migrated From: [Students]ME_VocationalFlag |
WorkPermitFlagCode | 17.2.0 | VarChar2(1) | Indicates whether or not the student has a work permit. Migrated From: [Students]ME_WorkPermitFlag |
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 |