PSTRUSTNODELIST

(SQL View)
 Index Back

SELECT A.MSGNODENAME , A.LOCALDEFAULTFLG , A.TOOLSREL , A.CHECKTOKENID FROM PSMSGNODEDEFN A , PSTRUSTNODES B WHERE A.MSGNODENAME = B.MSGNODENAME AND A.active_node ='1' AND A.AUTHOPTN IN ('C','P') AND A.LOCALDEFAULTFLG = 'N' UNION ALL SELECT C.MSGNODENAME , C.LOCALDEFAULTFLG , D.TOOLSREL , C.CHECKTOKENID FROM PSMSGNODEDEFN C , PSSTATUS D WHERE C.LOCALDEFAULTFLG = 'Y' AND C.active_node ='1' AND C.AUTHOPTN IN ('C','P')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2 LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node
3 TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
4 CHECKTOKENID Character(254) VARCHAR2(254) NOT NULL CheckTokenID