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 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
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
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