PSRELTGTTYPVW

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 NameField TypeColumn TypeDescription
RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
TGTNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID
TRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19