IB_RELATION_AET

index back

Relationship table for upgrade

Used for IB upgrade for relationship migration.

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
SRCNODE Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID

Prompt Table: PSRELATNODEVW

IB_SRCDEFNODE Character(1) VARCHAR2(1) NOT NULL Default Local Node
PTIB_SRC_NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=ICType=format
PIA=PeopleSoft
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

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

Prompt Table: PSRELSRCTRXVW

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

Prompt Table: PSSRCMSGVERVW

EFFDT Date(10) DATE Effective Date

Default: %date

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

Prompt Table: PSRELATNODEVW

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

Prompt Table: PSRELTGTTRXVW

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

Prompt Table: PSTGTMSGVERVW

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

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

Prompt Table: PSRELSRCTRXVW

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

Prompt Table: ASYNCREPLYVERVW

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

Prompt Table: PSRELTRNSFRMVW

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

Prompt Table: PSRELTRNSFRMVW

RELATIONSHIPID Character(30) VARCHAR2(30) NOT NULL Integration Broker Relationship ID (see PSRELATIONSHIP).
NODE1 Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition.
NODE2 Character(30) VARCHAR2(30) NOT NULL Integration Server Business Entity ID
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19