H - Student Grade History File 2019-2020

Introduction

The Student Grade History file includes one record for each high school course where a student attempted to earn credit. The file includes all of the student's historical grade records for high school. The final grade for the course must be the same grade that will appear on the student's transcript. Grade history records for courses the student received from schools outside the serving district should be reported using Location ID 9999.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis of report results when the report does not return the correct records.

Grade Selection

The report selects records from the [StoredGrades] and [CC] tables based on the following criteria:

The school where the grade was awarded must not offer grade levels below 9 or above 12.
The school where the grade was awarded must not be excluded from state reporting.
The course for which the grade was awarded must offer credit; i.e. potential credit must be greater than zero.
The student's school Entry Date must be on or before the last day of the current school year.
The student's school Exit Date must be on or after the first day of the current school year.
The student must not be a no-show; i.e. the school Exit Date must occur after the school Entry Date.

Report Input

For help with report navigation and generation, 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. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Current Selection Students	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.
School Year	Choose the year for which to run the report.
Default Course Number for Imported Historical Grades With Blank Course Number	Enter the default course number for historical grades which do not have an assigned associated course.
Scheduling	Default is Run Now. Select Schedule to run the report on a specific date and time.

Back to Top

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	Reqd	Field Type	Length
H01	School Year	The four–digit year in which the school year ends.	[Terms]LastDay	Yes	Char	4
H02	Serving County District Code	The county district code for the district providing service to the student. Use leading zeroes where necessary. Note: All grades from outside serving districts should be 9999.	[Prefs]Value [Prefs]Name=districtnumber	Yes	Char	5
H03	District Student ID	The locally assigned student identifier.	[Students]Student_Number	Yes	VarChar	50
H04	State Student ID (SSID)	The identifier assigned to each WA public school student by OSPI. Rule: This field is not required if the student has not yet been assigned an SSID.	[Students]State_StudentNumber	Con	Char	10
H05	No longer an Active Data Element.	This data element is no longer used in CEDARS. Deprecated as of 2017-2018. This position in the extract is now filler (null).	N/A	N/A	N/A	4
H06	No longer an Active Data Element.	This data element is no longer used in CEDARS. Deprecated as of 2017-2018. This position in the extract is now filler (null).	N/A	N/A	N/A	20
H07	Course ID	The unique course number assigned by the district. Grades without an associated course will use the school-level or district-level default course numbers.	[StoredGrades]Course_Number [S_WA_SCH_X]TransferCrsNumber [Pref]WA_TransferCrsNumber	Yes	VarChar	20
H08	Course Title	Course name assigned by the school and district.	[StoredGrades]Course_Name	Yes	VarChar	50
H09	Grade Level Code	The student’s grade level at the time the grade was awarded.	[StoredGrades]Grade_Level	Yes	VarChar	2
H10	Letter Grade	The letter grade awarded for the course.	[StoredGrades]Grade	Yes	VarChar	2
H11	Credits Attempted	The number of credits the student could have earned for the course. Valid range: 00.00 to 99.99	[StoredGrades]PotentialCrHrs	Yes	Numeric	4,2
H12	Credits Earned	The number of credits awarded to the student upon completion of the course. Valid range: 00.00 to 99.99	[StoredGrades]EarnedCrHrs	Yes	Numeric	4,2
H13	Course Designation Code	Course designation code outlined in WAC 392-415-070. Include this field for grades 7–12 for all courses that receive high school credit.	[S_WA_CRS_X]Desig_IB [S_WA_CRS_X]Desig_CollegeInHS [S_WA_CRS_X]Desig_TechPrep [S_WA_CRS_X]Desig_Honors [S_WA_CRS_X]Desig_AP [S_WA_CRS_X]Desig_RunningStart [S_WA_CRS_X]Desig_CADR [S_WA_CRS_X]Desig_Online [S_WA_CRS_X]Desig_Cambridge [S_WA_CRS_X]Desig_LocalTest [S_WA_CRS_X]Desig_NationalTest [S_WA_CRS_X]Desig_Quantitative [S_WA_CRS_X]Desig_SciLab S_WA_CRS_X]Desig_SciLab [S_WA_CRS_X]Desig_locCrsAssessment	Con	VarChar	10
H14	Content Area Code	Primary content area. Note: This field is required for courses taken during the 2011-2012 school year and beyond.	[S_WA_SEC_X]ContentAreaCd [S_WA_CRS_X]ContentAreaCd	Con	VarChar	3
H15	State Course Code	Unique course code assigned by the state.	[S_WA_SEC_X]StateCourseCd [S_WA_CRS_X]StateCourseCd	Con	Char	6
H16	Advanced Placement (AP) and International Baccalaureate (IB) Code	Code for an AP or IB associated course. Rule: An AP or IB code must be reported if data element H13 contains an A or I.	[S_WA_SGR_X]Desig_AP [S_WA_SEC_X]APCode [S_WA_CRS_X]APCode [S_WA_SGR_X]Desig_IB [S_WA_SEC_X]Desig_IB [S_WA_CRS_X]IBCode	Con	Numeric	4,2
H17	Classification of Instructional Program (CIP) Code Number	CIP code assigned by OSPI to approved CTE courses. Rule: A valid CIP Code Number must be reported if data element H13 contains a T.	[Courses]Code	Con	Char	6
H18	Term End Date	The month and year of the final grading period for the course, reported in the format MM/YYYY.	[Terms]LastDay	Yes	Char	7
H19	Term	The term during which the student took the course. Rule: This field is not required for transfer credits.	[Terms]Abbreviation	Con	VarChar	12
H20	Is CTE Completer	Indicates whether the student acquired 360 hours of instruction in a single CTE program area for the CTE course indicated in data element H13. Rule: This field is required if data element H13 is T. Default value: N – No	[S_WA_CC_X]VocationalCompleter	Con	Char	1
H21	Has Industry Certification	Indicates whether the student received certification or passed a certification exam as part of a state or nationally recognized industry certification program during the reporting period for the CTE course indicated in data element H17. Rule: This field is required if data element H17 is reported. Default value: N – No	[S_WA_CC_X]IndustryCert	Con	Char	1
H22	No longer an active data element. Formerly Is Direct Transcription Available	Beginning with the 2012-2013 school year this element is no longer an active data element. This position in the extract is now filler (null).	N/A	N/A	N/A	1
H23	Is CTE Dual Credit (Tech Prep) Completer	Indicates if the student completed a sequence of courses in accordance with the definition of CTE Dual Credit (Tech Prep) Completer. Rules: This field must be N if data element D11 is N. This field is required if data element D11 is reported. This field is required if element H13 is T.	[S_WA_CC_X]TechPrepCompleter	Con	Char	1
H24	CTE Assessment	Indicates if the student has taken and/or passed a state or nationally recognized assessment in the approved CTE Course identified in data element H17. Rule: This field is required if element H17 is reported.	[S_WA_CC_X]CTEAssessment	Con	Char	1
H25	Certification Number	The State Certification number assigned to this staff member’s certificate. The Certification Number may be blank for any high school transfer credits taken outside the submitting district	[S_WA_USR_X]TeacherCredentialID	Con	Char	7
H26	School Code	This is a four-digit code assigned to the school by OSPI.	[schools]school_number [schools]alternate_school_number	Yes	Char	4
H27	ALE Course Type	Indicates whether the student is receiving ALE funded instruction for the course being reported. Valid Values: N – No, Course was not taught through ALE O – Online R – Remote T – Site Based – written student learning plan requires regular weekly in- person instructional contact time U – Site Based – written student learning plan requires less than weekly in- person instructional contact time Y – Yes (Only applicable for school years prior to 2014-2015)	[S_WA_SGR_X]ALEFunded [S_WA_SEC_X]ALEFunded [S_WA_CRS_X]ALEFunded	Con	Char	1
H28	No Longer An Active Data Element	This data element is no longer used in CEDARS. Deprecated as of 2017-2018. This position in the extract is now filler (null).	N/A	N/A	N/A	1
H29	No Longer An Active Data Element	This data element is no longer used in CEDARS. Deprecated as of 2017-2018. This position in the extract is now filler (null).	N/A	N/A	N/A
H30	Course School Year	The second year of the four-digit school year in which the course was taken.	[Courses]CourseYear	Yes	Char	4

Back to Top