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 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).
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    ACTIVE_NODE Character(1) VARCHAR2(1) NOT NULL Active Node
    0=No
    1=Yes

    Default: 1

    LOCALNODE Number(1,0) SMALLINT NOT NULL Indicates if a Message Node is the local message node

    Default: 0

    LOCALDEFAULTFLG Character(1) VARCHAR2(1) NOT NULL Local Default Node

    Y/N Table Edit

    Default: N

    NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
    EX=External
    ICT=Pre-PeopleTools 8.4
    PIA=PeopleSoft

    Default: PIA

    ROUTINGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
    E=Explicit
    I=Implicit

    Default: I

    IB_SEGMENTAWARE Number(1,0) SMALLINT NOT NULL Segment Aware
    NONREPUDIATION Number(1,0) SMALLINT NOT NULL Non-Repudiation Support
    IB_DEFLTEXTUSERID Number(1,0) SMALLINT NOT NULL Use External User ID

    Default: 0

    IB_TGTLOCATION Character(254) VARCHAR2(254) NOT NULL Target Location
    AUTHOPTN Character(1) VARCHAR2(1) NOT NULL Integration Broker Authentication Option
    C=Certificate
    N=None
    P=Password

    Default: N

    IBPASSWORD Character(88) VARCHAR2(88) NOT NULL Integration Broker Password
    USERID Character(30) VARCHAR2(30) NOT NULL A user's ID

    Prompt Table: PSOPRDEFN_VW

    IBEXTERNALUSERID Character(30) VARCHAR2(30) NOT NULL External User ID
    IBEXTERNALPWD Character(88) VARCHAR2(88) NOT NULL Integration Broker External Password
    IBEXTERNALVERSION Character(20) VARCHAR2(20) NOT NULL Application Release
    IB_THROTTLEVALUE Number(5,0) INTEGER NOT NULL IB Throttle Threshold
    PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

    Prompt Table: PSPRDMDEFN

    PORTALHOSTNODE Character(1) VARCHAR2(1) NOT NULL Portal Host Node
    N=No
    Y=Yes
    NETWORKNODENAME Character(30) VARCHAR2(30) NOT NULL Network Node Name
    HUBNODENAME Character(30) VARCHAR2(30) NOT NULL Hub Node

    Prompt Table: PSHUBNODEVW

    MASTERNODENAME Character(30) VARCHAR2(30) NOT NULL Integration Server Master Business Entity ID

    Prompt Table: PSMSGNODEDEFN

    IMAGE_NAME Character(30) VARCHAR2(30) NOT NULL The name of images used in Personalizations explanations.

    Prompt Table: PSCONTNAMEVW

    CODESETGROUPNAME Character(30) VARCHAR2(30) NOT NULL Code Set Group Name

    Prompt Table: PSCODESETGROUP

    CONNGATEWAYID Character(30) VARCHAR2(30) NOT NULL Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit

    Prompt Table: PSCONNGATEWAYVW

    CONNID Character(30) VARCHAR2(30) NOT NULL Integration Server Connector ID

    Prompt Table: PSCONNIDVW

    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)
    TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
    APMSGAPPREL Character(20) VARCHAR2(20) NOT NULL Application Release
    TOKENTYPE Character(4) VARCHAR2(4) NOT NULL Authentication Token Type
    NONE=None
    STSD=SAML Token
    USRT=Username Token
    UTNP=Username Token, no password

    Default: NONE

    TOKEN_ENCRYPTED Number(1,0) SMALLINT NOT NULL Encrypted
    WSRP_RESP_WSS Number(1,0) SMALLINT NOT NULL WSRP WSS Enabled Response
    TOKEN_SIGNED Number(1,0) SMALLINT NOT NULL Digitally Signed
    IB_ENCRYPTLEVEL Character(1) VARCHAR2(1) NOT NULL Encrypt Level
    A=All
    B=Body
    H=Header

    Default: H

    IB_DELIVERYMODE Number(5,0) INTEGER NOT NULL Delivery Mode
    IB_NETWORK Number(1,0) SMALLINT NOT NULL PeopleSoft Integration Network
    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.
    DESCRLONG Long Character CLOB Long Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19