PSTRUSTNODELIST

(SQL View)

SELECT A.MSGNODENAME , A.LOCALDEFAULTFLG , A.TOOLSREL , C.PTIBCIPHERDATA FROM PSMSGNODEDEFN A , PSTRUSTNODES B , PSIBCIPHERTOKEN C WHERE A.MSGNODENAME = B.MSGNODENAME AND A.MSGNODENAME = C.MSGNODENAME AND A.active_node ='1' AND A.AUTHOPTN IN ('C','P') AND A.LOCALDEFAULTFLG = 'N' AND C.PTIBCIPHERTYPE IN ('C') UNION ALL SELECT D.MSGNODENAME , D.LOCALDEFAULTFLG , E.TOOLSREL , F.PTIBCIPHERDATA FROM PSMSGNODEDEFN D , PSSTATUS E , PSIBCIPHERTOKEN F WHERE D.LOCALDEFAULTFLG = 'Y' AND D.MSGNODENAME = F.MSGNODENAME AND D.active_node ='1' AND D.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 PTIBCIPHERDATA Long Character CLOB Cipher Data

#	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	PTIBCIPHERDATA	Long Character	CLOB	Cipher Data