PSPTIBNODE_VW

(SQL View)
Index Back

SELECT MSGNODENAME , DESCR , NODE_TYPE , ACTIVE_NODE , IB_TGTLOCATION 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 ACTIVE_NODE Character(1) VARCHAR2(1) NOT NULL Active Node
0=No
1=Yes
5 IB_TGTLOCATION Character(254) VARCHAR2(254) NOT NULL Target Location