PSNODEVW (SQL View)	Index Back
Node View for Self Service Not used by Tools. Only remains because a applications product is using.

PSNODEVW

(SQL View)

Node View for Self Service

Not used by Tools. Only remains because a applications product is using.

SELECT MSGNODENAME , DESCR , ACTIVE_NODE , AUTHOPTN , COMPANYID , CONTACTMNGR , CONTACTEMAIL , CONTACTPHONENBR , CONTACTURL , DESCRLONG , LASTUPDDTTM , LASTUPDOPRID 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 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

11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	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
11	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
12	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.