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