Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > Data Element (Field) Definitions for Student Schema andWeb Form Fields*

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
HispanicLatino Definition: Is the ethnicity of the student Hispanic/Latino?
Type of Data: char 
  Y 1 N or Y
AmericanIndianAlaskaNative Definition: Is the race of the student American Indian or Native Alaskan?
Type of Data: char 
  Y 1 N or Y**
Asian Definition: Is the race of the student Asian?
Type of Data: char
  Y 1 N or Y**
BlackAfricanAmerican Definition: Is the race of the student Black or African American?
Type of Data: char
  Y 1 N or Y**
NativeHawaiianPacificIslander Definition: Is the race of the student Native Hawaiian or other Pacific Islander?
Type of Data: char
  Y 1 N or Y**
White Definition: Is the race of the student White/Caucasian?
Type of Data: char
  Y 1 N or Y**
Determination Definition: The identification method by which an individual’s race and ethnicity were identified.
Type of Data: char
Y   2 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 or LEP student. 
Type of Data: datetime
Y (If Immigrant or LEP) 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
StateProvince 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
Email Definition:E-mail address of contact.
Type of Data: varchar
Y   0 to 100 jjm@alo.com

* The descriptions listed here are for general reference purposes and are not legal definitions for any of these data.
** At least one of the Race fields (AmericanIndianAlaskaNative, Asian, BlackAfricanAmerican, NativeHawaiianPacificIslander, White) must have a "Y" value.