+1 on the soft deletes. It potentially adds a corner case to everything you do with that record. It's a permanent tax on your productivity. If you can get aw

+1 on the soft deletes. It potentially adds a corner case to everything you do with that record. It's a permanent tax on your productivity. If you can get away with it, its much better to just delete it out, perhaps moving it into some archive table incase you change your mind later.