CD2 - Courses relating (joining) to a Main Program/ MainCourse

[ZaidGandhi]

Currently looking at canvas.courses table.

I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer science Y1 main program could have 6 modules/courses (database, AI, ML, QC, ANN, DS) 

Is there a way these "sub" courses can be linked to a main program?

Through enrollments table, I was able to link students with courses but this doesn't provide a concrete structure or grouping by programs that's needed for analysis.

@KeithSmith_au @Pete5484 @stimme 

if you can help here please 

[stimme]

There are a couple of possible approaches to analyzing your courses as parts of larger programs. If your institution's data store also includes tables from your SIS, perhaps you could identify the courses' programs with joins to those tables. If you have SIS data and your Canvas account hierarchy is not very detailed, this approach seems simplest.

Another possibility is to use the account hierarchy to group courses for analysis. I am not at all certain your Canvas account hierarchy will be organized into programs or subprogram requirements, e.g. CS Y1, but it is worth considering. There are a couple of posts about building out the account hierarchy from the canvas.accounts table in a discussion from last year: I attached a query here, and @ColinMurtaugh posted his approach here.