Skip to Content
0
Former Member
Dec 17, 2011 at 07:44 PM

Report problem on Time dependent 0EMPLOYEE attributes

17 Views

Hi,

I am trying to create a report which will compare an employee's current pay rate and the last recent pay rate and will show the percent increase. Here is an example,

EMP_NO VALIDFROM VALID TO RATE

0001 02/02/2010 02/02/2011 $10.00

0001 02/03/2011 12/31/9999 $ 12.00

I am trying to report using 0EMPLOYEE, but can not pull two records to compare. If I use key dates, I can only pull one record which do not serve the purpose. I thought of creating a customer exit variable but sure of the modeling.

Any ideas??

Thank you.