Mike Cunningham wrote:
It is a field used for when an account will expire. For fulltime
employees it is set to 12/31/9999 (highest value allowed) since
fulltime employees are hired forever or until HR says they left.
Part-timers and special accounts are set to a known exit date that is
know when they are hired so we can re-verify the account is still
needed or delete it

How about making the field null capable and setting the value to null
when the employee is permanent?


Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact