QRY_NODEVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 ACTIVE_NODE Character(1) VARCHAR2(1) NOT NULL Active Node
    0=No
    1=Yes

    Default Value: 1

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

    Default Value: 0

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: PIA

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

    Default Value: I

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

    Default Value: 0

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

    Default Value: N

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: PSPRDMDEFN

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

    Prompt Table: PSHUBNODEVW

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

    Prompt Table: PSMSGNODEDEFN

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

    Prompt Table: PSCONTNAMEVW

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

    Prompt Table: PSCODESETGROUP

    27 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

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

    Prompt Table: PSCONNIDVW

    29 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    30 CONTACTMNGR Character(50) VARCHAR2(50) NOT NULL Integration Server Business Entity Contact Manager
    31 CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
    32 CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number
    33 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
    34 TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
    35 APMSGAPPREL Character(20) VARCHAR2(20) NOT NULL Application Release
    36 TOKENTYPE Character(4) VARCHAR2(4) NOT NULL Authentication Token Type
    NONE=None
    STSD=SAML Token
    USRT=Username Token
    UTNP=Username Token, no password

    Default Value: NONE

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

    Default Value: H

    41 IB_DELIVERYMODE Number(5,0) INTEGER NOT NULL Delivery Mode
    42 IB_NETWORK Number(1,0) SMALLINT NOT NULL PeopleSoft Integration Network
    43 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.
    44 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.
    45 DESCRLONG Long Character CLOB Long Description