Dear experts,
In all the examples I came across on the internet so far for an Employees Table, I notice that only a hire date and, at times, the date of birth are mentioned?
Is it incorrect to add an employee end date in that table?
EmployeeT
EmployeeID_PK
EmplFirstName
EmplLastName
EmplFunctionID_FK
EmplDepartmentID_FK
EmplDOB
EmplStatusID_FK
EmplHireDate
EmplEndDate ??
In all the examples I came across on the internet so far for an Employees Table, I notice that only a hire date and, at times, the date of birth are mentioned?
Is it incorrect to add an employee end date in that table?
EmployeeT
EmployeeID_PK
EmplFirstName
EmplLastName
EmplFunctionID_FK
EmplDepartmentID_FK
EmplDOB
EmplStatusID_FK
EmplHireDate
EmplEndDate ??