Item | Item Name | Column Name | Required | Definition | Code Set | Data Type | Length | Precision |
---|---|---|---|---|---|---|---|---|
005 | Collection Version | CollectionVersion | Required | Collection version should contain this value '2013Oct1.0EdCore' for the 2013 Educator Core 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 | |
050 | ED SSN | EDSSN | Required | Social Security Number. Format allowed '999999999'. | Text | 9 | ||
060 | ED Legal Last Name | EDLastName | Required | Legal last name. | Text | 60 | ||
065 | ED Legal First Name | EDFirstName | Required | Legal last name. | Text | 60 | ||
070 | ED Legal Middle Name | EDMiddleName | Optional | Legal middle name. | Text | 10 | ||
075 | ED Legal Name Suffix | EDSuffix | Optional | Legal name suffix. | Text | 10 | ||
080 | ED Date of Birth | EDDateofBirth | Optional | Date of birth as appears on certificate of birth. | Text | 10 | ||
100 | ED Gender | EDGender | Required | Gender | Gender_Codes | Text | 1 | |
105 | ED Race/Ethnicity | EDRaceEthnicity | Required | Pre-defined Race / Ethnic code. | Race_Ethnicity_Codes | Text | 1 | |
110 | ED Email | EDEmail | Optional | Educator email address. | Text | 70 | ||
120 | Extended Contract Duration | EDExtConDur | Conditional | Number of extra days an educator has contracted to perform services for district beyond regular contract duration reported on District Data (Screen 02), if applicable. (Employees with 12-month contracts may show 260 days minus the regular contract duration.) | Integer | 3 | ||
130 | Extended Contract Salary | EDExtConSal | Conditional | Extra salary that teacher, counselor, librarian, or any position except administrator (Position Codes 10 and 20) receives for working more than a 9-month term. | Integer | 6 | ||
140 | Regular Term Salary | EDRegTermSal | Required | Educator's regular term salary (excluding minimum salary supplement); based upon the FTE of an approximate 9-month teaching contract except for administrators (Position Codes 10 and 20). The salary should correspond with the FTE. (If an educator is employed full-time for a portion of the year; such as 7 months; report the salary on the 9-month basis.) Board-paid insurance and other fringe benefits are not included. If a position is filled temporarily by a substitute (Position Code 60); show the full salary normally paid for that position.paid insurance and other fringe benefits are not included. If a position is filled temporarily by a substitute (Position Code 60), show the full salary normally paid for that position. | Integer | 6 | ||
150 | Extra Duty Salary | EDExtDutySal | Conditional | Salary for all activities that generate additional pay beyond the regular term salary except for extended contract salary and the career ladder and minimum salary supplements. (Include salary for time outside the regular school day.) If a teacher receives additional pay above the salary schedule through an Incentive Grant project; the extra pay is reported as Extra Duty Salary. If a teacher's entire salary is paid from an Incentive Grant; this pay is reported as "Regular Term Salary;" except for after-school assignments that are reported as Extra Duty Salary. |
Integer | 6 | ||
160 | Min. Salary Supplement | EDMinSalSupplmt | Conditional | Annualized state-paid supplemental salary received by a teacher; counselor; or librarian to bring the salary up to the state minimum salary level. | Integer | 6 | ||
170 | Career Ladder Stage | EDCareerLadr | Conditional | Career ladder stages (1, 2 or 3) of participating educators. Enter 1 for Stage I; enter 2 for Stage II; enter 3 for Stage III. | Educator_Career_Ladder_Stages | Text | 1 | |
180 | Highest Degree | EDHighDegree | Required | Highest degree of educator. | Educator_Highest_Degree | Text | 4 | |
190 | Public School Years - District | EDYrExpDist | Required | Total number of years experience of educator in current district including the current year. To be counted as one year, the contract must be for at least one half of the week and at least one half of the school year. | Integer | 2 | ||
195 | Public School Years - Missouri | EDYrExpMO | Required | Total number of years experience of educator in Missouri public school systems including the current year. To be counted as one year, the contract must be for at least one half of the week and at least one half of the school year. | Integer | 2 | ||
200 | Public School Years -Public | EDYrExpPublic | Required | Total number of years experience of educator in all public school systems including the current year. | Integer | 2 | ||
210 | Late Hire Date | EDLateHireDate | Conditional | Date (month/day) educator was hired if later than start of regular school term else null. | Text | 10 | ||
220 | Early Termination Date | EDEarlyTermDate | Conditional | Date (month/day) educator terminated services if earlier than end of regular school term else null. | Text | 10 | ||
230 | ED Comments | EDComments | Conditional | Free-form notes used to indicate (1) job titles for Course 887900, (2) course titles for "Other" (xxxx99) courses, (3) supplemental assignment for Course 880000, (4) teachers assisted by an aide, (5) aides assisting a teacher or (6) other nonstandard info | Text | 70 | ||
240 | Fiscal Agent County District | EDFiscAgentCoDist | Required | County-district code number of the fiscal agent. (Fiscal agent is the district that provides the salary.) The code number 999-999 may be used to represent an agency other than a public school with the name of the agency entered in the “Comments” area. | Fiscal_Agent_District_Codes | Text | 6 | |
250 | Min. Salary Days Worked | EDMinSalDaysWrkd | Conditional | Total number of contract days worked during the regular term by an educator receiving a minimum salary supplement. | Integer | 3 |