Re: Identifying orphaned records in PeopleSoft

[Carlton Conley <cconley@CDG-INC.COM>]

Don't you love consultants that tell you there is a problem but not where,
why and how to fix!!!

The you can find the parent names of "most" of the peoplesoft tables in the
psrecdefn table and then simple queries using emplid not in (select emplid
from parent_table) will give you the orphaned records

> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Robin Cotton
> Sent: Tuesday, September 14, 1999 8:23 AM
> To: Multiple recipients of list SQR-USERS
> Subject: Identifying orphaned records in PeopleSoft
>
>
> 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
>