Re: Identifying orphaned records in PeopleSoft

[skyway <skyway@USWEST.NET>]

All you need is the SQL to the tables directly.
Will try to get back as soon as possible.

Robin Cotton wrote:

> Good morning all!
>
> Has anyone ever written a program that identifies orphaned records in
> PeopleSoft?  We are using SQR 4.3.2, Oracle 7.3 and PeopleSoft 7.51.
> The client just hired a functional auditor who stated that many orphans
> existed, which I would agree to, but they did not disclose how they
> came about this information.
>
> I have searched CC as well as the delivered SQR directory but haven't
> found anything.
>
> Any code that anyone is willing to share would be much appreciated!
>
> ===
> Robin Cotton
> Triple-I
> PeopleSoft Consultant
> __________________________________________________
> Do You Yahoo!?
> Bid and sell for free at http://auctions.yahoo.com