Student Lite Extract (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.
• 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.

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. The start date is the first date that extract scans for student enrollments.

End Date

Enter the end date for the report. The end date is the last date that the extract scans for student enrollments.

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.).

Include graduation information

Choose Yes or No from the pop-up menu to indicate whether to include values for the following student fields: PostSecondaryPlans, Career Path and DiplomaTypeCode. These fields may only be submitted after June 30^th of the reporting school year. If the Yes option is selected and the report is run and submitted to the state before June 30^th, errors will be returned.

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.

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.

See the Appendix for valid values.

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_SCH_X]BOCESBuilding

Yes

6

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

Last Name

The student’s last name.

[Students]Last_Name

Yes

25

6

First Name

The student’s first name.

[Students]First_Name

Yes

7

Middle Initial

The student’s middle initial.

[Students]Middle_Name

No

1

8

Current Grade Level

The grade level of the student for the reported school year.

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.

[S_NY_STU_X]SSE_GradeLevel

[Students]Grade_Level

[S_NY_STU_X]KindergartenCode

IF

[S_NY_STU_X]State_ExcludeEnrollment =1 AND [Students]Grade_Level = 99

THEN

[S_NY_STU_X]SSE_GradeLevel

[Students]Grade_Level

Yes

3

9

Homeroom

The homeroom, as determined by each building/school.

[Students]Home_Room

No

6

10

Birth Date

The student’s date of birth on the student’s birth certificate, or an official source as directed by district policy. The birth date cannot be greater than the current date.

[Students]DOB

Yes

10

11

Gender Code

The student’s gender as identified by the parent/guardian.

Valid values:

• M – Male
• F – Female

[Students]Gender

Yes

6

12

Race Code 1

The student’s ethnicity as identified by the parent/guardian. If there is more than one ethnicity, report the primary ethnicity. Otherwise, report multiracial and report the ethnicities in fields 43 through 46.

Valid values:

• I – American Indian or Alaska Native
• A – Asian
• B – Black or African American
• W – White
• P – Native Hawaiian/Other Pacific Islander

Note: Review additional information about federal race and ethnicity settings.

[StudentRace]RaceCd

Yes

2

13

Home Language Code

The student’s home language.

See Appendix 3: Language Codes and Descriptions in the SIRS Manual.

[Students]PrimaryLanguage

No

16

14

Challenge Type

Not Reported.

N/A

No

30

15

Level of Integration

Not Reported.

N/A

No

15

16

LEP Participation

Not Reported.

N/A

No

3

17

The cumulative number of years the student has received LEP services. The value must be between 0 and 25 years.

If the student has a program service code of 0231, then this field must be populated.

• 1 – Students with up to one year of bilingual or ESL instruction
• 2 – Students with up to years of bilingual or ESL instruction
• 0 – Students who have never received LEP services

* This field is required for LEP students.

[S_NY_STU_Demographics_X]ELLDuration

Yes*

2

18

Post Graduate Activity

The student’s planned postgraduate activity.

This field is required only for graduated students, high school completers, and students with disabilities who are reaching the maximum age for educational services.

See the Appendix for valid values.

[S_NY_STU_X]PostGradDestination

Yes*

30

19

Student Status

The student’s status, either active or inactive.

If the student’s school Exit Date occurs before the report end date, then the value is reported as I. Otherwise, the value is reported as A.

[Students]ExitDate

Yes

1

20

Last Status Date

For Active students, the date of the extract or the last day of the school year is reported.

For inactive students, the student’s exit date is reported. Students are considered inactive if they exited before the report end date.

Derived from the earliest of the following dates:

Extract Date

[Students]ExitDate

6/30/YYYY

Yes*

10

21

Poverty Code

Not reported

N/A

No

1

22

Population Code

Not reported

N/A

No

1

23

Mobility Code

Not reported

N/A

No

1

24

Diploma Type Code

The credential earned by the student.

* This field is required for graduated students and high school completers only.

See the Appendix for valid values.

[S_NY_STU_X]DiplomaType

Yes*

3

25

Program Services Code

Not reported

N/A

No

1

26

Date of Entry into Grade 9

The date the student first entered 9^th grade, anywhere. This date cannot be in the future and cannot occur before the student’s date of birth.

If the student’s Date of Entry into Grade 9 field is populated on the Demographics (Student Lite) page, the value is reported.

* This field is required for students who have completed or are currently enrolled in the 9^th grade.

[S_NY_STU_X]DateOfEntryGrade9

Yes*

10

27

Service Provider

The 12-digit BEDS code of the feeder school, which must not contain 3^rd grade or above.

* This field is required if both the following are true:

• The student was in grade level 3 in 2009-2010 and in a different school in the same district during 2^nd grade (2008-2009) or during 1^st grade (2007-2008).
• The student was continuously enrolled in the highest grade served by the feeder school.

The Service Provider code is reported, if populated on the Demographics (Student Lite) page.

[S_NY_STU_X]BackmappingBEDSCode

Yes*

20

28

Inoculation Date

Not reported.

No

10

29

Address 1

[Students]Street

No

30

30

Address 2

The second line of the student’s principal address, not reported by PowerSchool.

• Reported as blank if Address 1 is reported as 'Unknown'

