PSIBRTNGDEFN

index back

IB Routing Definitions


  • Related language record: PSRTNGDFNLANG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    ROUTINGDEFNNAMECharacter(30)VARCHAR2(30) NOT NULLRouting Name
    EFFDTDate(10)DATEEffective Date

    Default: %date

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive

    Default: A

    SENDERNODENAMECharacter(30)VARCHAR2(30) NOT NULLSender Node Name

    Prompt Table: PSMSGNODEDEFN

    RECEIVERNODENAMECharacter(30)VARCHAR2(30) NOT NULLReceiver Node Name

    Prompt Table: PSMSGNODEDEFN

    RTNGTYPECharacter(1)VARCHAR2(1) NOT NULLRouting Type
    A=Asynchronous - One Way
    N=Synchronous Non-Blocking
    R=Asynch Request/Response
    S=Synchronous
    X=Asynch to Synch
    IB_DELAYPROCESSINGNumber(6,0)INTEGER NOT NULLDelay Processing
    IB_RESTMETHODCharacter(10)VARCHAR2(10) NOT NULLREST Method
    IB_SYNCHNONBLOCKCharacter(1)VARCHAR2(1) NOT NULLUser Exception

    Y/N Table Edit

    Default: N

    IB_ACCEPT_COMPCharacter(1)VARCHAR2(1) NOT NULLAccept Compression

    Y/N Table Edit

    Default: N

    IB_SCHEMA_DETAILSCharacter(1)VARCHAR2(1) NOT NULLSchema Validation Details

    Y/N Table Edit

    Default: N

    IB_UNORDER_SEGMENTCharacter(1)VARCHAR2(1) NOT NULLUnorder Segments
    N=No
    Y=Yes
    IB_OPERATIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation (see PSOPERATION).

    Prompt Table: PSOPERATION

    VERSIONNAMECharacter(30)VARCHAR2(30) NOT NULLService Operation Version

    Prompt Table: PSOPRVERDFN

    CONNOVERRIDECharacter(1)VARCHAR2(1) NOT NULLOverride Connector

    Y/N Table Edit

    Default: N

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

    Prompt Table: PSGATEWAY

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

    Prompt Table: PSCONN

    LOGMSGDTLFLGNumber(1,0)SMALLINT NOT NULLLog Message Detail?

    Default: 0

    IB_DELIVERYMODENumber(5,0)INTEGER NOT NULLDelivery Mode
    ONSNDHDLRNAMECharacter(30)VARCHAR2(30) NOT NULLOnSend Handler

    Prompt Table: PSSRVHDLRSND_VW

    ONRCVHDLRNAMECharacter(30)VARCHAR2(30) NOT NULLOnReceive Handler

    Prompt Table: PSSRVHDLRRCV_VW

    ONPREHDLRNAMECharacter(30)VARCHAR2(30) NOT NULLOnPreNotify Handler

    Prompt Table: PSSRVHDLRPRN_VW

    ONPOSTHDLRNAMECharacter(30)VARCHAR2(30) NOT NULLOnPostNotify Handler

    Prompt Table: PSSRVHDLRPTN_VW

    GENERATEDCharacter(1)VARCHAR2(1) NOT NULLSystem Generated

    Y/N Table Edit

    Default: N

    IB_ARR_SECURE_EPCharacter(1)VARCHAR2(1) NOT NULLARR Secure EndPoint
    IB_LOCALIDFLGNumber(1,0)SMALLINT NOT NULLLocal Node Validation Flag
    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.
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    DESCRLONGLong CharacterCLOBLong Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19