Issues encountered during the second checkin

[eanyanwu]

Issues encountered during the second checkin

[eanyanwu]

Two students who lived in Summer housing in Ferrin who don't have fall RCIs listed (only summer)
Steps

• I was given the names of the two students.
• I looked them up in the Accounts table to get their student ids. Then used the student ids to find the RCIs in question. Since the RCI generation process only cares about Current rcis, I further filtered the query to only include RCIs where IsCurrent is true.
• I then also looked up the room assignments for one of them.
• I noticed that both residents stayed in the same room from summer housing to the fall semester. This threw the FindMissingRcis stored procedure off.
• Hmm looks like i haven't seen this case before.
• This is a tricky one to solve for good. The main issue here for future maintenance is that I am the only one that understands the FindMissingRcis stored procedure...and I can't possible figure out all the edge cases. Its a odd select statement that I came up that takes care of ~90%-95% of the cases properly. But the other 5% (which are edge cases that are bound to happen) are tricky to figure out.
• I might need to make an issue to revisit the rci generation process. We tried to strike a balance between ease for the user (they don't have to do anything) and ease for the developer (100% hard because that stored procedure is almost like a black box). I might need to rethink that 🤔
• The quick solution for now is to delete the current summer rcis for these two students.

[eanyanwu]

Yet another student cannot see her rci for the current semester
Steps

• Examined the rcis she has as well as the room assign record for her.
• This seems to be yet another case of ROOM_ASSIGN weirdness where the record changes after the rci has been created.
• In this case, the fix to this was setting the creation date of her 201801 conrad rci back to sometime before the assignment date of her current conrad room assignment (confusing, i know. Hopefully this convoluted logic will soon go away)

I REALLY need to figure a simpler procedure for generating rcis that does not assume that much about the ROOM_ASSIGN table. I have a simpler idea that will work, but will need to wait after checkin to try it out.