Partner Project Fact Extract (SFTP)

Introduction

This extract contains data for P-Tech and Smart Scholars programs and captures additional data related to the specific program partners. The student's association with P-Tech and Smart Scholars programs is reported with a specific Project Number and the corresponding start and end dates.

Selection Criteria

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

Student Selection

The report selects records from the [Students] and [ReEnrollments] tables based on the following criteria:

The student's has one or more valid enrollment that is active during the current school year. A valid school enrollment is one that has not been excluded from state reporting at the school, student or enrollment level.

Program Selection

The report selects records from the [S_NY_STU_PARTNERPRJTFACT_C] table based on the following criteria:

For students meeting the Student Selection criteria noted above, the report output will include all Partner Project Fact records that are active at any point during the current school year.

School level Partner Project Fact records that meet any of the following criteria are included in the report output regardless of the school selected when the report is generated and are reported with a location code of 0000:

The School ID of the program is a mismatch (a valid and matching school enrollment does not exist for this student in the current school year)
The School ID of the program is an invalid value (the School ID does not exist in the Schools table)

Report Input

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

Field	Description
Use	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.
Data to be Filled	Select the checkbox next to the filter fields to save the settings as defaults. To select all checkboxes, choose Select All from the pop-up menu. To clear all checkboxes, choose Clear All.
Run Report with Audit Fields and Headers	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, as well as to display additional fields used to audit the data in the report.
Start Date	Enter the start date for the report. Enter a date range within a single academic year. Example: 07/01/2009 - 06/30/2010. Note: Choose a term at the top of the page that falls within the date range for which the report is being run. For example, if the report is run for 07/01/2009 - 06/30/2010, any term within the 09-10 year can be selected, such as 09-10 Semester 1.
End Date	Enter the end date for the report. Enter a date range within a single academic year. Example: 07/01/2009 - 06/30/2010.
SFTP Connection	Choose an SFTP connection 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.

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	Req	Max Length
1	District Code	The student’s district of responsibility code. Public Schools: Extracted as NY + 6-digit BEDS code. This is entered on the District Code field on the Edit District Information page. Charter or Nonpublic Schools: Extracted as 8 + last seven digits of the Institution Code. This is entered on the District Code field on the Edit District Information page. Select the Charter and Nonpublic Schools checkbox. 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	School Year Date	June 30^th of the current school year displays by default.	[S_NY_STU_PARTNERPRJTFACT_C]SchoolYear	Yes	10
3	Student ID	The school district student ID. This is a nine-digit number padded with leading zeros.	[S_NY_STU_X]PreviousStudentNumber [Students]Student_Number	Yes	12
4	Project ID (Number)	Report Project ID or number assigned by NYSED for P-Tech and Smart Scholars programs.	[S_NY_STU_PARTNERPRJTFACT_C]ProjectID	Yes	12
5	Project Start (Entry) Date	The start date of the student's entrance into the program which must be between July 1st and June 30th of the reported school year.	[S_NY_STU_PARTNERPRJTFACT_C]ProjectStartDate	Yes	10
6	Project End (Exit) Date	The end date of the student's participation in the program, which must be between July 1st and June 30th of reporting school year. Leave blank until the program service actually ends.	[S_NY_STU_PARTNERPRJTFACT_C]ProjectEndDate		10
7	Student Project Location Code For school level programs, this value is derived based on the school ID stored in the program record. This value may be modified on the Edit Program Service page.	Typically the building code which uniquely identifies the building in which a student is receiving the service. If the Program Service Level is District, the following value is reported: Public schools - 0000 Charter and Nonpublic schools - the school’s Location Code If the Program Service Level is School, the Local BOCES Building code is reported from the appropriate Edit School page.	[S_NY_STU_PARTNERPRJTFACT_C]LocationCode		6
8	Programs Code	The program service code is associated with the record. Valid values: see the Appendix. Records with Program Codes, 4026, 4027, and 4037 have been excluded from the report.	[S_NY_STU_PARTNERPRJTFACT_C]ProgramCode		8
9	Program Selection Criteria 1	The selection criteria code for P-TECH and Smart Scholars ECHS students (Program Service Codes 4026, 4037).	[S_NY_STU_PARTNERPRJTFACT_C]SelCriteria1		25
10	Program Selection Criteria 2	Additional selection criteria codes for P-TECH and Smart Scholars ECHS students (Program Service Codes 4026, 4037).	[S_NY_STU_PARTNERPRJTFACT_C]SelCriteria2		25
11	Program Selection Criteria 3	Additional selection criteria codes for P-TECH and Smart Scholars ECHS students (Program Service Codes 4026, 4037).	[S_NY_STU_PARTNERPRJTFACT_C]SelCriteria3		25
12	Program Selection Criteria 4	Additional selection criteria codes for P-TECH and Smart Scholars ECHS students (Program Service Codes 4026, 4037).	[S_NY_STU_PARTNERPRJTFACT_C]SelCriteria4		25
13	Program Selection Criteria 5	Additional selection criteria codes for P-TECH and Smart Scholars ECHS students (Program Service Codes 4026, 4037).	[S_NY_STU_PARTNERPRJTFACT_C]SelCriteria5		25
14	Program Duration	The duration of an NYS P-Tech program and NYC P-Tech program to distinguish those students as being in their 5th and 6th year of high school. This field is required for any student with a Program Service Code of 4026 or 4027 (Early College Scholar). Valid values: 1, 2, 3, 4, 5, 6, 7, or 8.	[S_NY_STU_PARTNERPRJTFACT_C]PgrmDuration		4
15	Annual Outcome Code (Program)	The selected Annual Outcome codes.	[S_NY_STU_PARTNERPRJTFACT_C]AnnualOutcomeCode		3
16	Annual Credential Status (Program)	Left blank.	[S_NY_STU_PARTNERPRJTFACT_C]AnnualCredStatus		3
17	Industry Partner 1 Name	The name of the Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartnerName1		50
18	Industry Partner 1 Type	The type of Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartner1		3
19	Industry Partner 2 Name	The name of the Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartnerName2		50
20	Industry Partner 2 Type	The type of Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartner2		3
21	Industry Partner 3 Name	The name of the Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartnerName3		50
22	Industry Partner 3 Type	The type of Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartner3		3
23	Industry Partner 4 Name	The name of the Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartnerName4		50
24	Industry Partner 4 Type	The type of Industry partner the student is working with.	[S_NY_STU_PARTNERPRJTFACT_C]IndPartner4		3
25	Career Pathway (Program) Code	The career pathway program for the student.	[S_NY_STU_PARTNERPRJTFACT_C]CareerPathwayCode		10
26	Internship or Apprenticeship Type Code	The internship or apprenticeship type code.	[S_NY_STU_PARTNERPRJTFACT_C]InternshipTypeCode		20
27	Internship or Apprenticeship Name	The name of the Internship or apprenticeship entity.	[S_NY_STU_PARTNERPRJTFACT_C]InternshipTypeName		50
28	Paid Internship Indicator	Indicates whether it is a paid internship. Valid values: Yes No	[S_NY_STU_PARTNERPRJTFACT_C]PaidInternshipInd		3
29	Post Project (College) Employer Name	The name of the post-college employer, if available.	[S_NY_STU_PARTNERPRJTFACT_C]PostProjectEmpName		50
30	Post Project (College) Job Title	The job title held with the post-college employer, if available.	[S_NY_STU_PARTNERPRJTFACT_C]PostProjectJobTitle		50