Educator School Report

Contents

Report Description

The Educator School File requires a single record for every position an educator serves in a school. This file collects one or more records for each building in the district where the educator has a position code or approved career education position.

This report can only be run at the District Level.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.

Staff Selection

The report selects records from the [Users] tables based on the following criteria:

The staff member must be associated with the schools included in the report.
The staff member's school must not be excluded from state reporting.
The staff member must not be excluded from state reporting.
The staff member's social security number must not be blank.
The staff member's Status on the Edit Information page must be Current (1).

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Year	The pop-up menu defaults to the currently selected school year. To change the school year, click Term at the top of the page and choose the appropriate school year term.

Report Output

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Note: In the Required column, a value of "C" indicates that the element is conditional – if the element applies to the particular record, then it is required.

Item	Data Element	Description	[Table]FieldName	OCT
005	Collection Version	The report concatenates the current year, such as 2012 for the 2011-2012 school year, the reporting cycle, followed by 1.0EdSchool. For example: 2012Oct1.0EdSchool	[Terms]LastDay	R
010	Current School Year	The ending year of the current school year, such as 2012 for the 2011-2012 school year.	[Terms]LastDay	R
025	Reporting District Code	The district responsible for reporting the educator's data.	[Prefs]Value [Prefs]Name=districtnumber	R
030	Reporting School Code	The educator's school number. If the alternate school number is less than 4 digits, then the alternate school number is reported. If the alternate school number is not populated for the school, then if the school number is less than 4 digits, the school number is reported.	[Schools]Alternate_School_Number [Schools]School_Number	R
050	ED SSN	The educator's social security number reported with the dashes removed.	[Users]SSN	R
060	Legal Last Name	The educator's legal last name.	[Users]Last_Name	O
065	Legal First Name	The educator's legal first name.	[Users]First_Name	O
070	Position Code	The educator's position code. Note: For code sets go to MO Code Set Document	[S_MO_CRS_X]PositionCode	R
080	CTE Program Type	The program type code for the educator's CTE-approved program.	[Teachers]MO_ProgType	C
090	FTE	The educator's full-time equivalency is the percent of the time the educator works in the associated attendance centre.	[S_MO_SSF_X]FTE	R
100	Salary	The educator's salary, which they receive for the associated position and attendance centre, includes only regular term and extended contract salary.	[S_MO_SSF_X]Salary	R
110	CTE Month	The total number of months the educator is contracted for a CTE program.	[S_MO_SSF_X]CTEMonth	C
120	Late Start Date	The date the educator was hired or replaced by another educator after the beginning of the school year.	[S_MO_SSF_X]LateHireDate	C
130	Early End Date	The date the educator was terminated or replaced by another educator prior to the end of the school year.	[S_MO_SSF_X]EarlyTermDate	C
140	Course Comment	Comments regarding the teacher.	[S_MO_SSF_X]CourseComments	C
150	Baseline Salary Grant	Indicates the baseline salary granted to the staff.	[S_MO_USR_X]BaseSalaryGrant