051 – Student End of Service

Introduction

This extract includes a record that indicates the status of each student school enrollment at the end of the school year, either promoted, retained, or demoted.

Selection Criteria

051 records will be created in the EIS file for a student who has 051 record(s) with the following conditions:

For No-show students (STUDENTS.entryDate = STUDENTS.exitDate), the STUDENTS.exitCode must be 12
S_TN_STU_X.ENDOFSERVICEACTION cannot blank
STUDENTS.exitDate has to be in the school year ( the Term Year setup on the Start Page > Special Functions > Interfaces to Other Systems > Tennessee Education Information System (EIS) > Set Current Term Year page)

Note: If the STUDENTS.exitDate is outside of the School Year, the 051 record will NOT be created in the EIS file even though the student has a 051 record in the STATEEVENTQUEUE from the Recreate

Report Input

For help with navigation and extract generation, see Create Selected Student Related Extract File.

Extract Output

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

Item #	Data Element	Description	[Table]FieldName	Field Length	Track
1	Record ID	The identifier of this record.	Always "051"	3	N
2	Record Version	The version of this record.	Always "01"	2	N
3	Record Type	One of the following record types is reported in order to indicate how to modify the state data to match data in PowerSchool. The data in this record either needs to be added to, modified in, or deleted from the state data: N – New E – Edit D – Delete	N/A	1	N
4	Filler	N/A	N/A	2	N
5	District ID	The district number.	[Prefs]Value [Prefs]Name=districtnumber	3	N
6	School ID	The school number.	[Schools]Alternate_School_Number - if populated Otherwise: [Students]Enrollment_SchoolID	4	N
7	School Year	The four-digit year that the instructional program will be operated to provide instructional services to students. This is the current full year term, as defined using the special operation. See the District Setup > Years & Terms section for more information.	[Terms]FirstDay [Terms]LastDay	4	N
8	Instructional Program Number	The number used to uniquely identify the program within the school. Valid values: 01, 02, 03, 04, 05, or 06.	[Students]Track	2	N
9	Student Social Security Number	The student's social security number.	[Students]SSN	9	N
10	Student PIN	The student's PIN, if the social security number is not provided or reported.	[S_TN_STU_X]StudentPIN	9	N
11	Local Student Key	The internal ID assigned to the student's record in the PowerSchool database.	[Students]ID	10	N
12	End of Service Action Date	The date the student ended this school enrollment.	[Students]ExitDate	8	N
13	End of Service Action	Indicates the student's progression at the end of the school enrollment. Valid values: P – Promoted R – Retained D – Demoted	[S_TN_STU_X]EndOfServiceAction	1	Y
14	Completion Document Date	The date that the student's end of service documentation is complete.	[S_TN_STU_X]CompletionDate	8	Y
15	Completion Document Type	The type of documentation complete for the student at the end of the school enrollment. Valid values: N/A 1 – Regular Diploma 3 – Special Education Diploma 6 - GED 8 - Alternate Academic Diploma 11 - Regular Diploma with Foreign Language Waiver 12 - Regular Diploma with Fine Arts Waiver 13 - Regular Diploma with Foreign Language and Fine Arts Waiver	[S_TN_STU_X]Completion	2	Y
16	Completion Document Period	The graduation period for the student. Valid values: 3 – Early 1 – Spring 2 – Summer	[S_TN_STU_X]GraduationPeriod	2	Y
17	State Assigned Student ID	The state assigned student identifier.	[Students]State_StudentNumber	9	N
18	Filler	N/A	N/A	11	N