Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > Data Element (Field) Definitions for School Enrollment Schema and Web Form Fields

MEDMS Data Element (Field) Definitions for School Enrollment Schema and Web Form Fields

 

 

 

Specifications

 


Element Name 
Description* Nulls
Allowed
Data
Required
# of Characters Data
Example
School_ID Definition: Name or ID of school student attends. 
Data Type: int
  Y 4 Look-up List
StateStudentID Definition: ID provided by MEDMS for each student.
Data Type: char
  Y
9 123456789
SchoolStudentID Definition:Student ID provided by the school the student is attending.
Data Type: varchar  
Y
0 to 10 123456789
ResidentSAU_ID Definition: The Resident School Administrative Unit (SAU) of the student. Must be the SAU of the student's resident town.
Data Type: int
  Y 4 Look-up List
ResidentTownCode Definition: ID of student's resident town.
Data Type: char                                                          
  Y 3 Look-up List
EnrollmentTypeCode Definition: Type of Enrollment in school
Data Type: char
  Y 1 Look-up List
SchoolLunchElig
(Economic Indicator on web form)
Description: Status of student's eligibility for free or reduced lunch.
Data Type: char
  Y 1 Look-up List
SchoolLunchDate Description: Start Date for the students school lunch eligibility (FRAM) record.
Data Type: datetime
  Y 10 2012-09-01
YearCode
(uploads only)
Description: MEDMS school year designation. (Not used on web form)
Data Type: char
  Y 4 2013
SchoolEntryDate  Definition: First day of school in the current school year. Dates from prior years are not accepted.
Data Type: datetime
  Y 10 2012-09-01
StartStatus Definition: Reason student started in the school.
Data Type: char
  Y 2 Look-up List
StartComments Definition: Comments regarding the start of this enrollment.
Data Type: varchar
Y   0 to 250 Text comments here.
GradeLevelCode Definition: The grade the student is in.
Data Type: char
  Y 2 Look-up List
ExitTypeCode Definition: Reason student left the school. Through graduation, expulsion, transfer, etc.
Data Type: char
Y   0 or 2 Look-up List
ExitDate Definition: Date when student exits a school.
Data Type: datetime
Y (If Exit Type selected) 0 or 10 2013-01-08
ExitComments Definition: Comments regarding the end of this enrollment.
Data Type: varchar
Y   0 to 250 Text comments here.
FiscalResponsibilityCode Description: Designation of who is responsible for cost of student's education. 
Data Type: char
  Y
1 Look-up List
Title1AFlag Descriptiption: Applies if the child is considered at risk and is eligible for Title IA services by virtue of their status.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
AlternativeEdFlag Description: Applies if student is participating in an Alternative Education program.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
HomeSchooledFlag Description: Students who are home schooled and attend local school districts part time or home schooled students receiving only Special Education services. If yes then FTE value if required (see FTE below).
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
SpecialEdFlag Description: Check box if student fits eligibility standards and has an IEP.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
Chapter504StatusFlag Description: Applies if student participates in a Chapter 504 program.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
GiftedTalentedAcademic Description:  Applies if student participates in an Intellectual/Academic based Gifted and Talented program.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
GiftedTalentedArtistic Description:  Applies if student participates in an Artistic based Gifted and Talented program.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
FTE Description: The percent of time spent at school by a home schooled student. Also an option to designate only Special Education services received at school.
Data Type: varchar
Y (if Home School
Education checked)
0 or 1 Look-up list
ExceptionalityCode Description: Choose appropriate exceptionality for student receiving special education services.
Data Type: char
Y (if SpecialEdFlag is Y/y) 0 or 2 Look-up list
HomelessCode Description:Choose the appropriate "Homeless Night-time Residence Code".
Data Type: char
Y (if applicable) 0 or 1 Look-up list
UnaccompaniedYouth Description: An unaccompanied youth is a student who is not in the physical custody of a parent or guardian; this includes youth who have run away from home, been kicked out of their homes, or been abandoned by parents.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
StateAgencyStateWardFlag Description: A State Agency Client or StatwWard is defined as a child in the care or custody of DHS, BDS or DOC.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or
null (blank)
Language Description: Student's native language.
Data Type: char
  Y 3 Look-up List
EnglishProficiency Description: The English proficiency of the student.
Data Type: char
  Y 2 Look-up List
RefugeeFlag Description: If a student is a refugee, check box .
Data Type: char
Y   0 or 1 N or n, Y or y, or null (blank)
ShelteredEnglish Description: An approach that uses simplified English to teach ESL and subject area content at the same time.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
HeritageLanguage Description: The instruction in the student's primary or native language.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
DateFirstEnrolledESL Definition: Date when student first enrolled in a Maine ESL program.
Data Type: datetime
Y (If EnglishProficiency is 03, LEP or 04, Transitioned back to LEP) 0 or 10 2012-01-08
BilingualEducation Description: A program of education that uses more than one language as the medium of instruction.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
ESLOnlyEducation Description: Instruction in only the language of English. Various methodologies used.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
LEPExitDate Definition: Date when student exited an LEP program.
Data Type: datetime
Y (if applicable) 0 or 10 2011-01-08
ForeignExchange Description: Indicates a foreign exchange student.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
SupplementalEdServices Description: Indicates a student is receiving supplemental education services.
Data Type: char
Y (if applicable) 0 or 1 N or n, Y or y, or null (blank)
SpedStartDate Definition: Date when student began a special education program.
Data Type: datetime
Y (if SpecialEdFlag is Y/y) 0 or 10 2010-09-08
SpedExitDate Definition: Date when student exited a special education program.
Data Type: datetime
Y (If SpedExitReason present) 0 or 10 2013-01-08
SpedExitReason Description: Reason student exited special education.
Data Type: char
Y (If SpedExitDate present) 0 or 2 Look-up list
SpedSetting Description: Educational setting of special education student.
Data Type: char
Y (if SpecialEdFlag is Y/y) 0 or 1 Look-up list
Action

Description: Indicates a correction to bad data or a change of status for the following fileds: ResidentTownCode, ResidentSAU_ID,
SchoolLunchElig, FiscalResponsibilityCode, SpecialEdFlag
Data Type: char

Y (If data is changed in fields listed under Description to the left.) 0 or 1 C or c, S or s, or null (blank)
EffectiveDate Description: Date of change in status for the following fields: ResidentTownCode, ResidentSAU_ID,
SchoolLunchElig, FiscalResponsibilityCode, SpecialEdFlag
Data Type: datetime
Y (If data is changed in fields listed under Description to the left.) 0 or 10 2013-01-08
* The descriptions listed here are for general reference purposes and are not legal definitions for any of these data.