PSPTTSTCMPTSTVW

index back

Tests in Compare Report

Union view of Tests with compare differences between source and target
SELECT DISTINCT A.PTSESSIONID , A.PTKEYVALUE1 , B.DESCR , B.PTTST_PARENTFOLDER FROM PSCOMPOBJDIFF A , PSPTTSTDEFN B WHERE A.OBJECTTYPE = 104 AND A.PTLOCALVALUE <> A.PTREMOTEVALUE AND A.PTKEYVALUE1 = B.PTTST_NAME UNION SELECT DISTINCT C.PTSESSIONID , C.PTKEYVALUE2 , D.DESCR , D.PTTST_PARENTFOLDER FROM PSCOMPOBJDIFF C , PSPTTSTDEFN D WHERE C.OBJECTTYPE = 105 AND C.PTLOCALVALUE <> C.PTREMOTEVALUE AND C.PTKEYVALUE2 = D.PTTST_NAME

PeopleSoft Field NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
PTTST_PARENTFOLDERCharacter(200)VARCHAR2(200) NOT NULLTest Parent Folder
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19