H - Student Grade History File 2020-2021

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.

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

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.

[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

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.