PSRELSRCTYPVW

(SQL View)
 Index Back

SELECT DISTINCT A.RELATIONSHIPID , B.MSGNODENAME , B.RQSTMSGNAME , B.RQSTMSGVER , 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 SRCNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID
3 SRCRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name
4 SRCRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Source Request Message Version
5 TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous