PSCOMPSES_SRHVW

index back

Compare Session Search View

This view is used by the Compare Administration component.
SELECT C.PTSESSIONID , C.PROJECTNAME , P.PROJECTDESCR , CASE C.PTSESSIONTYPE WHEN 'ADS' THEN 'Y' ELSE 'N' END AS PTADSCONTENT_FLG FROM %Table(PSCOMPSESSION) C LEFT OUTER JOIN %Table(PSPROJECTDEFN) P ON C.PROJECTNAME = P.PROJECTNAME WHERE (C.PTSESSIONTYPE <> 'ADS' OR C.RUNDTTM <> ( SELECT MAX(RUNDTTM) FROM %Table(PSCOMPSESSION) S WHERE S.PROJECTNAME = P.PROJECTNAME) OR NOT EXISTS ( SELECT 'X' FROM %Table(PSPROJECTDEFN) P2 WHERE P2.PROJECTNAME = C.PROJECTNAME) ) AND NOT EXISTS ( SELECT 'X' FROM %Table(PSCOMPOBJDIFF) D WHERE D.PTSESSIONID = C.PTSESSIONID AND D.COMPARETYPE > 2)

PeopleSoft Field NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
PROJECTDESCRCharacter(30)VARCHAR2(30) NOT NULLProject Description
PTADSCONTENT_FLGCharacter(1)VARCHAR2(1) NOT NULLData Migration Project
N=No
Y=Yes

Y/N Table Edit

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19