Skip to main content
Skip table of contents

Student Credit GPA (SFTP)

Introduction

The Student Credit GPA Extract provides cumulative credit and GPA values on a per student basis.

Selection Criteria

Records will be generated for students meeting the following criteria:

  • The student was enrolled in the district during the selected school year. 
  • The student's grade level in the qualifying enrollment was grade 7 or above. 
  • The student's earned credit (as calculated by the selected GPA method) is greater than zero (0).

Note: If the report returns as blank (no records), consult GPA Setup for guidance on troubleshooting the Default Credit Earned Method selected for use with this report.

Back to Top

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.

Select Students

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.

Display Header

Choose Yes or No from the pop-up menu to indicate whether to display audit fields, along with a header row containing the name of each field included in the extract.

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

Req

Max

1

District Code

The 6-digit BEDS District Code is reported. Charter and nonpublic schools, state agencies, state-operated schools, and child care 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

Yes

8

2

School Year Date

The report extracts June 30th of the school year chosen at report runtime, such as 2014-06-30 for 2014-2013.

N/A

Yes

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.

[S_NY_STU_X]PreviousStudentNumber

[Students]Student_Number

Yes

12

4

Credit GPA Code

Report "Total" for students who have earned Any graduation credits.  Reporting credits and GPA by subject area is optional.

N/A

Yes

20

5

Reporting Date

The report extracts June 30 of the school year chose at report runtime, such as2014-06-30 for 2014-2013.

N/A

Yes

10

6

Marking Period Code

The NY Marking Period Code

N/A

Yes

40

7

Marking Period Credit Earned

Not reported

N/A

No

8,3

8

Marking Period GPA

Not reported

N/A

No

10,5

9

Cumulative Credits Earned

Total graduation credits earned to date.  This value is derived using the GPA method selected at the school or student level.

[S_NY_SCH_X] CreditEarnedMethod

[S_NY_STU_X] CreditEarnedMethod


8,3

10

Cumulative GPA

Total cumulative GPA earned to date This value is derived using the GPA method selected at the school or student level.

[GEN] Cat= gpacalcmethod

[GEN] Name


[S_NY_SCH_X]GPAMethod

[S_NY_STU_X]GPAMethod

Yes

10,5

11

Term Code

Not reported

N/A

No

10

12

Marking Period Grade Points

Not reported

N/A

No

8,3

13

Cumulative Grade Points

Not reported

N/A

No

8,3

14

Marking Period Location Code

Not reported

N/A

No

12

15

Student Credit GPA Comment

The name of the GPA calculation selected for use in this report.

[GEN] Cat= gpacalcmethod

[GEN] Name


[S_NY_SCH_X]GPAMethod

[S_NY_STU_X]GPAMethod

Yes

250

16

Student GPA Range Minimum

Minimum possible GPA value. This value is derived based on values set at the school or student level.

[S_NY_SCH_X]MinGPA

[S_NY_STU_X]MinGPA

Yes

10,5

17

Student GPA Range Maximum

Maximum possible GPA value. This value is derived based on values set at the school or student level.

[S_NY_SCH_X]MaxGPA

[S_NY_STU_X]MaxGPA

Yes

10,5

18

Marking Period Credits Attempted

Not reported

N/A

Yes

8,3

19

Cumulative Credits Attempted

Total graduation credits attempted to date. This value is derived using the GPA method selected at the school or student level.

[S_NY_SCH_X]CreditAttemptedMethod

[S_NY_STU_X]CreditAttemptedMethod

Yes

8,3

20

Projected Graduation Date

Not reported

N/A

No

10

21

Class Rank

Not reported

N/A

No

5,0

22

Class Size

Not reported

N/A

No

5,0

23

Percentage Class Rank

Not reported

N/A

No

6,2

24

Class Rank

Not reported

N/A

No

10

25

Marking Period School Year Date

Not reported

N/A

No

N/A

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.