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 NameField TypeColumn TypeDescription
MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ACTIVE_NODECharacter(1)VARCHAR2(1) NOT NULLActive Node
0=No
1=Yes

Default: 0

AUTHOPTNCharacter(1)VARCHAR2(1) NOT NULLIntegration Broker Authentication Option
C=Certificate
N=None
P=Password
COMPANYIDCharacter(15)VARCHAR2(15) NOT NULLCompany ID
CONTACTMNGRCharacter(50)VARCHAR2(50) NOT NULLIntegration Server Business Entity Contact Manager
CONTACTEMAILCharacter(70)VARCHAR2(70) NOT NULLIntegration Server Business Entity Contact Email
CONTACTPHONENBRCharacter(24)VARCHAR2(24) NOT NULLIntegration Server Business Entity Contact Phone Number
CONTACTURLCharacter(254)VARCHAR2(254) NOT NULLIntegration Server Business Entity Internet URL (Universal Resource Locator)
DESCRLONGLong CharacterCLOBLong Description
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.ukPeopleTools 8.54
PTRef generated on 09-JUN-19