EIS 050 Student Withdraw Extract (Tennessee)

PATH:  TN State Reporting > EIS Batch Transmission File

The 050 Student Withdraw extract reports records for students who withdraw from school to EIS. Students are only considered to have withdrawn if they leave during the school year. The withdrawal date reported to EIS is one day after the entered Withdraw date to account for the student's last day of attendance.

See the EIS Batch Transmission article for an overview of the EIS Batch Transmission File, logic that applies to all extracts, and generation instructions.

Report Logic

A record reports for each Primary or Partial enrollment that has an End Date entered. Records are not reported in advance for enrollments that become active in the future.

Records in Calendars or Grade Levels marked as Exclude or for students who do not have a Student State ID are not reported. Additionally, records are not reported for the following students. These students are included in the warning report. 

  • Students without PINs. 
  • Students with multiple active Primary enrollments.
  • Students with multiple enrollments in the same school.
  • Students with an enrollment marked as N: Special Ed Services
  • Enrollments marked as No Show or Exclude.

The Record Key, which helps determine the Type of record sent (New, Edit, or Delete), is comprised of the Record ID, Record Version, District ID,  School ID, School Year, Instructional Program Number, State Assigned Student ID, and Withdraw Date.

050 Student Withdraw Extract Layout

Element Name

Description & Format

Campus Location

Record ID

Identifies the extract - reports as "049"


Numeric (3)

N/A

Record VersionIdentifies the extract version - reports as "01"

Numeric (2)
N/A
Record Type

Identifies the type of extract:

  • N: New
  • E: Edit
  • D: Delete

Character (1)

N/A
FillerN/A. Reports as 00.
N/A
District IDReports the TN Department of Education assigned District Number.

Numeric (3)
System Administration > Resources > District Information > State District Number

District.number
School IDReports the TN Department of Education assigned School Number

Numeric (4)
System Administration > Resources > School > State School Number

School.number
School YearReports the start year of the school calendar.

Date (4) CCYY
System Administration > Calendar > School Years > Start Year

SchoolYear.startYear
Instructional Program NumberReports the unique Instructional Program Number of the school, or as 99 if blank.

Numeric (2)
System Administration > Calendar > Calendar > Instructional Program Number

Calendar.instructionalProgramNumber
Student Social Security NumberReports the student's social security number.

Numeric (9)
Census > People > Identities > Current Identity > Soc Sec Number

Identity.ssn
Student PINReports the unique student identifier provided by the school.

Numeric (9)
Census > People > Demographics > Person Identifiers > Student PIN

Person.additionalID
Local Student KeyReports the locally-generated student identifier.

Numeric (10)
Census > People > Demographics > Person Identifiers > Local Student Number

Person.studentNumber
Withdraw Date

Identifies the first first day on which the student did not attend school.

Reports the next day marked as School in the Day Detail.


Date (8) CCYYMMDD

Student Information > General > Enrollments > End Date

Enrollment.endDate
Withdraw ReasonIdentifies the reason the student was withdrawn from the school. If End Status is 98, reports as 01. If End Status is 97, reports as 00. Otherwise reports End Status.

Numeric (2)
Student Information > General > Enrollments > End Status

Enrollment.endStatus
State Assigned Student ID Reports the unique state-assigned student ID generated in EIS.

Numeric (9)
Census > People > Demographics > Person Identifiers > Student State ID

Person.stateID
FillerN/AN/A

 

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save