Course Grade History Report

Grade Level

Grade level ≥ 9 (at time of enrollment or re-enrollment)

Enrollment Status

Actively enrolled (entry date ≤ Snapshot Date AND exit date > Snapshot Date)

Stored Grades

At least one stored grade record with: grade IS NOT NULL, course_number or SCED Course Code is not null, potential credit hours > 0, and not excluded from transcripts

Current Selection

If a student selection is active, only students in the current selection are included

Select Schools

Select one or more schools. Only schools not excluded from state reporting are available.

Students to Include

Select "All students" or "Current selection of students"

Report Diploma Credit Area Based On

Determines whether Diploma Credit Area is derived from Graduation Sets or Graduation Plans

Report Snapshot Date

The effective date for determining active enrollment. All course grade history for qualifying students is returned.

1

State Student Number

ChkDigitStdntID

State Student ID with check digit

[Students]State_StudentNumber (computed)

String

10

2

Student Number

DistStdntID

District Student ID

[Students]Student_Number

String

10

3

District of Residence

ResdDistInstID

Resident District Institution ID

[Students]DistrictOfResidence

String

4

4

School of Residence

ResdSchlInstID

Resident School Institution ID

[Students]SchoolID (resident)

String

5

5

District Number

AttndDistInstID

Attending District Institution ID

[Schools]District_Number

String

4

6

School Number

AttndSchlInstID

Attending School Institution ID

[Schools]School_Number

String

5

7

(Filler - not displayed)

InstFill

Institution Filler

Static fill

String

10

8

Last Name

LglLNm

Legal Last Name

[Students]Last_Name

String

50

9

First Name

LglFNm

Legal First Name

[Students]First_Name

String

50

10

Middle Name

LglMNm

Legal Middle Name

[Students]Middle_Name

String

50

11

Suffix

GnrtnCd

Generation Code (Suffix)

[Students]Suffix

String

6

12

Preferred Last Name

PrfrdLNm

Preferred Last Name

[S_OR_STU_X]PrefLastName

String

50

13

Preferred First Name

PrfrdFNm

Preferred First Name

[S_OR_STU_X]PrefFirstName

String

50

14

Preferred Middle Name

PrfrdMNm

Preferred Middle Name

[S_OR_STU_X]PrefMiddleName

String

50

15

DOB

BirthDtTxt

Birth Date (MMDDYYYY)

[Students]DOB

String

8

16

Gender

GndrCd

Gender Code

[Students]Gender

String

1

17

Hispanic/Latino

HispEthnicFg

Hispanic/Latino Ethnicity Flag

[Students]FedEthnicity

String

1

18

American Indian or Alaska Native

AmerIndianAlsknNtvRaceFg

American Indian/Alaska Native Flag

[StudentRace]

String

1

19

Asian

AsianRaceFg

Asian Race Flag

[StudentRace]

String

1

20

Black or African American

BlackRaceFg

Black/African American Race Flag

[StudentRace]

String

1

21

White

WhiteRaceFg

White Race Flag

[StudentRace]

String

1

22

Native Hawaiian or Other Pacific Islander

PacIslndrRaceFg

Pacific Islander Race Flag

[StudentRace]

String

1

23

(Filler - not displayed)

RaceFill

Race Filler

Static fill

String

5

24

Language of Origin

LangOrgnCd

Language of Origin Code

[S_OR_STU_X]LangOrgnCd

String

4

25

SSN

SSN

Social Security Number

[Students]SSN

String

9

26

Grade Level

EnrlGrdCd

Enrollment Grade Code

[Students]Grade_Level

String

2

27

Street

Addr

Student Address

[Students]Street

String

40

28

City

City

Student City

[Students]City

String

20

29

Zip

ZipCd

Zip Code

[Students]Zip (5 digit)

String

5

30

Zip (+4)

Zip4Cd

Zip+4 Code

[Students]Zip (4 digit ext)

String

4

31

Resident County Code

ResdCntyCd

