PSCOMPSES_SRHVW

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

Y/N Table Edit