showing a historical assignment as latest for some employees
Summary:
We have an issue where the top (or Max) row is not returning the correct row! Instead of returning the current assignment, it is returning an old assignment for few employees. When I added an RCOUNT column (RCOUNT(1 by Person Number), it was clear that the row with max number is pointing to an older inactive assignment!
This issue is causing the employee record to falloff our Employees reports!
Content (please ensure you mask any confidential information):
- Person (3) in attached screenshot! His current (Max) assignment is E224674-2, but the MAX Rcount is actually pointing to Assignment (P224674)
- Persons 1 and 2 are provided as an example of the rest of the population and are reflecting the correct RCOUNT/ Order
Tagged:
0