Resident County Code

[S_OR_STU_X]ResdCntyCd

String

2

32

Home Phone

Phn

Phone Number

[Students]Home_Phone

String

10

33

(Filler - not displayed)

TchrFill

Teacher Filler

Static fill

String

10

34

HS Entry School Year

HSEntrySchlYr

High School Entry School Year (XXYY)

[S_OR_STU_X]HSEntrySchlYr

String

4

35

(Filler - not displayed)

Fill

General Filler

Static fill

String

10

36

Economically Disadvantaged

EconDsvntgFg

Economically Disadvantaged Flag

[S_OR_STU_X]EconDsvntgFg

String

1

37

Title I

Ttl1Fg

Title I Flag

[S_OR_STU_X]Ttl1Fg

String

1

38

Special Education

SpEdFg

Special Education Flag

[S_OR_STU_X]SpEdFg

String

1

39

Section 504

Sect504Fg

Section 504 Flag

[S_OR_STU_X]Sect504Fg

String

1

40

Migrant Education

MigrntEdFg

Migrant Education Flag

[S_OR_STU_X]MigrntEdFg

String

1

41

Indian Education

IndianEdFg

Indian Education Flag

[S_OR_STU_X]IndianEdFg

String

1

42

English Learner

ELfg

English Learner Flag

[S_OR_STU_X]ELfg

String

1

43

Distance Learning

DstncLrnFg

Distance Learning Flag

[S_OR_STU_X]DstncLrnFg

String

1

44

Home School

HomeSchlFg

Home School Flag

[S_OR_STU_X]HomeSchlFg

String

1

45

Transition Program

TrnstnProgFg

Transition Program Flag

[S_OR_STU_X]TrnstnProgFg

String

1

46

Alternative Education Program

AltEdProgFg

Alternative Education Program Flag

[S_OR_STU_X]AltEdProgFg

String

1

47

Tribal Affiliation

TrbAfflnCd

Tribal Affiliation Code

[S_OR_STU_X]TrbAfflnCd

String

4

48

Talented and Gifted

TAGFg

Talented and Gifted Flag

[S_OR_STU_X]TAGFg

String

1

49

Additional Language

AddnLangCd

Additional Language Code

[S_OR_STU_X]AddnLangCd

String

4

50

(Filler - not displayed)

DemogFill

Demographics Filler

Static fill

String

10

51

(Internal DCID)

SchlCrsID

School Course ID

[StoredGrades]DCID

String

20

52

SCED Course Code

CrsCd

Course Code

[StoredGrades]Course_Number / [S_CRS_X]SCED_Course_Code / [S_OR_SGR_X]ScedCourseCd

String

10

53

Diploma Credit Area

DiplCrdArea

Diploma Credit Area

[S_OR_GradReq_X]DiplCrdArea or [S_OR_GPNodeDiplCrdArea_S]DiplCrdArea

String

2

54

Course Name

CrsTtl

Course Title

[StoredGrades]Course_Name

String

100

55

(Derived from Term)

AcdmYr

Academic Year (XXYY)

Derived from [StoredGrades]TermID

String

4

56

Store Code

SchlTrmCd

School Term Code

[StoredGrades]StoreCode mapped to SEM1, SEM2, QTR1-4, FULL, TRI1-3

String

10

57

Grade

GrdEarndCd

Grade Earned Code

[StoredGrades]Grade (first character)

String

1

58

Potential Credit

CrdAtmpt

Credits Attempted

[StoredGrades]PotentialCrHrs

Numeric

10

59

Earned Credit Hours

CrdEarnd

Credits Earned

[StoredGrades]EarnedCrHrs

Numeric

10

60

Record Transfer Flag

RecTrnsfrFg

Record Transfer Flag (Y/N)

[S_OR_SGR_X]RecTrnsfrFg

String

1

61

School Name

RecTrnsfrInst

Record Transfer Institution

[StoredGrades]SchoolName (only when RecTrnsfrFg = Y)

String

50