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.
EOY 1 Queries for Reconciling CALPADS Data
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 = #### )