Re: Average High Three Salary for Retirement Calculations

[ANDERSD2 <ANDERSD2@OAKWOOD.ORG>]

I don't think there is any such thing.  However, you should be able to build
a simple query that would average the employee...
select
a.emplid
,avg(a.comprate)

from ps_job a
where a.effdt >= '01-JAN-1999'
and a.effdt <= '31-DEC-2001'
group by a.emplid

You may need to add additional criteria to select only rows where there was
a change to the employee's wage.

-----Original Message-----
From: Cissell, Teresa [mailto:TCissell@NESPOWER.COM]
Sent: Wednesday, August 29, 2001 1:29 PM
To: SQR-USERS@list.iex.net
Subject: Average High Three Salary for Retirement Calculations


Does anyone have or know of an sqr routine that calculates an employee's
average salary over a 36-month period given data such as that stored in
PeopleSoft on PS_JOB?  (EMPLID, EFFDT, ANNUAL_RT).

Thanks,
Terry Cissell
Programmer/Analyst
SCT @ Nashville Electric Service
(615) 747-3066