Student Class Entry Exit (SFTP)

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list.
• District Wide – Includes all student records on the PowerSchool server that meet selection criteria.

Note: The District Wide option is only available when running the report from the District Office.

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 report start date.

End Date

Enter the report end date.

SFTP connections

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 6-digit BEDS District Code is reported. Charter and nonpublic schools, state agencies, state-operated schools, and childcare institutions should report 8nnnnnnn (8 followed by the last 7 digits of their institution code).

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

8

2

Location Code

The local BOCES building code for the school associated with the stored grade record.

Notes:

• This is the SchoolID for the school the student was enrolled in at the time the class records were generated.
• For remote enrollments, the SchoolID where the remote class is taught is extracted.

[S_NY_SGR_X]LocationOverride

[StoredGrades]SchoolId

[S_NY_SCH_X]BOCESBuilding

[CC]SchoolID

6

3

Course Code Long

Local course code

[S_NY_CRS_X]AlternateCourseNumber

[Courses]Course_Number

12

4

School Year Date

June 30 of the reporting school year. Example: 2015–16 = 2016-06-30

Derived

10

5

Supplementary Course Differentiator

Not reported

Note: This field is auto-populated with N/A.

N/A

N/A

6

Section Code Long

Local section code

[Sections]Section_Number

25

7

Student ID

The unique identified assigned by the LEA in which the student is enrolled. This is a 9-digit number padded with leading zeros.

[S_NY_STU_X]PreviousStudentNumber

[Students]Student_Number

9

8

Class Entry Date

The date on which the student entered the class.

Note: The report extracts the class entry date as the first in-session day.

[CC]dateenrolled

10

9

Class Entry Type Code

Not Reported

N/A

N/A

10

Class Entry Comment

Not Reported

N/A

N/A

11

Class Exit Date

The date on which the student exited the class.

Note: Future dates are not extracted

[CC]dateleft

10

12

Class Exit Type Code

Not reported

N/A

N/A

13

Class Exit Comment

Not reported

N/A

N/A

14

Class Period

Not reported

N/A

N/A

15

Course Delivery Model Code

Not reported

N/A

N/A

16

Course Content Code

Not reported

N/A

N/A

17

Course Inclusion Code

Not reported

N/A

N/A

18

Special Program Code

Not reported

N/A

N/A

19

Alternate Credit Course Code

Not reported

N/A

N/A

20

Course Instructor Snapshot Date

Not reported

N/A

N/A

21

Homeroom Indicator

Not reported

N/A

N/A

22

Student Grade Level Code When Taken

Not reported

N/A

N/A

23

Exclude from Evaluation Indicator

Not reported

N/A

N/A

Used to identify the school calendar term for which a course/section is being reported.

See the SIRS Manual for more information.

[NY_MarkingPeriods]Term Code

[VirtualTablesData2]Term Code

[S_NY_CC_X]DualCrInd

[S_NY_SEC_X]DualCrInd

Indicates the district code of the district where the student is enrolled. This field is used for situations in which the student is enrolled in a geographic district other than the one where the course is offered. If no Student District Code (Enrolled) is entered, the report extracts the District Code.