School Enrollment Extract (SFTP)

Students to Include

Indicate which students to include in the report by selecting one of the following options:

• The Selected [number] Students Only – Run the report for students in the current selection.
• All Students – Run the report for all students in the current school or district that meet the selection criteria.

Note: If running the report for a single student, or group of students, select the students prior to running report.

Start Date

Enter the start date for the report.

End Date

Enter the end date for the report.

Include Last Day

Select the checkbox to include school enrollments where entry date falls on the report end date entered above.

Entry / Reason for Beginning Enrollment Codes

Enter one or more entry/reason for beginning enrollment codes to filter for in the report output. Separate multiple codes by a comma, without spaces, such as: E1,N2,P3

What to do with Entry / Reason for Beginning Enrollment Codes

Choose whether to include or exclude students’ school enrollments assigned one the entry/reason for beginning enrollment codes listed above.

Exit / Reason for Ending Enrollment Codes

Enter one or more exit codes/reason for ending enrollment to filter for in the report output. Separate multiple codes by a comma, without spaces, such as: G1,S2,D3

What to do with Exit/Reason for Ending Enrollment Codes

Choose whether to include or exclude students’ school enrollments assigned one of the exit/reason for ending enrollment codes listed above.

Which Codes to Use

Choose whether you have entered entry/exit codes or reason for beginning/ending enrollment codes.

Display Header

Choose Yes or No from the pop-up menu to indicate whether to display the header (data element name) for each column in the report output.

Display grade levels 1-9 in single digit format

Select the checkbox to display grade levels 1-9 in a single digit format, as opposed to a double-digit format (01, 02, etc.).

Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically.

Please refer to the System Administrator portion of the PowerSchool Administrator User Guide for details on how to create an SFTP connection for use with this new report parameter.

Note: Remote connection requires PowerSchool 7.1.4 or higher.

1

District Code

The student’s district of responsibility code proceeded by the letters “NY.”

If the Charter and Nonpublic Schools checkbox is selected on the Edit District Information page, then the 8-digit district code and 7-digit institution code should be reported. Otherwise, the 6-digit BEDS District Code is reported. Enter the appropriate code for the report during your setup.

Valid values: See the Appendix.

If Pref NY_CHARTER_NP = 0 then ‘NY’ concatenated with Pref NY_BEDS_CODE

If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is blank then ‘8’  concatenated with Pref NY_BEDS_CODE

If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then ‘8’  concatenated with [S_NY_SCH_X]DistrictLocationCode

Yes

8

2

Location Code

The student’s building of enrollment code.

The value from the Location Code on the Transfer Info page is reported, if populated.

[S_NY_STU_X]LocationCode

[S_NY_REN_X]LocationCode

[S_NY_SCH_X]BOCESBuilding

Yes

12

3

School Year Date

June 30^th of the current school year.

The report locates the last day of the current school year and inserts 06-30 in front of the year.

[Terms]LastDay

Yes

10

4

Student ID

The school district student ID. This is a 9-digit number padded with leading zeros.

[S_NY_STU_X]PreviousStudentNumber

[Students]Student_Number

Yes

12

5

School Entry Date

The date the student enrolled in the building or grade level.

[Students]EntryDate

[ReEnrollments]EntryDate

No

10

6

School Entry Type Code

Code used on each enrollment record to indicate the reason the student’s enrollment began.

[S_NY_STU_X]R4B_EnrollCode

[Students]EntryCode

[ReEnrollments]EntryCode

Yes

6

7

School Entry Comment

Not reported.

Not reported.

No

40

8

Enrollment Grade Level

The grade level at the time of the enrollment date.

The Student School Enrollment (SSE) Grade Level, if populated on the Transfer Info page. If the SSE Grade Level field is blank, the standard PowerSchool grade level is reported from the Transfer Info page.

[Students]Grade_Level

[S_NY_STU_X]SSE_GradeLevel

[S_NY_STU_X]KindergartenCode

[ReEnrollments]Grade_Level

[S_NY_REN_X]SSE_GradeLevel

[S_NY_REN_X]KindergartenCode.

Yes

2

9

Residence Status Code

Not reported.

N/A

No

12

10

Enroll Change Code

Not reported.

N/A

No

12

11

School Exit Date

The last date of enrollment in a building or grade level.

Notes:

• This field is required if the student has exited.
• The Exit Date is reported even if the student's Exit Date occurs after the last day of the school calendar.

[Students]ExitDate

[ReEnrollments]ExitDate

Yes*

10

12

School Exit Type Code

Code used on each enrollment record to indicate the reason the student’s enrollment ended.

Note: This value is required if the student has exited.

[S_NY_STU_X]R4E_EnrollCode

[Students]ExitCode

[ReEnrollments]ExitCode

Yes*

6

13

School Exit Comment

The comment associated with the students exit.

[Students]ExitComment

[ReEnrollments]ExitComment

No

40

14

District Code of Residence

Not reported

N/A

No

20

15

Enrolled at School Year Start Indicator

Not reported

N/A

16

Location Code of Residence

Not reported

N/A

17

School Choice Transfer Indicator

Not reported

N/A

18

Grade Level Program Type Code

Not reported

N/A

19

Class of Year Code

Not reported

N/A

20

Employed Indicator

Not reported

N/A

21

Displaced Student Indicator

Not reported

N/A

22

Primary Enrollment Location Indicator

Not reported

N/A

23

Promotion Retention Reason Code

Not reported

N/A