in a report listing employee's assignment at the time of performance review
is it possible to write a query listing an employee's assignment at the time of the their annual performance review?
I've tried pulling data from some view listing performance review data [date of review, results, etc.]
but when I pull data from emp_assignment tables I get many, many rows for each employee and I cant
align assignment that was current at the time of the perf. review.
thanks in advance for any ideas