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 Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PROJECTNAME Character(30) VARCHAR2(30) NOT NULL Project Name (see PSPROJECTDEFN).
PROJECTDESCR Character(30) VARCHAR2(30) NOT NULL Project Description
PTADSCONTENT_FLG Character(1) VARCHAR2(1) NOT NULL Data Migration Project
N=No
Y=Yes

Y/N Table Edit

index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20