This is a collection of queries related to Career Pathways that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.


List Queries

EOY 1 Queries for Reconciling CALPADS Data


See:  EOY 1 Course and Career Pathway Queries


List of Course Sequence for Career Pathways

Provides a list of each Career Pathway with the associated Course Sequence and if the Level 1 is Required sorted by Career Pathway and School


LIST CCP CRS CCP.SC CCP.CD CCP.CN CRS.CO CRS.C3 CCP.LVL CCP.RQ BY CCP.CD CCP.SC


List of Career Pathways with Course Number, Course Title, High Quality Status and State Course ID

Lists each Career Pathway with Course information sorted by Vocational Education Level and Career Pathway


LIST CCP CRS MST CCP.CD CCP.CN CRS.CO MST.SE MST.HQC CRS.C3 BY MST.HQC CCP.CD 


List of all Students in a Career Pathway with Career Pathway and Course Information from Transcripts (HIS).

Provides a list of each student who has Career Pathway courses in their transcript with Career Pathway and Course information if the student has been added to a Career Pathway.


LIST STU CPW CPH HIS CRS STU.TG STU.ID STU.NM CPW.CD?CTE.CD CPW.CM CPH.AY CPH.LVL CRS.CN CRS.CO CRS.C3 IF CRS.C3 > 6999 AND CRS.C3 < 9000 AND CPW.CD # NULL


List of Students with Career Pathway and Completion Status

Lists students with Pathway Code, Completion Status and School Year


LIST STU CPW CPH STU.TG STU.ID STU.NM CPW.CD CPW.CM CPH.AY CPH.LVL IF CPH.AY = "20##-20##" AND CPH.CD = ###


List of Students Reported as Completers

Provides a listing of students who are being reported as Completers to CALPADS for a specific year


LIST STU CPW CPH STU.TG STU.ID STU.NM CPW.CD CPW.CM CPH.AY CPH.LVL IF CPH.AY = 20##-20## AND CPW.CM = 1


List of Students who have taken a course identified with a CTE State Course ID number.

Provides a list of students with CTE information for students enrolled in a course identified with a vocational State Course ID number.


LIST STU CPW CPH HIS CRS STU.TG STU.ID STU.NM CPW.CD CPW.CM CPH.LVL CPH.AY HIS.CN CRS.C3 IF CRS.C3 > 6999 AND CRS.C3 < 9000  


List of Students who took courses related to a specific pathway for a specific year.

Provides a list of student who took courses that were associated with a pathway for a specific year.


LIST STU HIS STU.ID STU.NM HIS.CN HIS.YR IF HIS.YR = ## AND ( HIS.CN = #### OR HIS.CN = #### )