>Also, I suggest not using Date in a field name as it's probably a DateTime. So, something like LastConfirmedDate becomes WhenConfirmed.
Yes, you are right. I never use it as well. This was a bad example. It should have been LastConfirmed.
WhenConfirmed would not work in cases of having FirstConfirmed and LastConfirmed, which we have in a lot of places, where two values represent the same entity. WhenConfirmed would not indicate the state.