All these changes are just structural edits to support the changes I talked about in the other PR. Basically, I'm pulling out the most recent enrollment of each type, taking the original table and grabbing the most recent information in it (for things like active status and identification date), then joining in the three program types I separated out. This reshaping lets us display the relevant enrollments in a single row and avoids the ambiguity of having multiple sets of status information!
All these changes are just structural edits to support the changes I talked about in the other PR. Basically, I'm pulling out the most recent enrollment of each type, taking the original table and grabbing the most recent information in it (for things like active status and identification date), then joining in the three program types I separated out. This reshaping lets us display the relevant enrollments in a single row and avoids the ambiguity of having multiple sets of status information!