Skip to main content
Skip table of contents

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:

  • Default – District Wide. Includes all records on the PowerSchool server that meet selection criteria.
  • Current School Only – Includes all records associated with the current school that meet the selection criteria.
  • District Wide – Includes all records on the PowerSchool server that meet the selection criteria.

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:

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

Processing Options

Choose a time to run the report from the pop-up menu:

  • In Background Now (Recommended) – Execute the report immediately in the background.
  • ASAP – Execute the report in the order it is received in the Report Queue.
  • At Night – Execute the report during the next evening.
  • On Weekend – Execute the report during the next weekend.
  • On Specific Time – Execute the report on the date and time specified.

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

JavaScript errors detected

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

If this problem persists, please contact our support.