Summer Class Grade Detail (SFTP)
Introduction
This report will generate one record for every stored grade / marking period combination that meets the selection criteria outlined below.
Selection Criteria
This report requires that additional setup be completed at the student, school and district level. These setup requirements are in addition to any previous setup requirements:
- The creation of a Final Grade bucket that specifically represents grades earned as part of a summer school offering. (School > Final Grade Setup > New/Edit Final Grade).
- The creation of a Marking Period record meeting the following requirements (District > Schools/School Information > Marking Period Setup):
- The record is tied to the Final Grade bucket created for Summer School, where:
- The term code is set to: S – Summer School
- The grade type code is set to either: FG – Final Grade or SFG – Summer Final Grade
- The existence of stored grade records for students where:
- The course number has been populated.
- The value for "Was this class taken in Summer School?" has been set to: Yes.
- Summer School grades earned as part of a Credit Recovery plan should be marked accordingly.
- For summer school grades imported with a SchoolID of "0", a Location Code Override value has been populated (Start Page -> Select Student -> Historical Grades -> Edit Stored Grade).
- Any value stored in this field (other than null or blank) will be reported in the Location Code column
Notes:
- Alternately, the Marking Period value equivalents can be entered manually, as part of the report parameters.
- If the MP Override Option is set to either option 2 or 3, the report must be run for the Current School Only.
- Student-level exclusion flags are not considered in the Student Grades report. Records marked for exclusion will be included in this extract per state requirements.
Report Input
This report can only be run at individual schools.
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Students to Include | Indicate which students to include in the report by selecting one of the following options:
Note: If running the report for a single student, or group of students, select the students prior to running report. |
Run Reports with Audit Fields and Headers | 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. |
Start Date | Enter the report start date. |
End Date | Enter the report end date. |
Marking Period Override Options | Option 1 – Use Marking Period Setups Identifies and extracts records based solely on the Marking Period records for the selected school(s) Option 2 – Use Marking Period Override Values Identifies and extracts records based solely on the values entered in the Marking Period Override fields when the report is initiated Note: Run for Current School Only Option 3 – Use both Marking Period and override values Identifies and extracts records based on both the Marking Period records and the values entered in the Marking Period Override fields when the report is initiated Note: Run for Current School Only |
Select Term ID | Select the Term that represents the term ID on grades stored for Summer School. |
Store Code (A Single Value Only) | Enter the store code used when storing summer school grades. |
Marking Period (Extracted in All Records) | Enter the value to be extracted as the Marking Period Code in all records (Valid values are 1-8) |
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 Length |
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 | Location Code | The local BOCES building code. | [S_NY_SGR_X]LocationOverride [S_NY_SCH_X]BOCESBuilding (based on School ID stored in the grade record) | Yes | 6 |
3 | Course Code | Local Course Code | [S_NY_CRS_X]AlternateCourseNumber [Courses]Course_Number | Yes | 12 |
4 | School Year Date | The report extracts June 30th of the school year chosen at report runtime, such as 2011-06-30 for 2010-2011. | N/A | Yes | 10 |
5 | Supplementary Course Differentiator | Always reported as “N/A.” | N/A | Yes | N/A |
6 | Section Code | Local section code. | [Sections]Section_Number | Yes | 25 |
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 | Yes | 3 |
8 | Grade Detail Code | The grade detail code. Valid values:
| [S_NY_TRB_X]Grade_Type_Code | Yes | 20 |
9 | Reporting Date | June 30th of the current school year. | 06-30-YYYY | Yes | 10 |
10 | Marking Period Code | The marking period. See the Appendix for valid values. | [S_NY_TRB_X]Marking_Period_Number | Yes | |
11 | Display Grade | Class grade to be displayed on reports | [StoredGrades]Grade | No | 20 |
12 | Alpha Grade | Non-numeric class grade for the student | [StoredGrades]Grade | No | 20 |
13 | Numeric Grade | The numeric grade awarded to the student for the course. Required for secondary-level courses. Optional for all other courses. | [StoredGrades]Percent | Yes – grades 9-12 | 7,3 |
14 | Class Detail Outcome Code | Course pass/fail indicator for all reported course Note: Dropped classes (CC exit date is prior to section end date) will automatically be reported with a value of NC (Non-Complete) | [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. | Yes | 20 |
15 | GPA Impact Code | Used to signify if the course is to be considered for GPA calculations | [StoredGrades]ExcludeFromGPA | No | 20 |
16 | Evaluator 1 Staff ID | Not reported | N/A | No | N/A |
17 | Student Class Grade Detail Comment | Course related staff comment about the student | [StoredGrades]Comment_Value | No | 250 |
18 | Course Instructor Snapshot Date | Not reported | N/A | No | N/A |
19 | Evaluator 1 Controlling District Code | Not reported | N/A | No | N/A |
20 | Term Code | The term in which the course is offered. | [S_NY_TRB_X]Term_Code | Yes | 20 |
21 | State Assessment Included Indicator | Indicates if the Regents assessment grade is included in the Final Course Grade calculation. Valid values:
| [S_NY_CRS_X]RegentExam | Yes | 3 |
22 | Credits Attempted | The total credit value assigned to this course. | [StoredGrades]Potential_credit | Yes – grades 9-12 | 8,4 |
23 | Credits Earned | The total credits earned by the student for this course | [StoredGrades]Earned_credit | Yes – grades 9-12 | 8,4 |
24 | Student Class Credit Type Code | Used to identify the type of credit the student will receive | [StoredGrades]Credit_Type | No | 20 |
25 | Dual Credit Code | Not reported | N/A | No | N/A |
26 | Cumulative Clock Time | Not reported | N/A | No | N/A |
27 | Evaluator 2 Staff ID | Not reported | N/A | No | N/A |
28 | Evaluator 3 Staff ID | Not reported | N/A | No | N/A |
29 | Evaluator 2 Controlling District Code | Not reported | N/A | No | N/A |
30 | Evaluator 3 Controlling District Code | Not reported | N/A | No | N/A |
31 | INSTRUCTION TYPE CODE | Not reported | N/A | No | N/A |
32 | INSTRUCTION DELIVERY METHOD CODE | Not reported | N/A | No | N/A |
33 | INSTRUCTION MEDIUM TYPE CODE | Not reported | N/A | No | N/A |
34 | COURSE DELIVERY MODEL CODE | Not reported | N/A | No | N/A |
35 | COURSE COMPLETION INDICATOR | Not reported | N/A | No | N/A |
36 | POSTSECONDARY CREDIT UNITS | Not reported | N/A | No | N/A |
37 | *CREDIT RECOVERY CODE | Code to identify if course was taken for credit recovery. 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 identified as "yes". | [S_NY_SGR_X]CreditRecovery | Yes | 20 |