QRY_NODEVW

index back

Message Node Definition

PSMSGNODEDEFN is a Tools table that holds definitions for Message Node objects. Message Nodes represent databases in Application Messaging. You create and modify Message Node objects with the Application Designer.
SELECT MSGNODENAME , VERSION , DESCR , ACTIVE_NODE , LOCALNODE , LOCALDEFAULTFLG , NODE_TYPE , ROUTINGTYPE , IB_SEGMENTAWARE , NONREPUDIATION , IB_DEFLTEXTUSERID , IB_TGTLOCATION , AUTHOPTN , IBPASSWORD , USERID , IBEXTERNALUSERID , IBEXTERNALPWD , IBEXTERNALVERSION , IB_THROTTLEVALUE , PORTAL_NAME , PORTALHOSTNODE , NETWORKNODENAME , HUBNODENAME , MASTERNODENAME , IMAGE_NAME , CODESETGROUPNAME , CONNGATEWAYID , CONNID , COMPANYID , CONTACTMNGR , CONTACTEMAIL , CONTACTPHONENBR , CONTACTURL , TOOLSREL , APMSGAPPREL , TOKENTYPE , TOKEN_ENCRYPTED , WSRP_RESP_WSS , TOKEN_SIGNED , IB_ENCRYPTLEVEL , IB_DELIVERYMODE , IB_NETWORK , LASTUPDDTTM , LASTUPDOPRID , DESCRLONG FROM PSMSGNODEDEFN WHERE NODE_TYPE = 'PIA'

  • Related language record: QRY_NODEVW_LANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    MSGNODENAMECharacter(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    ACTIVE_NODECharacter(1)VARCHAR2(1) NOT NULLActive Node
    0=No
    1=Yes

    Default: 1

    LOCALNODENumber(1,0)SMALLINT NOT NULLIndicates if a Message Node is the local message node

    Default: 0

    LOCALDEFAULTFLGCharacter(1)VARCHAR2(1) NOT NULLLocal Default Node

    Y/N Table Edit

    Default: N

    NODE_TYPECharacter(4)VARCHAR2(4) NOT NULLNode Type
    EX=External
    ICT=Pre-PeopleTools 8.4
    PIA=PeopleSoft

    Default: PIA

    ROUTINGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
    E=Explicit
    I=Implicit

    Default: I

    IB_SEGMENTAWARENumber(1,0)SMALLINT NOT NULLSegment Aware
    NONREPUDIATIONNumber(1,0)SMALLINT NOT NULLNon-Repudiation Support
    IB_DEFLTEXTUSERIDNumber(1,0)SMALLINT NOT NULLUse External User ID

    Default: 0

    IB_TGTLOCATIONCharacter(254)VARCHAR2(254) NOT NULLTarget Location
    AUTHOPTNCharacter(1)VARCHAR2(1) NOT NULLIntegration Broker Authentication Option
    C=Certificate
    N=None
    P=Password

    Default: N

    IBPASSWORDCharacter(88)VARCHAR2(88) NOT NULLIntegration Broker Password
    USERIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID

    Prompt Table: PSOPRDEFN_VW

    IBEXTERNALUSERIDCharacter(30)VARCHAR2(30) NOT NULLExternal User ID
    IBEXTERNALPWDCharacter(88)VARCHAR2(88) NOT NULLIntegration Broker External Password
    IBEXTERNALVERSIONCharacter(20)VARCHAR2(20) NOT NULLApplication Release
    IB_THROTTLEVALUENumber(5,0)INTEGER NOT NULLIB Throttle Threshold
    PORTAL_NAMECharacter(30)VARCHAR2(30) NOT NULLPortal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    PORTALHOSTNODECharacter(1)VARCHAR2(1) NOT NULLPortal Host Node
    N=No
    Y=Yes
    NETWORKNODENAMECharacter(30)VARCHAR2(30) NOT NULLNetwork Node Name
    HUBNODENAMECharacter(30)VARCHAR2(30) NOT NULLHub Node

    Prompt Table: PSHUBNODEVW

    MASTERNODENAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Master Business Entity ID

    Prompt Table: PSMSGNODEDEFN

    IMAGE_NAMECharacter(30)VARCHAR2(30) NOT NULLThe name of images used in Personalizations explanations.

    Prompt Table: PSCONTNAMEVW

    CODESETGROUPNAMECharacter(30)VARCHAR2(30) NOT NULLCode Set Group Name

    Prompt Table: PSCODESETGROUP

    CONNGATEWAYIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit

    Prompt Table: PSCONNGATEWAYVW

    CONNIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Connector ID

    Prompt Table: PSCONNIDVW

    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)
    TOOLSRELCharacter(20)VARCHAR2(20) NOT NULLTools Release Number
    APMSGAPPRELCharacter(20)VARCHAR2(20) NOT NULLApplication Release
    TOKENTYPECharacter(4)VARCHAR2(4) NOT NULLAuthentication Token Type
    NONE=None
    STSD=SAML Token
    USRT=Username Token
    UTNP=Username Token, no password

    Default: NONE

    TOKEN_ENCRYPTEDNumber(1,0)SMALLINT NOT NULLEncrypted
    WSRP_RESP_WSSNumber(1,0)SMALLINT NOT NULLWSRP WSS Enabled Response
    TOKEN_SIGNEDNumber(1,0)SMALLINT NOT NULLDigitally Signed
    IB_ENCRYPTLEVELCharacter(1)VARCHAR2(1) NOT NULLEncrypt Level
    A=All
    B=Body
    H=Header

    Default: H

    IB_DELIVERYMODENumber(5,0)INTEGER NOT NULLDelivery Mode
    IB_NETWORKNumber(1,0)SMALLINT NOT NULLPeopleSoft Integration Network
    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.
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19