PORTAL_LNODE_VW

index back

SELECT A.MSGNODENAME , A.DESCR , A.ACTIVE_NODE , A.LOCALNODE , A.LOCALDEFAULTFLG , A.NODE_TYPE FROM PSMSGNODEDEFN A WHERE A.LOCALNODE = 1

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).
DESCR Character(30) VARCHAR2(30) NOT NULL Description
ACTIVE_NODE Character(1) VARCHAR2(1) NOT NULL Active Node
0=No
1=Yes
LOCALNODE Number(1,0) SMALLINT NOT NULL Indicates if a Message Node is the local message node
LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node

Y/N Table Edit

NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19