Re: Compare

[Pietersz Mark x8921 <mpieters@CITIPOWER.COM.AU>]

Bill,

Another method you might consider is setting up an audit table in PeopleSoft
and letting the application monitor record changes.  You can then use SQR to
scan the audit action field in the audit table to determine the type of
record change that has occured.

Rgds

Mark Pietersz

> -----Original Message-----
> From: Bill Bowers [SMTP:bowersb@PSPH.PROVIDENCE.ORG]
> Sent: Tuesday, 29 December 1998 10:23
> To:   Multiple recipients of list SQR-USERS
> Subject:      Compare
>
>      I am using Oracle with PeopleSoft, developing a process to report
>      insurance benefit changes.  I have created a table with current and a
>      table with prior coverage information.  The tables both have the same
>      identical structure.  The differences between the table will be used
>      later in creating add and change data files for the insurance
> company.
>
>      Does anyone know a good method (for use in SQR)  to locate the
>      differences in the 2 tables.
>
>      Bill
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This email message has been swept for the presence of computer viruses.

CitiPower Pty ACN 064 651 056
**********************************************************************