PSNODEVW

index back

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

Default: 0

AUTHOPTN Character(1) VARCHAR2(1) NOT NULL Integration Broker Authentication Option
C=Certificate
N=None
P=Password
COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
CONTACTMNGR Character(50) VARCHAR2(50) NOT NULL Integration Server Business Entity Contact Manager
CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number
CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
DESCRLONG Long Character CLOB Long Description
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.
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.
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19