Skip Maine state header navigation
| 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 | |
| YearCode (uploads only) |
Description: MEDMS
school year designation. (Not used on web
form) Data Type: char |
Y | 4 | 2010 | |
| SchoolEntryDate | Definition:
First day of school in the current school year. Dates from prior years are not accepted. Data Type: datetime |
Y | 10 | 2009-09-01 | |
| StartStatus | Definition:
Reason student started in the school. Data Type: char |
Y | 0 or 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 | 2010-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 | 1, 2, 3, 4, or null (blank) |
| StateWardFlag | Description: Child
is considered a ward of the State if the State is the legal guardian by court
order. Data Type: char |
Y | (if applicable) | 0 or 1 | N or n, Y or y, or null (blank) |
| StateAgencyClientFlag | Description: A
State Agency Client 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 | 2009-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 | 2010-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 this school year.
Data Type: datetime |
Y | (if SpecialEdFlag is Y/y) | 0 or 10 | 2009-09-08 |
| SpedExitDate | Definition:
Date when student exited a special education program.
Data Type: datetime |
Y | (If SpedExitReason present) | 0 or 10 | 2010-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 |
| * The descriptions listed here are for general reference purposes and are not legal definitions for any of these data. | |||||