IB_RELATION_TMP (SQL Table)	Index Back
Relationship table for upgrade Used for IB upgrade for relationship migration.

IB_RELATION_TMP

(SQL Table)

Relationship table for upgrade

Used for IB upgrade for relationship migration.

# 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
Prompt Table: PSRELATNODEVW

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 TGTNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID
Prompt Table: PSRELATNODEVW

8 PTIB_TGT_NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=ICType=format
PIA=PeopleSoft

9 TGTRQSTMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name
Prompt Table: PSRELTGTTRXVW

10 TGTRQSTMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Target Request Message Version
Prompt Table: PSTGTMSGVERVW

11 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

12 ASYNCREPLYMSG Character(30) VARCHAR2(30) NOT NULL Integration Server Request Message Name
Prompt Table: PSRELSRCTRXVW

13 ASYNCREPLYVER Character(30) VARCHAR2(30) NOT NULL Integration Broker Asynchronous Reply Message Version
Prompt Table: ASYNCREPLYVERVW

14 RQSTTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID
Prompt Table: PSRELTRNSFRMVW

15 RESPTRNSFRMNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Transformation ID
Prompt Table: PSRELTRNSFRMVW

16 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

#	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 Prompt Table: PSRELATNODEVW
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	TGTNODE	Character(30)	VARCHAR2(30) NOT NULL	Integration Server Business Entity ID Prompt Table: PSRELATNODEVW
8	PTIB_TGT_NODE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Node Type EX=External ICT=ICType=format PIA=PeopleSoft
9	TGTRQSTMSGNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Server Request Message Name Prompt Table: PSRELTGTTRXVW
10	TGTRQSTMSGVER	Character(30)	VARCHAR2(30) NOT NULL	Integration Broker Target Request Message Version Prompt Table: PSTGTMSGVERVW
11	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
12	ASYNCREPLYMSG	Character(30)	VARCHAR2(30) NOT NULL	Integration Server Request Message Name Prompt Table: PSRELSRCTRXVW
13	ASYNCREPLYVER	Character(30)	VARCHAR2(30) NOT NULL	Integration Broker Asynchronous Reply Message Version Prompt Table: ASYNCREPLYVERVW
14	RQSTTRNSFRMNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Server Transformation ID Prompt Table: PSRELTRNSFRMVW
15	RESPTRNSFRMNAME	Character(30)	VARCHAR2(30) NOT NULL	Integration Server Transformation ID Prompt Table: PSRELTRNSFRMVW
16	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive