再问----PS 的Compare report的status

gelinqing

changed,unchanged,*changed,*unchanged的这几种状态是根据psrelease的时间以及相关的object的定义表里的LASTUPDOPRID和LASTUPDDTM得到的。
eg：changed---PSBOOK里所描述的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. 我想知道的是该status是source的LASTUPDDTM ，LASTUPDOPRID 与source的date/time stamp 相比得到的还是和target的date/time stamp 相比得到的？

gelinqing

我把出现same status的object修改了他们的LASTUPDDTM 然后再compare 还是same
那么请问Same的status又是如何对比的？

gelinqing

Then PSRELEASE.PSRELEASEDTTM for that label is used for compare by release date for the source and target, respectively.
最后一个单词可以看出是各自比各自的。

gelinqing

Compare Status
There are 7 compare status types in PeopleSoft.
•        Unknown Before Comparison’s default status and the default status of all non-comparable objects.
•        Absent Found in other DB and not in this one.
•        Same The object has been compared and is defined the same in both the databases.
•        Changed The LASTUPDOPRID value is “PPLSOFT” and its LASTUPDDTTM value is greater than datetime stamp of each database.
•        Unchanged The LASTUPDOPRID value is “PPLSOFT” and its LASTUPDDTTM value is less than or equal to the datetime stamp of each database.
•        *Changed the LASTUPDOPRID value is not “PPLSOFT” and its LASTUPDDTTM value is greater than datetime stamp of each database.
•        *Unchanged the LASTUPDOPRID value is not “PPLSOFT” and its LASTUPDDTTM value is less than or equal to the datetime stamp of each database.
Compare steps
1: System check the object if exist in DB for each at first. System would give the absent status when the object not found in DB and the exit the compare steps. If the object exists in each database system would do the next compare steps.
2: System would check the object definition if the same in both the databases. If yes the status become same, if not the status would be one of these status----Changed or Unchanged or *Changed or *Unchanged.
3: The PeopleSoft system uses several system tables PSRELEASE and the various definition tables, to record modified data time and which operator modified the object. This PSRELEASE table contains rows of data for every release level at which the database has ever existed. It has 2 columns, RELEASEDTTM and RELEASELABEL. The first column RELEASEDTTM contains a date time stamp identifying when each release level was stamped. RELEASELABEL identifies the release level. When comparing 2 databases, you can compare on date or on release level. Both methods use data and time to determine the object status. Each PeopleTools Object type record for example, for object type of Records, there is a PeopleTool table called PSRECDEFN, this would include 2 columns like LASTUPDORPID and LASTUPDDTTM which would tell us who the last updated Oprid is and Last updated date time.