IB_UPG_RELAT_VW

index back

View of current relationships

View of current relationships used by the IB upgrade.
SELECT A.SRCNODE , D.LOCALDEFAULTFLG AS SRCDEFNODE , D.NODE_TYPE AS PTIB_SRC_NODE_TYPE , A.SRCTRXTYPE , A.SRCRQSTMSGNAME , A.SRCRQSTMSGVER , A.EFFDT , A.EFF_STATUS , A.TGTNODE , E.LOCALDEFAULTFLG AS TGTDEFNODE , E.NODE_TYPE AS PTIB_TGT_NODE_TYPE , A.TGTRQSTMSGNAME , A.TGTRQSTMSGVER , A.TGTTRXTYPE , A.ASYNCREPLYMSG , A.ASYNCREPLYVER , A.RQSTTRNSFRMNAME , A.RESPTRNSFRMNAME , A.RELATIONSHIPID , B.NODE1 , B.NODE2 FROM PSRELATIONTRX A , PSRELATIONSHIP B , PSMSGNODEDEFN D , PSMSGNODEDEFN E WHERE A.RELATIONSHIPID = B.RELATIONSHIPID AND D.MSGNODENAME = A.SRCNODE AND E.MSGNODENAME = A.TGTNODE AND A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PSRELATIONTRX C WHERE C.EFFDT <= %CurrentDateIn AND A.SRCNODE = C.SRCNODE AND A.SRCTRXTYPE = C.SRCTRXTYPE AND A.SRCRQSTMSGNAME = C.SRCRQSTMSGNAME AND A.SRCRQSTMSGVER = C.SRCRQSTMSGVER AND A.TGTNODE = C.TGTNODE AND A.TGTTRXTYPE = C.TGTTRXTYPE AND A.TGTRQSTMSGNAME = C.TGTRQSTMSGNAME AND A.TGTRQSTMSGVER = C.TGTRQSTMSGVER AND A.RELATIONSHIPID = C.RELATIONSHIPID)

PeopleSoft Field NameField TypeColumn TypeDescription
SRCNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID

Prompt Table: PSRELATNODEVW

IB_SRCDEFNODECharacter(1)VARCHAR2(1) NOT NULLDefault Local Node
PTIB_SRC_NODE_TYPECharacter(4)VARCHAR2(4) NOT NULLNode Type
EX=External
ICT=ICType=format
PIA=PeopleSoft
SRCTRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELSRCTYPVW

SRCRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

SRCRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Source Request Message Version

Prompt Table: PSSRCMSGVERVW

EFFDTDate(10)DATE NOT NULLEffective Date

Default: %date

EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
A=Active
I=Inactive
TGTNODECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID

Prompt Table: PSRELATNODEVW

IB_TGTDEFNODECharacter(1)VARCHAR2(1) NOT NULLDefault Local Node
PTIB_TGT_NODE_TYPECharacter(4)VARCHAR2(4) NOT NULLNode Type
EX=External
ICT=ICType=format
PIA=PeopleSoft
TGTRQSTMSGNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELTGTTRXVW

TGTRQSTMSGVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Target Request Message Version

Prompt Table: PSTGTMSGVERVW

TGTTRXTYPECharacter(4)VARCHAR2(4) NOT NULLIntegration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELTGTTYPVW

ASYNCREPLYMSGCharacter(30)VARCHAR2(30) NOT NULLIntegration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

ASYNCREPLYVERCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Asynchronous Reply Message Version

Prompt Table: ASYNCREPLYVERVW

RQSTTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

RESPTRNSFRMNAMECharacter(30)VARCHAR2(30) NOT NULLIntegration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

RELATIONSHIPIDCharacter(30)VARCHAR2(30) NOT NULLIntegration Broker Relationship ID (see PSRELATIONSHIP).
NODE1Character(30)VARCHAR2(30) NOT NULLApplication Message Node Name. Name of the Application Message Node Definition.
NODE2Character(30)VARCHAR2(30) NOT NULLIntegration Server Business Entity ID
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19