PSNODEDEFNVW

(SQL View)
Index Back

Active Node Definition View

View of Active Nodes

SELECT MSGNODENAME , DESCR , ACTIVE_NODE , AUTHOPTN , COMPANYID , CONTACTMNGR , CONTACTEMAIL , CONTACTPHONENBR , CONTACTURL , DESCRLONG FROM PSMSGNODEDEFN WHERE ACTIVE_NODE = '1'

# 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 ACTIVE_NODE Character(1) VARCHAR2(1) NOT NULL Active Node
0=No
1=Yes

Default Value: 0

4 AUTHOPTN Character(1) VARCHAR2(1) NOT NULL Integration Broker Authentication Option
C=Certificate
N=None
P=Password
5 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
6 CONTACTMNGR Character(50) VARCHAR2(50) NOT NULL Integration Server Business Entity Contact Manager
7 CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
8 CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number
9 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
10 DESCRLONG Long Character CLOB Long Description