...
[16:38:21 CDT(-0500)] <TonyUnicon> in external_course_program
[16:39:01 CDT(-0500)] <TonyUnicon> is there a requirement for course specific alias of a program name?
[16:39:02 CDT(-0500)] <dmccallum54> from the impl doc:
[16:39:08 CDT(-0500)] <dmccallum54> "We don't need a list of programs without courses to support search features, but we require external_program anyway b/c we know we need that feature for plan templates (Feature Set 4). The denormalization of program names into external_course_program is an optimization to help search, though, which really only does need the list of programs having at least one required course. This lets that lookup avoid one join. And denorm
[16:39:20 CDT(-0500)] <JasonElwood> JS- for 963 (plan to offer), our implementation is different than Sinclair's implementation. we have distinct year and term whereas Sinclair's just has term. so we could do something like show the next X terms offered
[16:39:35 CDT(-0500)] <dmccallum54> if the "optimization" isn't used or causes more problems than it solves, then we can kill it