PSPTMSGNODE_VW

(SQL View)
 Index Back

SELECT A.MSGNODENAME , A.LOCALDEFAULTFLG , A.DESCR FROM PSMSGNODEDEFN A WHERE ( ( A.LOCALDEFAULTFLG = 'Y') OR ( A.IB_NETWORK = 1 AND A.MSGNODENAME = ( SELECT B.MSGNODENAME FROM PSIBHUBDATA B WHERE B.MSGNODENAME = A.MSGNODENAME)))

# 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

Y/N Table Edit

Default Value: N

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description