SCC_NUR_NODE_VW

(SQL View)
Index Back

Node view

Used as a prompt to define the local node

SELECT DISTINCT MSGNODENAME , DESCR , NODE_TYPE , LOCALNODE , LOCALDEFAULTFLG FROM PSMSGNODEDEFN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
4 LOCALNODE Number(1,0) SMALLINT NOT NULL Indicates if a Message Node is the local message node
5 LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node