Compare Report

Comparing Source and Target Definitions — PeopleSoft Application Designer

Determining Definition Status

PeopleSoft Application Designer defines the status of a definition in the source and the target database.

Unknown	Definition has not been compared. This is the default status for all definitions inserted manually into a project and the permanent status of all non-comparison definitions.
Absent	The definition was found in the other database, but not in this one. When upgrading to a new PeopleSoft release, all new PeopleSoft definitions should have Absent status in the target database and all of your custom definitions should have Absent in the source database.
Changed	The definition has been compared, the LASTUPDOPRID value is PPLSOFT, and the LASTUPDDTM value is greater than the date/time stamp of the comparison release database. This indicates that PeopleSoft modified the definition since the comparison release.
Unchanged	The definition has been compared, the LASTUPDOPRID value is PPLSOFT, and the LASTUPDDTM value is less than or equal to the date/time stamp of the comparison release database. This indicates that PeopleSoft modified the definition prior to the comparison release.
*Changed	The definition has been compared, the LASTUPDOPRID value is not PPLSOFT, and the LASTUPDDTM value is greater than the date/time stamp of the comparison release database. This indicates that a customer modified the definition since the comparison release.
*Unchanged	The definition has been compared, the LASTUPDOPRID value is not PPLSOFT, and the LASTUPDDTM value is less than or equal to the date/time stamp of the comparison release database. This indicates that a customer modified the definition prior to the comparison release.
Same	The definition has been compared and is defined the same in both databases. When a definition in one database has this status its counterpart in the other database will have the equivalent status. This status can be seen when performing a project comparison because with a project comparison the definitions are static; the project is not repopulated based on the comparison results. This status is not seen in a database comparison, because when doing so the project is populated only with definitions defined differently.

Note. Compare by release date is determined by finding the highest release label in common between the source and target databases. PSRELASE.RELEASELABEL column is searched on both source and target to find the latest common value between the two. Then PSRELEASE.PSRELEASEDTTM for that label is used for compare by release date for the source and target, respectively. You can override this value to set a different release label, or specific compare by date, on the Upgrade Options interface. Only common release labels (found on both source and target PSRELEASE table) can be used.

Comparing Source Status to Target Status

The following table summarizes the possible status, action, and upgrade values that could be applied to a single definition during the comparison process.

Source Status	Target Status	Action	Other Action	PeopleSoft Vanilla	Keep Customizations
Absent	Changed or Unchanged	DELETE	None	True	True
Absent	*Changed or *Unchanged	DELETE	None	False	False
Changed	Absent	COPY	None	True	True
Changed	Changed or Unchanged	COPY	COPYPROP	True	True
Changed	*Changed or *Unchanged	COPY	COPYPROP	True	False
Unchanged	Absent	COPY	None	True	True
Unchanged	Changed	COPY	COPYPROP	False	False
Unchanged	Unchanged	COPY	COPYPROP	True	True
Unchanged	*Changed or *Unchanged	COPY	COPYPROP	True	False
*Changed	Absent	COPY	None	True	True
*Changed	Changed or Unchanged	COPY	COPYPROP	False	True
*Changed	*Changed or *Unchanged	COPY	COPYPROP	True	True
*Unchanged	Absent	COPY	None	True	True
*Unchanged	Changed or Unchanged	COPY	COPYPROP	False	True
*Unchanged	*Changed	COPY	COPYPROP	False	False
*Unchanged	*Unchanged	COPY	COPYPROP	True	True
Absent	Absent	None	None	False	False
Same	Same	None	None	False	False
Unkown	Unkown	None	None	False	False

The Action, Other Action, PeopleSoft Vanilla, and Keep Customizations are described in the following sections.

Action

Describes the upgrade action set for an item.

DELETE	(DEL) The item will be deleted from the target database during the copy.
COPY	The item will be copied to the target database during the copy.

Other Action

Describes the action when the system finds differences in record or field definitions.

Note. Used for record and field definitions only.

COPYPROP	Copy properties of the item only. That is, for records, only copy the record definition, and not record fields. For fields, copy field definition only, and not the field labels.
NONE	Use the default action instead (DELETE or COPY).

PeopleSoft Vanilla

Describes the setting of the Upgrade flag for the project item when performing the Vanilla Compare type (set on Upgrade Options).

True	Upgrade flag is ON.
False	Upgrade flag is OFF. You must override this value in order to have Copy perform the action set in the Action column.

Keep Customization

Describes the setting of the Upgrade flag for the project item when performing the Keep Customizations Compare type (set on Upgrade Options).

True	Upgrade flag is ON.
False	Upgrade flag is OFF. You must override this value in order to have Copy perform the action set in the Action column.