IB_UPG_RELAT_VW

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
1 SRCNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

2 IB_SRCDEFNODE Character(1) VARCHAR2(1) NOT NULL Default Local Node
3 PTIB_SRC_NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=ICType=format
PIA=PeopleSoft
4 SRCTRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELSRCTYPVW

5 SRCRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

6 SRCRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Source Request Message Version

Prompt Table: PSSRCMSGVERVW

7 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

8 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
9 TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

10 IB_TGTDEFNODE Character(1) VARCHAR2(1) NOT NULL Default Local Node
11 PTIB_TGT_NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=ICType=format
PIA=PeopleSoft
12 TGTRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELTGTTRXVW

13 TGTRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Target Request Message Version

Prompt Table: PSTGTMSGVERVW

14 TGTTRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Server Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Prompt Table: PSRELTGTTYPVW

15 ASYNCREPLYMSG Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name

Prompt Table: PSRELSRCTRXVW

16 ASYNCREPLYVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Asynchronous Reply Message Version

Prompt Table: ASYNCREPLYVERVW

17 RQSTTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

18 RESPTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID

Prompt Table: PSRELTRNSFRMVW

19 RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
20 NODE1 Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition.
21 NODE2 Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID