|
|
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 |
