Skip to main content
Skip table of contents

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.

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

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.