Student Class Grade Detail Extract (SFTP)

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.

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.

Run Report with Audit Fields and Headers

Choose one of the following from the pop-up menu:

• Yes – Include audit fields and headers
• No – Do not include the audit field or the headers.

Start Date

Enter the report start date.

End Date

Enter the report end date.

Grade Type Codes

Select one or more grade type codes to be included in the report results.

Classes to Include

Select one of the following options:

• All completed and dropped classes with stored grades
• All completed and dropped classes without stored grades
• All completed, dropped and in progresses classes without stored grades

Include Grade/Credit values for primary grades

Select the checkbox to include values for Numeric Grade, Credits Attempted and Credits Earned in the report.

Note: If not checked, Records are generated for students whose grade level is below 7 and the Numeric Grade, Credits Attempted and Credits Earned fields will be blank.

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.

[S_NY_SGR_X]LocationOverride

[StoredGrades]SchoolId

[S_NY_SCH_X]BOCESBuilding

N/A

N/A

Audit Field

Where Taught

N/A

Audit Field

Section SchoolID

3

Course Code

Local course code

[S_NY_CRS_X]AlternateCourseNumber

[Courses]Course_Number

12

4

School Year Date

The report extracts June 30^th of the school year chosen at report runtime. EX: When the 2013-2014 school year is selected, the date reported in this column will be 2014-06-30.

N/A

N/A

5

Supplementary Course Differentiator

Always reported as “N/A.”

N/A

N/A

6

Section Code

Local section code

[Sections]Section_Number

25

N/A

Audit Field

Section ID

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

N/A

N/A

Audit Field

PS Student ID

N/A

Audit Field

PS Student Grade

8

Grade Detail Code

The grade detail code.

Valid values:

• MP – Marking Period
• MT – Midterm
• FG – Final Grade
• QZ – Quiz
• EX – Exam
• FE – Final Exam
• HW – Homework
• OA – Other Assignment

[S_NY_TRB_X]Grade_Type_Code

N/A

9

Reporting Date

June 30^th of the current school year.

06-30-YYYY

10

N/A

Audit Field

Date Enrolled

N/A

Audit Field

Date Left

10

Marking Period Code

The marking period.

Note: Starting in 2016-2017, the marking period code is extracted from School Setup > Final Grade/Reporting Term Setup. If the report is run prior to 2016-17, the marking period is extracted from the NY_MarkingPeriods virtual table.

[S_NY_TRB_X]Marking_Period_Number

N/A

N/A

Audit Field

Term ID

N/A

Audit Field

Store Code

11

Display Grade

Not reported

N/A

N/A

12

Alpha Grade

Not reported

N/A

N/A

13

Numeric Grade

The numeric grade awarded to the student for the course.

Valid values: 0-110

[StoredGrades]Percent

N/A

14

Class Detail Outcome Code

[StoredGrades]GPA_Custom1

Note: To be reported as F (Fail) in the extract, this value must be set to F in the stored grade record. This can be done manually, or by running the Historical Grade Update Script.

N/A

15

GPA Impact Code

Used to signify if the course is to be considered for GPA calculations

[StoredGrades]ExcludeFromGPA

10

16

Evaluator 1 Staff ID

Not reported

N/A

N/A

17

Student Class Grade Detail Comment

Teacher comments as stored with the grade.

[StoredGrades]Comment_Value

1024

18

Course Instructor Snapshot Date

Not reported

N/A

N/A

19

Evaluator 1 Controlling District Code

Not reported

N/A

N/A

20

Term Code

The term the course is offered.

[S_NY_TRB_X]Term_Code

20

21

State Assessment Included Indicator

Indicates if the Regents assessment grade is included in the Final Course Grade calculation.

Valid values:

• Y - Yes
• N - No

[S_NY_CRS_X]RegentExam

[S_NY_SEC_X]RegentExam

[S_NY_CC_X]RegentExam

1

22

Credits Attempted

Not reported

N/A

N/A

23

Credits Earned

Not reported

N/A

N/A

24

Student Class Credit Type Code

Not reported

N/A

N/A

25

Dual/Concurrent Credit Code

Indicates the setting where the student is taking the course for college credit.

[S_NY_CC_X]DualConCrCode

20

26

Cumulative Clock Time

Not reported

N/A

N/A

27

Evaluator 2 Staff ID

Not reported

N/A

N/A

28

Evaluator 3 Staff ID

Not reported

N/A

N/A

29

Evaluator 2 Controlling District Code

Not reported

N/A

N/A

30

Evaluator 3 Controlling District Code

Not reported

N/A

N/A

31

Instruction Type Code

Not reported

N/A

N/A

32

Instruction Delivery Method Code

Not reported

N/A

N/A

33

Instruction Medium Type Code

Not reported

N/A

N/A

34

Course Delivery Model Code

Not reported

N/A

N/A

35

Course Completion Indicator

Not reported

N/A

N/A

36

Post Secondary Credit Units

The number of credit units the student earned from a post-secondary institution for a dual enrollment course.

Notes:

• If the Dual Enrollment Indicator on the enrollment or section page is set to Yes, this field populates with the number of post-secondary units.
• If the Dual Enrollment Indicator on the enrollment or section page is set to No, this field does not populate. The enrollment field overrides the section field.
• If the Dual Enrollment Indicator is set to Yes but Post-Secondary Credit Units Earned is blank, this field populates as 0.

[S_NY_CC_X]DualCrInd

[S_NY_SEC_X]DualCrInd

[S_NY_SGR_X]Post_Secondary_Credit

5

37

*Credit Recovery Code

Code to identify if course was taken for credit recovery.

Note: For students who are making up incomplete or failed course credit at any time, a Student Class Grade Detail Record must be reported and the Credit Recovery Code field on the record must be "Yes".

[S_NY_SGR_X]CreditRecovery

20

38

Student Grade Level Code When Taken

Not reported

N/A

N/A

39

Grade Standard Performance Level

Not reported

N/A

N/A

Student District Code (Course District)