| 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 |
0 or 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 | 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 | 2007 | |
| SchoolEntryDate | Definition:
First day of school in the current school year. Dates from prior years are not accepted. Data Type: datetime |
Y | 10 | 2005-01-08 | |
| GradeLevelCode | Definition:
The grade the student is in. Type of Data: char |
Y | 2 | Look-up List | |
| RetainedGradeFlag | Definition:
Select the retained option for this school year if student is repeating grade from last school year. Data Type: char |
Y | 0 or 1 | N or n, Y or y, or null (blank) |
|
| 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 | 2005-01-08 |
| 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) |
| GiftedTalentedFlag | Description: Applies if student participates in a 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 applicable) | 0 or 2 | Look-up list |
| Title1CFlag | Description: Call migrant education at (207)624-6705 for
further information before assigning this option to a student. Data Type: char |
Y | (if applicable) | 0 or 1 | N or n, Y or y, or null (blank) |
| MigrantFlag | Description: This option applies if: · Student is less than 22 years old. · Student is not a high school graduate or does not hold a GED. · Student is a migrant worker or parent/spouse/guardian is a migrant worker. · Student or parent moved within last 36 months to seek or obtain agricultural work. · Migrant agricultural work must be the principal means of livelihood. · Student has moved from one school district to another for parents to find work. Data Type: char |
Y | (if applicable) | 0 or 1 | N or n, Y or y, or null (blank) |
| HomelessFlag | Description:
An individual who lacks a fixed, regular and adequate nighttime residence is
homeless. Data Type: char |
Y | (if applicable) | 0 or 1 | N or n, Y or y, 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 | |
| Heritage Language | Description: The
instruction in the student's primary or native language. Data Type: char |
Y | (if applicable) | 0 or 1 | |
| Bilingual Education | 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 | |
| ESL Only Education | Description: Instruction
in only the language of English. Various methodologies used. Data Type: char |
Y | (if applicable) | 0 or 1 | |
| * The descriptions listed here are for general reference purposes and are not legal definitions for any of these data. | |||||