Re: data comparsion

[Elvis Pressly <elvisdman@HOTMAIL.COM>]

Using max effdt as suggested earlier by some of our gurus, will
enable you to extract the information that you would need. However,
effdt alone will not solved your problem. You will have to use ACTION
or ACTION/REASON combination to get the previous record. What you really
want to accomplished is to extract the last pay increase(with
an action of PAY). This record should have an effdt less than the most
current record. Another aspect to consider is how do you define those
that were terminated then rehired with different pay scale?

I believe you may have to look at your company policy regarding those who
have been REHIRED. If I had to do it, I would looked at history and that
depends on the company policy.


>From: Lorraine Ambrosio <lorraine.ambrosio@TECKCOMINCO.COM>
>Reply-To: sqr-users@list.iex.net
>To: SQR-USERS@list.iex.net
>Subject: data comparsion
>Date: Fri, 19 Apr 2002 19:23:27 -0600
>
>I want to compare for the same person, the most recent date/salary with the
>last prior record. How do I get the 2nd record?
>
>
>eg. fields
>empnbr  eff_date    annual_salary
>
>12345   01-Apr-2002  50,000  max(eff_date)
>12345   01-Apr-2001  40,000  ???
>
>then take 50,000 / 40,000 * .02 / 9/14 = net adj.




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.