FileSpec:201810OctoberCycleEducatorSchool
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2018Oct1.0EdSchool' for the 2018 Educator School October Cycle File Layout.
Text 50
010 Current School Year CurrentSchoolYear Required The ending year of the current school year. For example, use '2007' for the 2006-2007 school year.
Integer 4
025 Reporting District Code ReportingDistrictCode Required DESE assigned 6 digit county district code for the district reporting. DESE_District_Codes Text 6
030 Reporting School Code ReportingSchoolCode Required DESE assigned 4 digit school code where the educator is being reported from. DESE_School_Codes Text 4
050 ED SSN EDSSN Required Social Security Number. Format allowed '999999999'.
Text 9
060 Legal Last Name LastName Optional Legal last name.
Text 60
065 Legal First Name FirstName Optional Legal first name.
Text 60
070 Position Code PosCode Required Position code of educator’s assignment. Position_Codes Text 2
080 CTE Program Type CTEProgType Conditional Program type code of CTE approved program else null. CTE_Program_Type_Codes Text 4
090 FTE FTE Required Full-time equivalency--the percent of time educator works in associated attendance center reported as a decimal.
Text 4 2
100 Salary Salary Required Salary educator receives for the associated position and attendance center including only regular term salary and extended contract salary.
Integer 6
110 CTE Month CTEMonth Conditional Total number of months educator is contracted for a CTE program else null.
Integer 2
120 Late Start Date LateStartDate Conditional Date position is added after beginning of school year or filled for first time after beginning of school year or an individual replaces original educator after beginning of school year else null.
Text 10
130 Early End Date EarlyEndDate Conditional Date position is eliminated prior to end of school year or individual is transferred out of position prior to end of school year (leaving position vacant) or individual is replaced in position with another individual prior to end of school year else null.
Text 10
140 Course Comment CourseComm Conditional Free-form notes such as teachers assisted by an aide, or aides assisting a teacher.
Text 70