PowerSchool SIS Oregon

Graduation Pathway File Report

Introduction

The Graduation Pathway File provides a comprehensive view of graduation readiness for currently enrolled high school students in grades 9–12. This report generates one record per student, combining the standard First 55 demographic fields with key graduation-related data points. These include diploma type, cumulative GPA, total credits required and earned, credits earned by subject area, and an overall on‑track indicator.

Start Page > State Reporting > [OR] Compliance Reports > Consolidated Collections > Graduation Pathway File

Report Requirements

  • Graduation Sets or Graduation Plans must have State Diploma Type and Diploma Credit Area values configured (see PSSR-399055).

  • A GPA Calculation Method must be defined in PowerSchool (Start Page > District > GPA Calculation Methods).

  • Students must be enrolled in grade 9 or above and active on the selected Report Date.

Student Selection Criteria

Students are included if they meet all of the following conditions:

Criterion

Description

Grade Level

Grade level ≥ 9

Enrollment Status

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

Current Selection

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

Report Input

Field

Description

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 Date

The effective date for determining student enrollment. Students active on this date are included.

Calculate GPA Using

Select the GPA calculation method defined in PowerSchool to compute cumulative GPA.

Report Data Based On

Determines whether Diploma Type and Credit Area data is derived from Graduation Sets or Graduation Plans.

HS Entry Cohort Year XXYY

The High School entry cohort year in XXYY format (e.g. 2526 for 2025-2026). Used for On-Track calculation.

Minimum Number of Credits Earned (HS Cohort Year)

The minimum number of credits a student in the specified HS cohort year must have earned to be considered "On Track."

Report Output

The report generates a CSV file with the naming pattern: OR_GradPathway_[SchoolNumber]_[Timestamp].csv

One row is exported per qualifying student.

Item #

Field

Description

Data Element

[Table]FieldName

Field Type

Field Length

1

State Student Number

State Student ID

ChkDigitStdntID

[Students]State_StudentNumber (computed)

String

10

2

Student Number

District Student ID

DistStdntID

[Students]Student_Number

String

10

3

District of Residence

Resident District Institution ID

ResdDistInstID

[Students]DistrictOfResidence

String

4

4

School of Residence

Resident School Institution ID

ResdSchlInstID

[Students]SchoolID (resident)

String

5

5

District Number

Attending District Institution ID

AttndDistInstID

[Schools]District_Number

String

4

6

School Number

Attending School Institution ID

AttndSchlInstID

[Schools]School_Number

String

5

7

(Filler - not displayed)

Institution Filler

InstFill

Static fill

String

10

8

Last Name

Legal Last Name

LglLNm

[Students]Last_Name

String

50

9

First Name

Legal First Name

LglFNm

[Students]First_Name

String

50

10

Middle Name

Legal Middle Name

LglMNm

[Students]Middle_Name

String

50

11

Suffix

Generation Code (Suffix)

GnrtnCd

[Students]Suffix

String

6

12

Preferred Last Name

Preferred Last Name

PrfrdLNm

[S_OR_STU_X]PrefLastName

String

50

13

Preferred First Name

Preferred First Name

PrfrdFNm

[S_OR_STU_X]PrefFirstName

String

50

14

Preferred Middle Name

Preferred Middle Name

PrfrdMNm

[S_OR_STU_X]PrefMiddleName

String

50

15

DOB

Birth Date (MMDDYYYY)

BirthDtTxt

[Students]DOB

String

8

16

Gender

Gender Code

GndrCd

[Students]Gender

String

1

17

Hispanic/Latino

Hispanic/Latino Ethnicity Flag

HispEthnicFg

[Students]FedEthnicity

String

1

18

American Indian or Alaska Native

American Indian/Alaska Native Flag

AmerIndianAlsknNtvRaceFg

[StudentRace]

String

1

19

Asian

Asian Race Flag

AsianRaceFg

[StudentRace]

String

1

20

Black or African American

Black/African American Race Flag

BlackRaceFg

[StudentRace]

String

1

21

White

White Race Flag

WhiteRaceFg

[StudentRace]

String

1

22

Native Hawaiian or Other Pacific Islander

Pacific Islander Race Flag

PacIslndrRaceFg

[StudentRace]

String

1

23

(Filler - not displayed)

Race Filler

RaceFill

Static fill

String

5

24

Language of Origin

Language of Origin Code

LangOrgnCd

[S_OR_STU_X]LangOrgnCd

String

4

25

SSN

Social Security Number

SSN

[Students]SSN

String

9

26

Grade Level

Enrollment Grade Code

EnrlGrdCd

[Students]Grade_Level

String

2

27

Street

Student Address

Addr

[Students]Street

String

40

28

City

Student City

City

[Students]City

String

20

29

Zip

Zip Code

ZipCd

[Students]Zip (5 digit)

String

5

30

Zip (+4)

Zip+4 Code

Zip4Cd

[Students]Zip (4 digit ext)

String

4

31

Resident County Code

Resident County Code

ResdCntyCd

[S_OR_STU_X]ResdCntyCd

String

2

32

Home Phone

Phone Number

Phn

[Students]Home_Phone

String

10

33

(Filler - not displayed)

Teacher Filler

TchrFill

Static fill

String

10

34

HS Entry School Year

High School Entry School Year (XXYY)

HSEntrySchlYr

[S_OR_STU_X]HSEntrySchlYr

String

4

35

(Filler - not displayed)

General Filler

Fill

Static fill

String

10

36

Economically Disadvantaged

Economically Disadvantaged Flag

EconDsvntgFg

[S_OR_STU_X]EconDsvntgFg

String

1

37

Title I

Title I Flag

Ttl1Fg

[S_OR_STU_X]Ttl1Fg

String

1

38

Special Education

Special Education Flag

SpEdFg

[S_OR_STU_X]SpEdFg

String

1

39

Section 504

Section 504 Flag

Sect504Fg

[S_OR_STU_X]Sect504Fg

String

1

40

Migrant Education

Migrant Education Flag

MigrntEdFg

[S_OR_STU_X]MigrntEdFg

String

1

41

Indian Education

Indian Education Flag

IndianEdFg

[S_OR_STU_X]IndianEdFg

String

1

42

English Learner

English Learner Flag

ELfg

[S_OR_STU_X]ELfg

String

1

43

Distance Learning

Distance Learning Flag

DstncLrnFg

[S_OR_STU_X]DstncLrnFg

String

1

44

Home School

Home School Flag

HomeSchlFg

[S_OR_STU_X]HomeSchlFg

String

1

45

Transition Program

Transition Program Flag

TrnstnProgFg

[S_OR_STU_X]TrnstnProgFg

String

1

46

Alternative Education Program

Alternative Education Program Flag

AltEdProgFg

[S_OR_STU_X]AltEdProgFg

String

1

47

Tribal Affiliation

Tribal Affiliation Code

TrbAfflnCd

[S_OR_STU_X]TrbAfflnCd

String

4

48

Talented and Gifted

Talented and Gifted Flag

TAGFg

[S_OR_STU_X]TAGFg

String

1

49

Additional Language

Additional Language Code

AddnLangCd

[S_OR_STU_X]AddnLangCd

String

4

50

(Filler - not displayed)

Demographics Filler

DemogFill

Static fill

String

10

51

State Diploma Type

State Diploma Type Code

DiplomaTypCd

[S_OR_GradReqSets_X]DiplomaTypCd or [S_OR_GradPlanDiplTyp_S]DiplomaTypCd

String

2

52

Calculate GPA Using (runtime)

Cumulative GPA

CumGPA

Computed via selected GPA Calculation Method (CommonGpa adapter)

Numeric

5

53

(Derived from Graduation Setup)

Total Credits Required

TotCrdRqrd

SUM of [GradReq]ReqCrHrs or SUM of [GPNode]CreditCapacity

