EIS Extracts

The Tennessee extract process uses a transactional model for reporting, meaning that when an event occurs, such as changing a student's grade level, a record of the change is stored in the [StateEventQueue] table in the PowerSchool database. Changes to data are recorded as they occur, so that all changes are reported, rather than just the state of the data on a particular date (snapshot).

Extracts are listed in the following table. This table includes the following elements:

Extract # – Number of the extract as seen in PowerSchool.
Report Name – Name of the report as seen in PowerSchool.
Description – The purpose of the report.
Due Date / Cycle – The timeframe during which the report is submitted to the state.

Extract #	Report Name	Description	Due Date / Cycle
010	200 Day Calendar	This extract includes data regarding the number of different types of days assigned to the district calendar, such as days for inclement weather, parent-teacher conferences, etc.	District calendars, extracts 010 and 011, should be sent and corrected before school calendars. The first transmission is due no later than April 30^th.
011	200 Day Event Calendar	This extract includes a record for each calendar event, such as in-service day, teacher vacation, etc.	District calendars, extracts 010 and 011, should be sent and corrected before school calendars. The first transmission is due no later than April 30^th.
015	District Bus Information	This extract includes information related to district bus information.	The first transmission is due no later than August 21^st.
016	District Bus Staff	This extract includes information related to district bus staff.	The first transmission is due no later than August 21^st.
020	Instructional Program	This extract includes a record for each instructional program created at the school level.	School calendar data, extracts 020, 021, and 022, must be sent and corrected before subsequent extracts. The first transmission is due no later than April 30^th.
021	Instructional Program Report Period	This extract includes a record for each reporting segment set up at the school level, used to determine instructional program report periods.	School calendar data, extracts 020, 021, and 022, must be sent and corrected before subsequent extracts. The first transmission is due no later than April 30^th.
022	School Days	This extract includes a record for each school day in the calendar for the current school year.	School calendar data, extracts 020, 021, and 022, must be sent and corrected before subsequent extracts. The first transmission is due no later than April 30^th.
030	Class Section	This extract includes a record for each section taught during the current school year.	Basic extract types for student, staff and classes, extracts 040, 060, 062, and 030, should be sent and corrected before other extract types. The first transmission is due no later than July 15^th.
031	Class Section Schedule	This extract includes a record with the day and period schedule for each section taught during the current school year.	Basic extract types for student, staff and classes, extracts 040, 060, 062, and 030, should be sent and corrected before other extract types. The first transmission is due no later than July 15^th.
040	Student	This extract includes a record of demographic data for each student active at some point during the current school year.	Basic extract types for student, staff and classes, extracts 040, 060, 062, and 030, should be sent and corrected before other extract types. The first transmission is due no later than July 15^th.
041	Student Enrollment	This extract includes a record for each school enrollment for students active at some point during the current school year.	The first transmission is due no later than July 15^th.
042	Student Ineligibility Funding Status	This extract includes a record for each student with ineligibility funding status.	The first transmission is due no later than August 21^st.
043	Student Instructional Grade	This extract includes a record of the grade level for each student active at some point during the current school year.	The first transmission is due no later than August 21^st.
044	Student Classification	This extract includes each student classification record during the current school year, such as adult, homeless, Title I.	The first transmission is due no later than August 21^st.
045	Student Transportation	This extract includes each transportation (bus) record for students during the current school year.	The first transmission is due no later than August 21^st.
046	Student Disciplinary Action	This extract includes a record for each disciplinary log entry created for students during the current school year.	The first transmission is due no later than August 21^st.
047	Student Standard Day	This extract includes a record of the regular number of minutes per day spent at school for each student during the current school year.	The first transmission is due no later than August 21^st.
048	Student Class Assignment	This extract includes a record for each section enrollment for students in the current school year.	The first transmission is due no later than August 21^st.
049	Student Attendance	This extract includes a record for each absent attendance day per student during the current school year. The extract also includes a record for each newly assigned present attendance day – a "present" for a date that was previously recorded as "absent."	The first transmission is due no later than August 21^st.
050	Student Withdrawal	This extract includes a record for each school enrollment with an exit date during the current school year.	The first transmission is due no later than August 21^st.
051	Student End of Service	This extract includes a record that indicates the status of each student school enrollment at the end of the school year: promoted, retained, or demoted.	The first transmission is due no later than August 21^st.
052	Student Club Membership	This extract includes a record for each student club membership during the current school year.	The first transmission is due no later than August 21^st.
060	Staff Member	This extract includes a demographic record for each staff member serving the school during the current school year.	Basic extract types for student, staff and classes, extracts 040, 060, 062, and 030, should be sent and corrected before other extract types. The first transmission is due no later than July 15^th.
062	Staff Member Current Assignment	This extract includes a record for each staff member assignment during the current school year, such as Title I, kindergarten, consulting, etc.	The first transmission is due no later than August 21^st.
063	Staff Member Class Assignment	This extract includes a record for each section taught by a staff member during the current school year.	The first transmission is due no later than August 21^st.
080	Student Final Grade	This extract includes a record for each final grade that matches a specific store code (S1, S2, etc.) and is awarded to students during the current school year.	The first transmission is due no later than August 21^st.
081	Student TA Instructional Assistance	This extract includes records for student TA Instructional Assistance	The first transmission is due no later than August 21^st.
082	Student TA Support Services	This extract includes records for student TA Support Services	The first transmission is due no later than August 21^st.
083	Student Choice Applied (Deprecated)	This extract includes records for student applied choice.	Note: This report is deprecated as of the 2017-18 school year.

Back to Top