PSMSGNODEDEFN

(SQL Table)
 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.

  • Related Language Record: PSNODEDEFNLANG

  • Parent Record Of PSCONNECTSTRING PSNODEDEFNLANG

    • # 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.
    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 CHECKTOKENID Character(254) VARCHAR2(254) NOT NULL CheckTokenID
    9 ROUTINGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
    E=Explicit
    I=Implicit

    Default Value: I

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

    Default Value: 0

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

    Default Value: N

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

    Prompt Table: PSOPRDEFN_VW

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

    Prompt Table: PSPRDMDEFN

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

    Prompt Table: PSHUBNODEVW

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

    Prompt Table: PSMSGNODEDEFN

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

    Prompt Table: PSCONTNAMEVW

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

    Prompt Table: PSCODESETGROUP

    28 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

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

    Prompt Table: PSCONNIDVW

    30 COMPANYID Character(15) VARCHAR2(15) NOT NULL Company ID
    31 CONTACTMNGR Character(50) VARCHAR2(50) NOT NULL Integration Server Business Entity Contact Manager
    32 CONTACTEMAIL Character(70) VARCHAR2(70) NOT NULL Integration Server Business Entity Contact Email
    33 CONTACTPHONENBR Character(24) VARCHAR2(24) NOT NULL Integration Server Business Entity Contact Phone Number
    34 CONTACTURL Character(254) VARCHAR2(254) NOT NULL Integration Server Business Entity Internet URL (Universal Resource Locator)
    35 TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
    36 APMSGAPPREL Character(20) VARCHAR2(20) NOT NULL Application Release
    37 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

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

    Default Value: H

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