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