Breadcrumbs

Course Grade History

Reports → Compliance→ Course Grade History

Report Purpose

This report produces the Course Grade History state compliance extract, containing student-level demographic and course completion data required for submission to the state.

The output is generated in the state-defined file format, where each row represents a student-course record and each column aligns to a specific state reporting field.

This report supports:

  • State reporting compliance for course completion and transcript data

  • Accurate submission of student demographics tied to coursework

  • Tracking of credits attempted and earned

  • Identification of transfer coursework and institutions

Report Output Format

  • File Type: Structured extract (state-defined layout)

  • Grain: One row per student per course record

  • Ordering: Not guaranteed; downstream systems should not assume sort order

  • Field Definitions: Strictly aligned to state specifications

Each column corresponds to a required state field (e.g., SSID, Course Code, Credits Earned).

Parameters

Required Parameters

School Year
Defines the academic year for which course records are reported.

Schools
Select one or more schools to include in the extract.

Note: This report does not utilize student-level filtering.

Data Included

Student Population

The report includes students who:

  • Are enrolled in the selected school year

  • Have at least one enrollment record during that year

  • Have associated course marks with:

    • High school credit

    • Finalized grades

Course Records

Included course records must meet:

  • High school credit indicator = Yes

  • Latest mark indicator = Yes

  • Associated to a valid enrolled student

Key Data Domains

1. Student Identifiers & Demographics

Includes:

  • SSID (ChkDigitStdntID) – State-issued student identifier

  • District Student ID (DistStdntID)

  • Resident & Attending Institutions

  • Legal and preferred names

  • Birth date and gender

  • Race and ethnicity flags

  • Language of origin

These fields align directly to state definitions

2. Enrollment & Program Indicators

Includes flags indicating student participation in:

  • Economically Disadvantaged programs

  • Title I

  • Special Education (IEP)

  • Section 504

  • Migrant Education

  • Indian Education

  • English Learner programs

  • Distance Learning

  • Homeschooling

  • Alternative Education

  • Talented and Gifted (TAG)

Each flag is reported as:

  • Y = Yes

  • N = No

3. Course Information

Each record includes:

  • Local Course ID (SchlCrsID)

  • SCED Course Code (CrsCd)

  • Diploma Credit Area (DiplCrdArea)

  • Course Title (CrsTtl)

Subject areas are normalized into state-aligned categories (e.g., Math, Science, Language Arts).

4. Academic Performance

For each course:

  • Academic Year (AcdmYr)

  • School Term Code (SchlTrmCd)

  • Grade Earned (GrdEarndCd)

  • Credits Attempted (CrdAtmpt)

  • Credits Earned (CrdEarnd)

Credits are reported to the hundredths decimal precision.

5. Transfer Course Indicators

  • Record Transfer Flag (RecTrnsfrFg)

    • Y = Transfer course

    • N = Local course

  • Record Transfer Institution (RecTrnsfrInst)

    • Populated when transfer flag = Y

Data Transformations & Business Rules

Student Identifiers

  • SSIDs are zero-padded to 10 digits

Gender Mapping

Source Value

Output

Female

F

Male

M

Non-binary

X

Race & Ethnicity

  • Hispanic ethnicity reported separately from race flags

  • Race indicators are independently flagged (Y/N)

Course Coding

  • SCED codes are left-padded to 5 digits when needed

  • Subject areas are mapped to state-approved diploma credit areas

Credits

  • Attempted and earned credits are sourced directly from transcript marks

  • Only finalized marks are included

Transfer Logic

A course is flagged as transfer when:

  • The transcript school differs from the current school

  • The record is marked as transcript-only

How to Use This Report

1. Set Parameters

Select:

  • School Year

  • Schools

2. Generate Extract

Run the report to produce the output file.

3. Validate Output

Confirm:

  • Required fields are populated

  • SSIDs and institution IDs are valid

  • Credits and grades are present where expected

4. Submit to State

Upload the generated file to the state submission system per reporting guidelines.

Notes

  • Each row represents a single student-course record, not aggregated data

  • Only credit-bearing high school courses are included

  • Data reflects finalized grades only

  • Student demographic values reflect the current record for the reporting year

  • Null or invalid placeholder values are suppressed where required

  • The extract strictly adheres to the state file layout and field definitions

  • Results reflect current permissions and data available at the time of report execution