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 |