N/A

No

30

31

City

The city of the student’s principal residence.

• Reported as blank if Address 1 is reported as 'Unknown'

[Students]City

No

25

32

State

The 2-character USPS state code for the student’s principal residence.

• Reported as blank if Address 1 is reported as 'Unknown'

[Students]State

No

2

33

Zip Code

The 5- or 9-character USPS zip code for the student’s principal residence.

• Reported as blank if Address 1 is reported as 'Unknown'

[Students]Zip

No

10

34

Home Phone

The area code and phone number for the student’s principal residence.

[Students]Home_Phone

No

14

35

Primary Guardian Name

The name of the parent or legal guardian who enrolled the student.

One of the following possible names is reported, based on the priority listed:

• Guardian
• Mother
• Father

[Students]guardian_fn

[Students]guardian_ln

[Students]Mother

[Students]Father

No

40

36

Alternate Guardian Name

The name of the second parent or legal guardian who enrolled the student.

One of the following possible names is reported, based on the priority listed:

• Guardian
• Mother
• Father

Note: If only one of the three values above is populated, the alternate guardian is reported as blank.

[Students]guardian_fn

[Students]guardian_ln

[Students]Mother

[Students]Father

No

40

37

Place of Birth

The student’s place of birth.

[S_NY_STU_Demographics_X]BirthCity

[S_NY_STU_Demographics_X]BirthState

[S_NY_STU_Demographics_X]BirthRegion

[S_NY_STU_Demographics_X]BirthCountry

No

50

38

Date of Initial Entry to U.S.

Not reported.

10

39

Years in U.S. Schools

Local use only

[S_NY_STU_Demographics_X]YearsInUSSchools

No

4

40

Country of Origin

Not reported.

4

41

District Code of Residence

The student’s district of residence as of the BEDS day (the first Wednesday in October). This value should be reported as the full New York state code, such as NY123456. If a student moves to and enrolls in a new district subsequent to BEDS day, the new district should report the student with the District of Residence code for that new district.

The value is reported from one of the following fields in the order listed:

• District Code of Residence Override from the student’s Demographics (Student Lite) page.
• District of Residence as populated in the student’s current enrollment.
• District Number from the District Info page at the District Setup level.

Note: If the student is a resident of a state other than New York, then the value 80034366 should be reported.

[S_NY_STU_Demographics_X] DistrictOfResidenceOverride

[Students]DistrictOfResidence

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

42

Hispanic Ethnicity Indicator

Indicates whether the student is Hispanic/Latino.

Note: Decline to specify is not an option for NY.

[Students]Fedethnicity

Yes

3

43

Race 2 Code

If a student is identified as multiracial in field 12, then fields 43 through 46 are used to report the individual racial/ethnic groups to which the student belongs, if available.

[StudentRace]RaceCd

Yes*

4

44

Race 3 Code

If a student is identified as multiracial in field 12, then fields 43 through 46 are used to report the individual racial/ethnic groups to which the student belongs, if available.

[StudentRace]RaceCd

Yes*

4

45

Race 4 Code

If a student is identified as multiracial in field 12, then fields 43 through 46 are used to report the individual racial/ethnic groups to which the student belongs, if available

[StudentRace]RaceCd

Yes*

4

46

Race 5 Code

If a student is identified as multiracial in field 12, then fields 43 through 46 are used to report the individual racial/ethnic groups to which the student belongs, if available.

[StudentRace]RaceCd

Yes*

4

47

Homeless Status

Indicates if the student is homeless.

Valid values:

• 1 or Y = Y
• Blank, 2 or N = N

[S_NY_STU_Demographics_X]Homeless

Yes

3

48

Migrant Status

Indicates if the student is a migrant.

Valid values:

• 1 or Y = Y
• Blank, 2 or N = N

[S_NY_STU_Demographics_X]Migrant

Yes

8

49

Immigrant Indicator

Indicates if the student is an immigrant. If Yes, then fields 38 through 40 are required.

Valid values:

• 1 or Y = Y
• Blank, 2 or N = N

[S_NY_STU_Demographics_X] Immigrant

Yes

3

50

Neglected/Delinquent Indicator

Indicates if the student is neglected or delinquent.

Valid values:

• 1 or Y – Y
• Blank, 2 or N – N

[S_NY_STU_X]Neglected

Yes

3

51

Homeless Primary Nighttime Residence

Not reported

NA

No

8

52

Native Language

Not Reported

N/A

No

8

53

Career Path Code

Code used to identify pathway student used to graduate. Populate with code.

See the Appendix for valid values.

Note: The report defaults to “None” if the Career Path field is blank and a diploma is being extracted.

[S_NY_STU_Demographics_X]CAREER_PATH

Yes*

20

The extract will use the District Code for the school unless an override is specified.

Notes:

• The report will extract this field even when run in non-audit/header mode.
• The guidance counselor code should be formatted with a leading "NY" e.g. "NY######"

Indicates the guidance counselor assigned to a student.

Note:

• The report extracts this field even when run in non-audit/header mode.
• The report extracts a value with leading zeroes to make the value a total of 12 characters.
• The report extracts IDs for active Guidance Counselors only.

[S_NY_SCH_COUNSELOR_C]Id_Number