Working with Definition Status
This section discusses how to work with definition status.
PeopleSoft Application Designer defines the status of a definition in the source and the target database.
|
Field or Control |
Definition |
|---|---|
| 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 LASTUPDDTTM 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 LASTUPDDTTM 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 LASTUPDDTTM 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 LASTUPDDTTM 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. PSRELEASE.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 |
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 |
|
Unknown |
Unknown |
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.
|
Field or Control |
Definition |
|---|---|
| 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.
|
Field or Control |
Definition |
|---|---|
| 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).
|
Field or Control |
Definition |
|---|---|
| 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).
|
Field or Control |
Definition |
|---|---|
| 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. |