Archiving has a benefit for sure, it makes sense to push out inactive records. For instance, a patient that is deceased for a year does not need to be taking up space in the DB. It has the benefits of faster queries and leaner results in general. I like it.
@juggernautsei I’m leery of adding a ew table for statuses. Could really complicate many queries. If you decide to go that route I’d suggest investing heavily in finding the most optimized SQL first. Probably include some level of join or sub-select’ing