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 Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
PTTST_PARENTFOLDER Character(200) VARCHAR2(200) NOT NULL Test Parent Folder
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19