W-2's and PeopleSoft and SQR.

["Veso M. Lukovic" <VMLukovi@STVINCENT.ORG>]

PeopleSoft 7.02 HRMS
Oracle 7.3.2.whatever
SQR Version 3.0

Hello all!  I have appreciated all your help, so at the end of this
message, I have attached the code for a view which will extract last
name, first name, and middle initial from the name string in P.Soft
(even when the middle initial is attached to the first name,.
Smith,MaryA).  Just a token of my appreciation!


Now for my question.  Our understanding is that in order to create
W-2's for the year end, we have to upgrade our application to 7.05,
which means we have to upgrade Tools to 7.05, which also means we have
to upgrade SQR to 4.3.x.  Since we have so many custom SQR's, we may
have a lot of work to do, at a bad time.  Is anyone out there going
out on a limb, and working an alternative solution?  PeopleSoft of
course has offered to adjust things for us, for a huge fee of course.
Any advise would be appreciated.., it may be best to just bite the
bullet and get it done now..


Thanks again for your help in advance!


Here's the code for the view:


SELECT
EMPLID,
NAME,
SUBSTR(NAME,1,INSTR(NAME,',') - 1) ,
DECODE(INSTR('ABCDEFGHIJKLMNOPQRSTUVWXYZ',SUBSTR(NAME,LENGTH(NAME),1)),0,
         RTRIM(SUBSTR(NAME,INSTR(NAME,',') + 1,LENGTH(NAME) -
INSTR(NAME,',')),' '),
                 RTRIM(SUBSTR(NAME,INSTR(NAME,',') + 1,LENGTH(NAME) -
1 - INSTR(NAME,',')),' ')) ,
DECODE(INSTR('ABCDEFGHIJKLMNOPQRSTUVWXYZ',SUBSTR(NAME,LENGTH(NAME),1)),0,
         ' ',
                 SUBSTR(NAME,LENGTH(NAME),1))

FROM PS_PERSONAL_DATA