PSPTTSTCMPTSTVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
2 PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 PTTST_PARENTFOLDER Character(200) VARCHAR2(200) NOT NULL Test Parent Folder