Skip Maine state header navigation

Agencies | Online Services | Help

Skip First Level Navigation | Skip All Navigation

Home > Schemas > Staff Employment Data Dictionary

Staff Employment Data Dictionary

 

 

Specifications

Data Element

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
EndDate Definition: This is the month, day and year (in the current school year) on which this staff employment (job function) ended.  Type of Data:  Date
Y
N
10
2012-01-10
EDType Definition: This indicates the environment type (Regular or Voc) of the job function.  Type of Data:  Char
N
Y
3

R or V
StateJobCode Definition: This indicates the position that the staff member holds.  Type of Data:  Char
N
Y
4
SchoolID Definition:  The state ID for the School in which this position is located - required for some positions. Type of Data:  Int
Y
N
4
WorkEmail Definition:  Work email of the staff member - required for some positions. Type of Data:  VarChar
Y
N
0 to 50
AssignmentLevel Definition: This indicates the grade span of the job function.  Type of Data:  Char
N
Y
2
HoursPerDay Definition:  This indicates the hours per day for this assignment. (one decimal place allowed). Type of Data:  Decimal
N
Y
1-4
8.5
DaysPerYear Definition:  This indicates the days per per year for this assignment.  Type of Data:  Int 
N
Y
1-3
280
ProgramCategory Definition: This indicates the program category (if applicable).  Special Ed or Title 1  Type of Data:  Char
Y
N
0 or 2
SP or T1
SubjectMatter Definition:  This indicates the subject matter of the job function  Type of Data:  Char
Y
N
2
Salary Definition:  This indicates the annual salary for this job function. (whole dollars, no decimal or $). Type of Data:  Int
N
Y
1-6
57000
FederalFundingPercent Definition:  This indicates the percentage of the salary that is paid by federal grants such as Title I-A Disadvantaged, Title 1-B Even Start, Title 1-C Migrant, Title II, Title III, Title IV including 21st Century grants, Title V, Rural Education, and Local Entitlement.  (two decimal places allowed). Type of Data:  Decimal
N
Y
1-5
55.55

 

 

 

 

 

These 3 fields must add up to 100

GeneralFundingPercent Definition:  This indicates the percentage of the salary that is paid by state and local funds such as local taxes, local tuition revenues, State subsidy, State Agency Client funds.  (two decimal places allowed). Type of Data:  Decimal
N
Y
1-5
45.45
OtherFundingPercent Definition:  This indicates the percentage of the salary that is paid by funds other than federal or those that fall under general such as private grant or contribution.  (two decimal places allowed). Type of Data:  Decimal
N
Y
1-5
0