PSRELATIONPROP

(SQL Table)
 Index Back

Relationship Properties

Integration Broker Relationship Specific Properties

  • Related Language Record: PSRELPROPLANG

    • # 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 MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

    Default Value: PSRELATIONWRK.MSGNODENAME

    3 NAMETYPE Character(1) VARCHAR2(1) NOT NULL Property Name Type
    C=Category
    I=Identification
    S=Search

    Default Value: C

    4 PROPNAME Character(30) VARCHAR2(30) NOT NULL Property Name

    Prompt Table: PSNODPROPNAMEVW

    5 PROPVALUE Character(254) VARCHAR2(254) NOT NULL Value
    6 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.
    7 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.
    8 COMMENTS Long Character CLOB Comment