Export Historical Grades - RE
Contents
Legacy Export Historical Grades - RE
Use this report to export all historical grades in PowerSchool into a tab delimited text file. The grades are extracted from the StoredGrades table.
Refer to the Student Grade (SG) Table Import File Layout for more information.
Report Input
For help with navigation and running the report, see How to Find and Generate a Report.
Field | Description |
Use | If run at the district level, choose one of the following from the pop-up menu:
If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. |
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. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10:05 AM. |
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 | Field Type | Field Length | Begin / End Position |
1 | Last Name | The student’s last name, extracted from the Demographics page. | [Students]Last_Name | Alpha-numeric | 35 | N/A |
2 | First Name | The student’s first name, extracted from the Demographics page. | [Students]First_Name | Alpha-numeric | 20 | N/A |
3 | Student Number | The locally assigned student number, extracted from the Demographics page. | [Students]Student_Number | Numeric | 9 | N/A |
4 | Course Name | The course name, extracted from Start page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]Course_Name | Alpha-numeric | 40 | N/A |
5 | Course Number | The course number, extracted from Start page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]Course_Number | Alpha-numeric | 11 | N/A |
6 | Grade | The grade the student earned in this course, extracted from Start page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]Grade | Alpha-numeric | N/A | N/A |
7 | Grade Level | The student’s grade level when the grade was awarded, extracted from Start page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]Grade_Level | Alpha-numeric | 2 | N/A |
8 | School ID | The name of the school where the student was awarded this grade | [StoredGrades]SchoolID | Alpha-numeric | 4 | N/A |
9 | Store Code | The term in which the student was enrolled in this course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]StoreCode | Alpha-numeric | 2 | N/A |
10 | Earned Credit Hours | The number of hours the student earned for this course, if the student received a passing grade. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]EarnedCrHrs | Numeric | N/A | N/A |
11 | School Year | The Year of Enrollment. | [StoredGrades]TermID | Numeric | 4 | N/A |
12 | DCID | This is an internal number. | DCID | N/A | N/A | N/A |
13 | Verified Credits | The verified credits earned by the student for this course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Verified_Credit | Numeric | N/A | N/A |
14 | Substitute Credits | A value of Yes is reported if this course is a substitute credit course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Substitute_Credit | Numeric | 1 | N/A |
15 | Distance Learning | A value of Yes is reported if this is a distance learning course. The default is (pull course value) indicating that the value entered in the Course file is used for this field value. This value is extracted from the Student Historical Grades page, Student Selection > Historical Grades. | [StoredGrades]VA_distance_learning | Alpha-numeric | 1 | N/A |
16 | Dual Enrollment | A value of Yes is reported if this is a dual enrollment course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_dual_enrollment | Alpha-numeric | 1 | N/A |
17 | Advanced Placement | A value of Yes is reported if this is an advanced placement course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Advanced_Placement | Alpha-numeric | 1 | N/A |
18 | Accelerated | A value of Yes is reported if this is an accelerated course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Accelerated | Alpha-numeric | 1 | N/A |
19 | Honors | A value of Yes is reported if this is an honors course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Honors | Alpha-numeric | 1 | N/A |
20 | International Baccalaureate | A value of Yes is reported if this is an International Baccalaureate course. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Baccalaureate | Alpha-numeric | 1 | N/A |
21 | Alternate School ID | The ID of the school where this course was taken, if the course was taken outside of the school district. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Alternate_School_ID | Alpha-numeric | 4 | N/A |
22 | Alternate Course ID | The ID of the course taken, if the course was taken outside of the school district. This value is extracted from Start Page > Student > Historical Grades > Edit Stored Grade. | [StoredGrades]VA_Alternate_Course_ID | Alpha-numeric | 11 | N/A |