Skip Maine state header navigation
| MEDMS Data Element (Field) Definitions | |||||
| for Student Schema and Web Form Fields | |||||
| Specifications | |||||
Element Name |
Description* | Nulls Allowed |
Data Required |
# of Characters | Data Example |
| SAUID | Definition: The
SAU (School Administrative Unit) uploading/entering the student's data. Type of Data: int |
Y | 4 | Look-up List | |
| SchoolStudentID
|
Definition:
School Student identification number.
Type of Data: varchar. Restricted to 10 characters. |
Y | 0 to 10 | 1234567890 | |
| StateStudentID | Definition:
Student ID provided by MEDMS/Infinite Campus. Type of Data: char. |
Y | 0 or 9 | 123456789 | |
| MedicaidID | Definition:
Medicaid ID if it exists. Type of Data:char |
Y | 0 or 9 | 12345678A | |
| MedicaidStartDate | Definition:
Medicaid eligibility start date. Type of Data: date |
Y | (If ID populated) | 0 or 10 | 2009-08-01 |
| MedicaidEndDate | Definition:
Medicaid eligibility end date. Type of Data: date |
Y | 0 or 10 | 2009-08-31 | |
| MedicaidVerificationDate | Definition:
Date Medicaid eligibility was verified. Type of Data: date |
Y | 0 or 10 | 2009-08-01 | |
| MedicaidReleaseDate | Definition:
Date Medicaid record release was signed. Type of Data: date |
Y | (If ID populated) | 0 or 10 | 2009-08-01 |
| SSN | Definition:
Social security number. Type of Data: char |
Y | 0 or 9 | 123456789 | |
| LastName | Definition:
Legal last name of student (no suffix). Type of Data: varchar |
Y | 1 to 50 | Smith | |
| FirstName | Definition:
Legal first name of student (no alias or suffix) .
Type of Data: varchar |
Y | 1 to 50 | John | |
| MiddleName | Definition:
Middle name of student. Type of Data: varchar |
Y | 0 to 50 | James | |
| Alias | Definition:
Alias or nickname if it exists. Type of Data: varchar |
Y | 0 to 50 | Jack | |
| NameSuffixCode | Defintion: A
suffix representing the student following the name, such as Jr, III, etc.
Type of Data: varchar |
Y | 0 to 3 | Look-up List | |
| EthnicityCode | Definition:
The ethnicity of the student. Type of Data: char |
Y | 1 | Look-up List | |
| Gender | Definition:
Gender of student. Type of Data: char |
Y | 1 | Look-up List | |
| BirthDate | Definition:
Date of birth of student. Type of Data: datetime |
Y | 10 | 2005-01-08 | |
| CityTownOfBirth | Definition:
Student's birth city/town. Type of Data: varchar |
Y | 0 to 25 | Augusta | |
| StateOfBirth | Definition:
Student's state of birth. Includes "Other" for non-Maine state. Type of Data: char |
Y | 0 or 2 | Look-up List | |
| CountryOfBirth | Definition:
Student's birth country. Type of Data: char |
Y | 0 or 2 | Look-up list | |
| USArrivalDate | Definition:
Date immigrant student first enters US. Type of Data: datetime |
Y | 0 or 10 | 2006-01-08 | |
| USSchoolDate | Definition:
Date of first US school enrollment of immigrant student. Type of Data: datetime |
Y | (If Immigrant) | 0 or 10 | 2006-01-08 |
| ImmigrantFlag | Definition:
if student is an immigrant, check box. Type of Data: char |
Y | 0 or 1 | N or n, Y or y, or null (blank) |
|
| ParentGuardian1LastName | Definition:Last
name of parent or guardian. The "&" sign is not accepted. Type of Data: char |
Y | 0 to 50 | Smith | |
| ParentGuardian1FirstName | Definition:First
name of parent or guardian. The "&" sign is not accepted. Type of Data: char |
Y | 0 to 50 | Jane | |
| ParentGuardian2LastName | Definition:Last
name of parent or guardian. The "&" sign is not accepted. Type of Data: char |
Y | 0 to 50 | Smith | |
| ParentGuardian2FirstName | Definition:First
name of parent or guardian. The "&" sign is not accepted. Type of Data: char |
Y | 0 to 50 | John | |
| MotherMaidenName | Definition:Maiden
name of mother. Type of Data: char |
Y | 0 to 50 | Jones | |
| AddressLine1 | Definition:
First line of student's address.
Type of Data: varchar |
Y | 0 to 50 | ||
| AddressLine2 | Definition:
Second line of student's address.
Type of Data: varchar |
Y | 0 to 50 | ||
| CityTown | Definition:
Name of town in address. Type of Data: varchar |
Y | 0 to 25 | Lewiston | |
| State/Province | Definition:
Name of state in address. Type of Data: char |
Y | 0 or 2 | Look-up List | |
| ZipCode | Definition:
Zip code of town. Use numbers only. No dashes or other characters. Type of Data: varchar |
Y | 0 or 5 or 9 | 04000 or 040001111 | |
| HomePhone | Definition:
Home Telephone number with area code. Numbers only. Type of Data: varchar |
Y | 0 or 10 | 2071112222 | |
| Definition:E-mail
address of contact. Type of Data: varchar |
Y | 0 to 50 | jjm@alo.com | ||
| * The descriptions listed here are for general reference purposes and are not legal definitions for any of these data. | |||||