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 sorted by Career Pathway and School


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


List of Career Pathways with Course Number, Course Title, Vocational Education Level and State Course ID

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


LIST CCP CRS CCP.CD CCP.CN CRS.CO CRS.VCL CRS.C3 BY CRS.VCL CCP.CD


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 IF CPH.AY = "20##-20##" AND CPH.CD = ###


List of Students Reported as Completors

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 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.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 = #### )