>>>Agree. If you ever need to interface to an HR or benefits system, they don't care WHETHER an employee was terminated. They need to know WHEN.
>>
>>And basically you only need one field, the termination date, if it is empty, then the employee is active, no need for an extra flag
>
>Active is
another property. An employee can be inactive due to being suspended or being in jail or for whatever other reason.
Yes, I was referring to the property to know if the employee is still working for the company or was terminated, I think Naomi called it active so I used the same term (it might've been my wrong impression), FWIW, I meant you do not need a terminated flag
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges