Please consult the PeopleBooks: Navigation: > PeopleBooks > PeopleTools
Application Designer > Comparing Source and Target Definitions.
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.
The following table summarizes the possible status, action, and upgrade values
that could be applied to a single definition during the comparison process
.
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.
Application Designer > Comparing Source and Target Definitions.
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.
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
- Absent
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.
Really Awesome.
ReplyDelete