-- (this is probably the most complicated part of this update)
-- we'll (probably) need to replace TimeOffRequest.CourseID with a new join table e.g. TimeOffRequestCourse
---- ...because the pre-clinical includes multiple courses at the same time, instead of just one at a time as the TimeOff was designed for clinical
-- we'll need to search all the code (and stored procs, etc?) for places where we are using CourseID and figure out how to replace it
-- (this is probably the most complicated part of this update) -- we'll (probably) need to replace TimeOffRequest.CourseID with a new join table e.g. TimeOffRequestCourse ---- ...because the pre-clinical includes multiple courses at the same time, instead of just one at a time as the TimeOff was designed for clinical -- we'll need to search all the code (and stored procs, etc?) for places where we are using CourseID and figure out how to replace it