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 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 CRS.VCL CCP.LVL CCP.RQ 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 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 = #### )