Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > Schemas > Staff Demographic Data Dictionary

MEDMS Staff Demographic Data Dictionary

   

Specifications

Element Name

Description

Nulls Allowed

Data Required

#Characters

Data Example

SAUID Definition:  The state ID for the SAU (School Administrative Unit) uploading the staff data. Type of Data:  Int
N
Y
4
YearCode Definition:  The 4 character representation of the School Year for the data in the upload. Type of Data:  Char
N
Y
4
2012
StaffStateID Definition:  The state ID for the staff member - this id is assigned by the MEDMS staff system. Type of Data:  Int
N
Y
6
123456
LastName Definition:  The legal last name of the staff member. Type of Data:  Char
N
Y
1-50
Ellis
FirstName Definition:  The legal first name of the staff member. Type of Data:  Char
N
Y
1-50
Charlotte
MiddleName Definition:  The legal middle name of the staff member. Type of Data:  Char
Y
N
1-50
H
NameSuffixCode Definition:  A suffix representing the generation of the staff member sharing a name with other relatives (JR, SR, III, etc). Type of Data:  Char
Y
N
0-3
Gender Definition:  Gender of the staff member. Type of Data:  Char
N
Y
1
M or F
BirthDate Definition:  The legal birthdate of the staff member. Type of Data:  Date
N
Y
10
1980-06-11
YearsPublicEd Definition: This is the number of years of experience (both from within Maine and from elsewhere) in public school positions that would normally require a certification (e.g. teacher, administrator) or authorization (e.g. educational technician).  Type of Data:  Int
N
Y
1-2
0-99
YearsPrivateEd Definition: This is the number of years of experience (both from within Maine and from elsewhere) in private school positions that would normally require a certification (e.g. teacher, administrator) or authorization (e.g. educational technician).  Type of Data:  Int
N
Y
1-2
0-99
YearsVocCTE Definition: This is the number of years of experience (both from within Maine and from elsewhere) in a field related to a Voc/CTE program (e.g. automotive, masonry), while not working in education.  Type of Data:  Int
N
Y
1-2
0-99
AddressLine1 Definition:  First line of the staff member's mailing address - address is used by certification for renewal documents. Type of Data:  VarChar
N
Y
1-50
23 SHS
AddressLine2 Definition:  Second line of the staff member's mailing address - address is used by certification for renewal documents. Type of Data:  VarChar
Y
N
0-50
Maine Dept of Education
City Definition:  City/town of the staff member's mailing address - address is used by certification for renewal documents. Type of Data:  VarChar
N
Y
1-50
Augusta
State Definition:  State of the staff member's mailing address - address is used by certification for renewal documents. Type of Data:  Char
N
Y
2
ZipCode Definition:  ZipCode of the staff member's mailing address - Use numbers only-no dashes or other characters. Type of Data:  Char
N
Y
5 or 9
04333 or 043330023
HomePhone Definition:  Home phone number of the staff member including area code - Use numbers only. Type of Data:  VarChar
Y
N
0 or 10
2075551212
WorkPhone Definition:  Work phone number of the staff member including area code - Use numbers only. Type of Data:  VarChar
N
Y
10
2075551212
WorkFax Definition:  Work fax number of the staff member including area code - Use numbers only. Type of Data:  VarChar
Y
N
0 or 10
2075551212
EmailAddress Definition:  Work email of the staff member-may be used for mailings. Type of Data:  VarChar
Y
N
0 to 50
YearsAtSAU Definition: This is the number of years of experience (in full years), working at this unit, not including the current year.  (Experience is maintained for employment at a newly consolidated unit.) Type of Data:  Int
N
Y
1 to 2
19
EducationLevel Definition: This is the highest level of attainment.  For those options that include hours beyond a degree (e.g. Bachelor’s Degree + 15 Hrs, Master’s Degree + 30 Hrs), a combination of equivalent credits, contact hours, CEUs, etc. can be included.  Type of Data:  Char
N
Y
1
DistrictStartDate Definition: This is the month, day and year (in the current school year) on which employment began.  Type of Data:  Date
N
Y
10
2011-07-11
DistrictEndDate Definition: This is the month, day and year (in the current school year) on which employment ended. Note: A District End Date will also end the Job Functions (Staff Employment) of this staff member.  Type of Data:  Date
Y
N
0 or 10
2011-07-30
DistrictExitReasonCode   Definition: This indicates the reason why the employment was ended.  Type of Data:  Char
Y
N
0 or 1
Other Responsibilities  (This is not a field in the upload) Definition:  The following fields are used to validate certification for those performing nontraditional services.  Type of Data:  Char
AltEd Enter Y if this staff member teaches in an alternative education program for this district
N
Y
1
N or Y
AfterSchool Enter Y if this staff member works in an after school program for this district
N
Y
1
N or Y
ESL Enter Y if this staff member works with English Language Learner students in this district
N
Y
1
N or Y
HealthCoordinator Enter Y if this staff member performs health coordination services for this district
N
Y
1
N or Y
NurseAide Enter Y if this staff member assists the school/district nurse
N
Y
1
N or Y
Substitute Enter Y if this staff member works as a long term substitute (60 days or more in one position)
N
Y
1
N or Y
SpedRegionalProg Enter Y if this staff member works as part of a Special Education Regional Program
N
Y
1
N or Y