MSGNODENAMEPSTRUSTNODELIST |
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 | Field Type | Column Type | Description |
|---|---|---|---|
| MSGNODENAME |
Character(30) | VARCHAR2(30) NOT NULL | Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN). |
| LOCALDEFAULTFLG | Character(1) | VARCHAR2(1) NOT NULL | Local Default Node |
| TOOLSREL | Character(20) | VARCHAR2(20) NOT NULL | Tools Release Number |
| CHECKTOKENID | Character(254) | VARCHAR2(254) NOT NULL | CheckTokenID |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |