Student Grades Extract

Introduction

This extract generates a comma-delimited file containing one record per student grade. The Final Grade Store Codes must be set up at every school for this report to run properly. This extract provides cumulative data for each STARS reporting date, and auto generates a “W” for dropped course enrollments that do not have a stored grade and the student was active on the 40D, 80D, or 120D reporting date.

Selection Criteria

Selection criteria determine which database records are used in the report.

Grade Selection

The report selects student records from the [StoredGrades] table based on the following criteria:

The grade must be associated with a school included in the report.
The grade must be associated with a term within the current school year.
The grade must be associated with a course for 7 to 12 grade levels.
The grade must be associated with a section that ended within the reporting period.

Student Selection

The report selects student records from the [Students] or [ReEnrollments] table who are not be excluded from state reporting.
The student is HSDA-flagged.

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. District Wide – Includes all student records on the PowerSchool server that meet selection criteria. Note: The District Wide option is only available when running the report from the District Office.
Restrict to these “Store Codes”	Select the appropriate store codes to narrow the selection of grades. Use CTRL or SHIFT to select multiple codes.
Report Period	Choose a reporting period from the pop-up menu: 40D 80D 120D EOY K5P Summer

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Tables for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Begin / End Position
1	District Code	PED assigned three-digit district number.	[Prefs]Name=DistrictNumber [Prefs]Value	1/8
2	Location Code	The alternate school number is extracted, if populated. Note: The School Number will be derived from the section the stored grade is tied to. Note: For the summer submission location code field at the staff level will be looked, on the summer school staff record first, then the staff record flagged as the primary record. If the field is blank on both records, the school number (and alternate school number if one exists) for the primary record will be extracted.	[Schools]Alternate_School_Number [Schools]School_Number For the Summer reporting period: [SchoolStaff.S_NM_SSF_X]LocationCode_SumSch [Schools]Alternate_School_Number [Schools]School_Number	9/14
3	School Year Date	This value is automatically extracted as June 30^th. The report determines the year by referencing the school year associated with the term selected when the report is run. To change terms, click Terms at the top of the page and choose a term from the list. The value is extracted in the format YYYY-MM-DD.	[Terms]LastDay	15/24
4	Course Number	Not collected.	N/A	25/32
5	Section Number	Not collected.	N/A	33/36
6	Request Sequence	Indicates the request sequence. The report always extracts 0.	N/A	37/39
7	Teacher Number	Not collected.	N/A	40/51
8	Student ID	The state assigned student identification number.	[Students]State_StudentNumber [Students]ID = [StoredGrades]StudentID	52/63
9	Marking Period Number	The report derives one of the following values for the marking period based on the reporting period chosen at report runtime: 501 – 40 Day 502 – 80 Day 503 – 120 Day 901 – EOY 902 – K5P 903 – Summer Submission	N/A	64/66
10	Numeric Grade	The numeric grade awarded to the student.	[StoredGrades]Percent	67/72
11	Alpha Grade	The letter grade awarded to the student.	[StoredGrades]Grade	73/75
12	Pass/Fail	Indicates whether the student passed or failed the class. This field extracts as blank value. Note: Stored grades with a grade value of P will be extracted in this column.	[StoredGrades]Grade	76/76
13	Absences	Not collected.	N/A	77/79
14	Excused Absences	Not collected.	N/A	80/82
15	Unexcused Absences	Not collected.	N/A	83/85
16	Tardies	Not collected.	N/A	86/88
17	Excused Tardies	Not collected.	N/A	89/91
18	Unexcused Tardies	Not collected.	N/A	92/94
19	GPA Indicator	Not collected.	N/A	95/97
20	Grades Comment	Not collected.	N/A	98/127
21	Grade Type Code	Not collected.	N/A	128/129
22	Semester	The semester value, based on the reporting period chosen at report runtime: 40D – 1 80D – 2 120D – 3 EOY – 4 K5P – 5 Summer Submission - 6	N/A	130/131
23	Credits Attempted	Not collected.	N/A	132/138
24	Credits Earned	Graduation credits earned.	[StoredGrades]EarnedCrHrs	139/145
25	Points Add On	Not collected.	N/A	146/152
26	Course Code Long	The report extracts the alternate course number, if populated.	[StoredGrades]Course_Number [Courses]alt_course_number [Courses]Course_Number	153/164
27	Section Code Long	The report extracts the locally assigned section number.	[StoredGrades]SectionID	166/189
28	Course Content Code	The grade awarded to the student for their conduct in the course.	[StoredGrades]Behavior	190/195
29	Course Instructor Snapshot Date	The report date. Note: the value must coincide with the corresponding marking Period Number and Semester value. Valid values: 40D – YYYY-10-01 80D – YYYY-12-15 120D – YYYY-03-01 EOY – YYYY-06-01 K5P – YYYY-09-01 Summer Submission – YYYY-06-29 Note: For 120D and EOY reporting periods, the year value of the FirstDay field +1 is used.	[Terms]Firstday	196/205