Numeric

6

54

Earned Credit Hours

Total Credits Earned

TotCrdEarned

SUM of [StoredGrades]EarnedCrHrs (not excluded from graduation)

Numeric

6

55

(Calculated at runtime)

On-Track Flag

OnTrackFg

Y/N/blank based on HSEntrySchlYr and earned credits vs. minimum

String

1

56

Diploma Credit Area = MA

Math Credits Required

MathCrdRqrd

DiplCrdArea = 'MA' sum of ReqCrHrs or GPNode credits

Numeric

6

57

Diploma Credit Area = MA

Math Credits Earned

MathCrdEarned

Earned credits for area MA (capped at required)

Numeric

6

58

Diploma Credit Area = LA

Language Arts Credits Required

LangArtsCrdRqrd

DiplCrdArea = 'LA' sum of ReqCrHrs or GPNode credits

Numeric

6

59

Diploma Credit Area = LA

Language Arts Credits Earned

LangArtsCrdEarned

Earned credits for area LA (capped at required)

Numeric

6

60

Diploma Credit Area = SC

Science Credits Required

SciCrdRqrd

DiplCrdArea = 'SC' sum of ReqCrHrs or GPNode credits

Numeric

6

61

Diploma Credit Area = SC

Science Credits Earned

SciCrdEarned

Earned credits for area SC (capped at required)

Numeric

6

62

Diploma Credit Area = SS

Social Sciences Credits Required

SclSciCrdRqrd

DiplCrdArea = 'SS' sum of ReqCrHrs or GPNode credits

Numeric

6

63

Diploma Credit Area = SS

Social Sciences Credits Earned

SclSciCrdEarned

Earned credits for area SS (capped at required)

Numeric

6

64

Diploma Credit Area = HE

Health Credits Required

HthCrdRqrd

DiplCrdArea = 'HE' sum of ReqCrHrs or GPNode credits

Numeric

6

65

Diploma Credit Area = HE

Health Credits Earned

HthCrdEarned

Earned credits for area HE (capped at required)

Numeric

6

66

Diploma Credit Area = PE

Physical Education Credits Required

PhysEdCrdRqrd

DiplCrdArea = 'PE' sum of ReqCrHrs or GPNode credits

Numeric

6

67

Diploma Credit Area = PE

Physical Education Credits Earned

PhysEdCrdEarned

Earned credits for area PE (capped at required)

Numeric

6

68

Diploma Credit Area = OT

World Language/Arts/CTE Credits Required

WorldLangArtsCTECrdRqrd

DiplCrdArea = 'OT' sum of ReqCrHrs or GPNode credits

Numeric

6

69

Diploma Credit Area = OT

World Language/Arts/CTE Credits Earned

WorldLangArtsCTECrdEarned

Earned credits for area OT (capped at required)

Numeric

6

70

Diploma Credit Area = EL

Elective Credits Required

ElctvCrdRqrd

DiplCrdArea = 'EL' sum of ReqCrHrs or GPNode credits

Numeric

6

71

Diploma Credit Area = EL

Elective Credits Earned

ElctvCrdEarned

Total earned minus sum of all capped non-EL area credits

Numeric

6

72

Diploma Credit Area = PF

Personal Finance Credits Required

PrsnlFinCrdRqrd

DiplCrdArea = 'PF' sum of ReqCrHrs or GPNode credits

Numeric

6

73

Diploma Credit Area = PF

Personal Finance Credits Earned

PrsnlFinCrdEarned

Earned credits for area PF (capped at required)

Numeric

6

74

Diploma Credit Area = HC

Higher Ed/Career Path Skills Credits Required

HECareerPathSkillCrdRqrd

DiplCrdArea = 'HC' sum of ReqCrHrs or GPNode credits

Numeric

6

75

Diploma Credit Area = HC

Higher Ed/Career Path Skills Credits Earned

HECareerPathSkillCrdEarned

Earned credits for area HC (capped at required)

Numeric

6