H - Student Grade History File 2022-2023

Select Schools

Choose one of the following:

• Current School Only – Includes all student records associated with the current school that meet the 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.

The All Schools option is only available when running the report from the District Office.

Current Selection Students

Scheduling

Select Schedule to run the report on a specific date and time. The default selection is "Run Now."

H01

School Year

The four-digit year in which the school year ends.

[Terms]LastDay

Yes

Char

4

H02

Serving County District Code

[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

Location ID

Always blank

N/A

N/A

N/A

4

H06

Staff ID

Always blank

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.

The report output for each record will contain a concatenated list of unique codes as populated across the following locations:

• Courses
• Sections
• Stored Grades

Note: If the new code J – Tribal Language Competency Test is selected along with other codes for a student, then the report output displays only the letter J. The report output does not display the concatenated value of codes.

[S_WA_CRS_X]

[S_WA_SEC_X]

[S_WA_SGR_X]

Con

VarChar

10

H14

Content Area Code

Primary content area.

Content Area Code values of 1-122 are no longer reported for any grade. Content Area Codes of ZZZ and 123 are still reported (if populated).

[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-designated 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 Vocational Completer 

N/A

N/A

N/A

1

H21

Has Industry Certification 

N/A

N/A

N/A

1

H22

Is Direct Transcription Available

Always blank

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.

The valid values are "Y" and "N".

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

0, 1, 2

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

CourseEquivalencyIdent

Always blank

N/A

N/A

N/A

1

H29

CTECreditEquivalency

Always blank

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

Indicates which, if any, state or nationally industry-recognized certification(s) a student earned as a result of taking the CTE course when recognized industry certifications are available for that CTE course as identified in Element D17 – Industry Recognized Certifications Offered.

Defaults to '1 - No Industry Certification Offered' for CTE course enrollments where the CTE Course does not offer a certification (CEDARS D17 = 1).

Default to '2 - No Industry Certification Earned' for CTE course enrollments where the CTE Course offers a certification, but one was not earned by the student.

The work-based learning (WBL) activities the student participated in as a result of taking the CTE Course reported in Element H17 – Classification of Instructional Program (CIP) Code. All CTE courses have the expectation that WBL activities are embedded in the curriculum.

Rules: Data is required when Element H17 – Classification of Instructional Program(CIP) Code Number contains a value and Element H30 – Course School Year is 2022 or after. More than one valid value may be used (separated by a comma) to identify all of the WBL activities the student participated in for this CTE course. If H32 is 10 or 11, no other valid value may be used. 11 may only be
reported for transfer courses, where Element H26 – School Code is 9999.

This value will default to 10 if the 'corresponding course record Element D10 – Classification of Instructional Program (CIP) Code Number is not null', and the cc and stored grades fields are null.

Valid Values:

1 – Career Research and Job Interview/Job Shadow in Course-Related Area
2 – Guest Speaker Series with Assigned Career Mentors or Structured Field Trip
to Related Job Site
3 – School-Based Enterprises
4 – Placement/Unpaid Internship (20-hour minimum)
5 – Placement/Paid Internship
6 – Apprenticeship Preparation Program/Registered Apprenticeship
7 – Ownership/Entrepreneurship
8 – Health Care Clinical
9 – Course Related Service-Learning Project
10 – Student did not participate in any of the above WBL activities
11 – Could not obtain WBL activity details from prior enrollment (transfer
courses)