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 Pathways 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