PSRELATIONSHIP

(SQL Table)
 Index Back

Integr Broker Relationship

Integration Broker Relationship Definition

  • Related Language Record: PSRELATIONLANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID
    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.
    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