| 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. 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 | |
| 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: Alphabetic. |
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 5 | 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 | 1 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. Includes "Other" for non-Maine country. Type of Data: char |
Y | 0 or 2 | Look-up list | |
| 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) |
|
| ParentGuardianLastName | Definition:Last
name of parent or guardian. The "&" sign is not accepted. Type of Data: char |
Y | 0 to 50 | Smith | |
| ParentGuardianFirstName | 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 | |
| Address Line 1 | Definition:
First line of student's address.
Type of Data: varchar |
Y | 0 to 50 | ||
| Address Line 2 | 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 or 3 | ||
| State/Province | Definition:
Name of state in address. Type of Data: char |
Y | 0 or 2 | ||
| Zip Code | Definition:
Zip code of town. Type of Data: varchar |
Y | 5 or 5-4 | ||
| HomePhone | Definition:
Home Telephone number. Type of Data: varchar |
Y | 0 or 10 | ||
| Definition:E-mail
address of contact. Type of Data: varchar |
Y | 0 to 50 | |||
| * The descriptions listed here are for general reference purposes and are not legal definitions for any of these data. | |||||