PSIBWRELAVW

 index back

Integr Broker Relationship

Integration Broker Relationship Definition
SELECT RELATIONSHIPID ,VERSION ,NODE1 ,NODE2 ,RELATIONSTATUS ,DESCR ,START_DATE ,END_DATE ,LASTUPDDTTM ,LASTUPDOPRID ,COMMENTS FROM PSRELATIONSHIP

  • Related language record: PSIBWRELA_LVW

    • PeopleSoft Field Name Field Type Column Type Description
    RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    NODE1 Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition.

    Prompt Table: PSNODEDEFNVW

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

    Prompt Table: PSNODEDEFNVW

    RELATIONSTATUS Character(1) VARCHAR2(1) NOT NULL Integration Broker Relationship Status
    A=Active
    I=Inactive

    Default: A

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    START_DATE Date(10) DATE Start Date for Gen Standing PO
    END_DATE Date(10) DATE End Date
    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.

    Default: %Datetime

    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.
    COMMENTS Long Character CLOB Comment
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20