PSRELTGTTYPVW

(SQL View)
Index Back

SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.TRXTYPE FROM PSRELATIONSHIP A , PSNODETRX B WHERE A.NODE1 = B.MSGNODENAME OR A.NODE2 = B.MSGNODENAME

# 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 TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID
3 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous