Student Contact Extract (SFTP)

Introduction

This report includes a record for each student contact relationship. The report includes student number, contact id and relationship code.

As of the 2015-2016 school year, this report is no longer submitted to the state and is for Local Use Only

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Course Enrollment Selection

The report selects records based on the following criteria:

Current or all schools
Student selection
Select to display header
Select an SFTP delivery

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
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. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools 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.
Display Headers	Choose one of the following from the pop-up menu: Yes – Include the Alternate Staff ID as an audit field and include headers in the report output. The audit field assists with troubleshooting and the headers provide a title for each data element. No – Do not include the audit field or the headers.
Please select the Type of Report	Choose one of the following from the pop-up menu: Roster Report – Report June 30^th of the current school year as the Relationship End Date. Evaluation Report – Report the Assessment Administration Start Date (populated on the Edit Course page) as the Relationship End Date, unless the current date is sooner, in which case the current date is reported.
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.

Back to Top

Report Output

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

Item #	Data Element	Description	[Table]FieldName	Max Length
1	District Code	The district code of the LEA that employs the teacher. This should be the same as the district code for the reporting district.	If Pref NY_CHARTER_NP = 0 then 'NY' concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [Schools]NY_DistLocCode or [S_NY_SCH_X] DistrictLocationCode is blank then '8' concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [Schools] NY_DistLocCode or [S_NY_SCH_X] DistrictLocationCode is not blank then '8' concatenated with [Schools]NY_DistLocCode or [S_NY_SCH_X]DistrictLocationCode 'NY' concatenated with Pref NY_BEDS_COD If Pref NY_CHARTER_NP = 1 and [Schools] NY_DistLocCode or [S_NY_SCH_X] DistrictLocationCode is blank then '8' concatenated with Pref NY_BEDS_COD If Pref NY_CHARTER_NP = 1 and [Schools] NY_DistLocCode or [S_NY_SCH_X] DistrictLocationCode is not blank then '8' concatenated with [Schools]NY_DistLocCode or [S_NY_SCH_X]DistrictLocationCode	8
2	School Year Date	This value is reported as June 30^th of the school year. Term at the top of the page and choose the appropriate term from the pop-up menu.	[Terms]LastDay	10
3	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.	[Students]NY_LocalStudentID or [S_NY_STU_X]PreviousStudentNumber [Students]Student_Number	12
4	Contact ID	Unique identifier assigned to the contact by the Local Education Agency (LEA) reporting the data. Use 9 numeric characters, left padded with zeros.	[S_NY_Contacts]Primary_Contact_ID	9
5	Reporting Date	June 30^th of the current school year.	Derived	20
6	Contact Relationship Code	Use Contact Relationship Code. See Contact Relationship codes in the SIRS Manual.	[S_NY_Contact_Relationship]Relationship_Code	20
7	Contact Authorization Code	Use '01'	N/A	N/A
8	Contact Sequence Number	Not reported	N/A	N/A
9	Active Indicator	Yes = Yes, contact is currently connected to student for purposes of Field #7.	If [S_NY_Contact_Relationship]END_DATE is less than current date then 'N' otherwise 'Y'	3
10	Primary Contact Indicator	Not reported	N/A	N/A
11	Student Lives with Contact Indicator	Not reported	N/A	N/A
12	Emergency Contact Indicator	Not reported	N/A	N/A
13	Contact Restrictions Description	Not reported	N/A	N/A

Back to Top