PTCAC_NODE_VW

index back

Node View

New view for selecting nodes;
SELECT 'LOCAL_NODE' , ' ' , 1 , 'Y' , 'PIA' FROM PSMSGNODEDEFN FILL UNION SELECT FILL.MSGNODENAME , FILL.DESCR , FILL.LOCALNODE , FILL.LOCALDEFAULTFLG , FILL.NODE_TYPE FROM PSMSGNODEDEFN FILL

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
LOCALNODENumber(1,0)SMALLINT NOT NULLIndicates if a Message Node is the local message node
LOCALDEFAULTFLGCharacter(1)VARCHAR2(1) NOT NULLLocal Default Node
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