PSNODEINFO_VW

index back

SELECT A.MSGNODENAME , A.NODE_TYPE , A.LOCALDEFAULTFLG , B.URI_TEXT FROM %Table(PSMSGNODEDEFN) A ,%Table(PSNODEURITEXT) B WHERE A.MSGNODENAME=B.MSGNODENAME AND B.URI_TYPE = 'CN'

PeopleSoft Field NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
NODE_TYPECharacter(4)VARCHAR2(4) NOT NULLNode Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
LOCALDEFAULTFLGCharacter(1)VARCHAR2(1) NOT NULLLocal Default Node
URI_TEXTLong CharacterCLOBURI Text
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19