PSNODEDEFNVW

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 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
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19