PSIBWRELAVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
    2 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    3 NODE1 Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition.

    Prompt Table: PSNODEDEFNVW

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

    Prompt Table: PSNODEDEFNVW

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

    Default Value: A

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 START_DATE Date(10) DATE Start Date for Gen Standing PO
    8 END_DATE Date(10) DATE End date field to store an end date.
    9 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 Value: %Datetime

    10 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.
    11 COMMENTS Long Character CLOB Comment