PeopleSoft Compare Reports

PeopleSoft Compare Reports provide a means to compare PeopleSoft objects present in one database against a different database or a file. This can be done at a Project level or at database level.

Compare reports come in very handy before performing migrations as well as during upgrades.
In this post, we will discuss the different statuses that are shown on a PeopleSoft Compare Reports when one project is compared against another database.

Statuses in PeopleSoft Compare Reports

PeopleSoft shows the following statuses on Compare Reports.
Each status has its own meaning and significance during an upgrade.
Let’s look at each one of them.

Same

The compared definitions are the same in both the databases that are compared.
Such definitions need not be migrated to the other database.

Absent

This status is shown when the definition is present in one of the databases but not in the other.
If the target database does not have the definition, it may have to be migrated.
If the source database does not have the definition, it may have to be deleted from the target.

Unknown

This is the default status for all non-comparison definitions.
PeopleSoft doesn’t compare the definitions that show this status.
They may have to be compared manually or using a non-PeopleSoft utility.

Changed

This status states that there is a change in the definitions that are being compared, across the databases.
This also states that the change was carried out by PeopleSoft (Oprid PPLSOFT)

*Changed

This status states that there is a change in the definitions that are being compared, across the databases.
But unlike the previous status, in this case, the change was carried out NOT by PeopleSoft.

Unchanged

Unlike the literal meaning of this status, there were changes found in this case as well.
But the date-time stamp on such definitions is prior to the release date-time stamp on the compared databases.
It also states that the change was carried out by PeopleSoft.

*Unchanged

This status is similar in meaning to the above status except that the changes to the objects, in this case, was carried out NOT by PeopleSoft.