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 NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ACTIVE_NODECharacter(1)VARCHAR2(1) NOT NULLActive Node
0=No
1=Yes
LOCALNODENumber(1,0)SMALLINT NOT NULLIndicates if a Message Node is the local message node
LOCALDEFAULTFLGCharacter(1)VARCHAR2(1) NOT NULLLocal Default Node

Y/N Table Edit

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