PSIBRTNGDEFN

index back

IB Routing Definitions


  • Related language record: PSRTNGDFNLANG
  • PeopleSoft Field Name Field Type Column Type Description
    ROUTINGDEFNNAME Character(30) VARCHAR2(30) NOT NULL Routing Name
    EFFDT Date(10) DATE Effective Date

    Default: %date

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default: A

    SENDERNODENAME Character(30) VARCHAR2(30) NOT NULL Sender Node Name

    Prompt Table: PSMSGNODEDEFN

    RECEIVERNODENAME Character(30) VARCHAR2(30) NOT NULL Receiver Node Name

    Prompt Table: PSMSGNODEDEFN

    RTNGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
    A=Asynchronous - One Way
    N=Synchronous Non-Blocking
    R=Asynch Request/Response
    S=Synchronous
    X=Asynch to Synch
    IB_DELAYPROCESSING Number(6,0) INTEGER NOT NULL Delay Processing
    IB_RESTMETHOD Character(10) VARCHAR2(10) NOT NULL REST Method
    IB_SYNCHNONBLOCK Character(1) VARCHAR2(1) NOT NULL User Exception

    Y/N Table Edit

    Default: N

    IB_ACCEPT_COMP Character(1) VARCHAR2(1) NOT NULL Accept Compression

    Y/N Table Edit

    Default: N

    IB_SCHEMA_DETAILS Character(1) VARCHAR2(1) NOT NULL Schema Validation Details

    Y/N Table Edit

    Default: N

    IB_UNORDER_SEGMENT Character(1) VARCHAR2(1) NOT NULL Unorder Segments
    N=No
    Y=Yes
    IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).

    Prompt Table: PSOPERATION

    VERSIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation Version

    Prompt Table: PSOPRVERDFN

    CONNOVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Connector

    Y/N Table Edit

    Default: N

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

    Prompt Table: PSGATEWAY

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

    Prompt Table: PSCONN

    LOGMSGDTLFLG Number(1,0) SMALLINT NOT NULL Log Message Detail?

    Default: 0

    IB_DELIVERYMODE Number(5,0) INTEGER NOT NULL Delivery Mode
    ONSNDHDLRNAME Character(30) VARCHAR2(30) NOT NULL OnSend Handler

    Prompt Table: PSSRVHDLRSND_VW

    ONRCVHDLRNAME Character(30) VARCHAR2(30) NOT NULL OnReceive Handler

    Prompt Table: PSSRVHDLRRCV_VW

    ONPREHDLRNAME Character(30) VARCHAR2(30) NOT NULL OnPreNotify Handler

    Prompt Table: PSSRVHDLRPRN_VW

    ONPOSTHDLRNAME Character(30) VARCHAR2(30) NOT NULL OnPostNotify Handler

    Prompt Table: PSSRVHDLRPTN_VW

    GENERATED Character(1) VARCHAR2(1) NOT NULL System Generated

    Y/N Table Edit

    Default: N

    IB_ARR_SECURE_EP Character(1) VARCHAR2(1) NOT NULL ARR Secure EndPoint
    IB_LOCALIDFLG Number(1,0) SMALLINT NOT NULL Local Node Validation Flag
    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.
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    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