Mapping employees to labor categories
In this example, our demo company has created contract labor categories by employee.
|
Category table EMPL | ||
|
Labor category |
Mapped to |
Effective date |
|
SCIENT1 |
Employee 101357 |
01/01/08 |
|
SCIENT2 |
Employee 107099 |
06/01/08 |
|
SCIENT3 |
Employee 100417 |
01/01/08 |
|
SCIENT3 |
Employee 107099 |
01/01/08 |
|
PROGR1 |
Employee 100349 |
06/01/08 |
|
PROGR2 |
Employee 100349 |
01/01/08 |
|
LABTCH |
Employee 100250 |
01/01/08 |
In the table above, you can see that employee 107099 is mapped to both labor category SCIENT3 and labor category SCIENT2. The effective date shows that as of 06/01/08, the employee switched to the higher level.
The same situation exists for employee 100349, who moved from category PROGR2 up to category PROGR1.