IB_UPG_TRANSX

index back

Node Transactions for upgrade

Used for IB Upgrade to store transactions that will be migrated to service operations.

PeopleSoft Field Name Field Type Column Type Description
MSGNODENAME Character(30) VARCHAR2(30) NOT NULL Application Message Node Name. Name of the Application Message Node Definition. (see PSMSGNODEDEFN).

Prompt Table: PSMSGNODEDEFN

EFFDT Date(10) DATE NOT NULL Effective Date

Default: %date

TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous

Default: IA

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

Prompt Table: PSMSGDEFNVW1

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

Prompt Table: PSRQSTMSGVERVW

NODE_TYPE Character(4) VARCHAR2(4) NOT NULL Node Type
EX=External
ICT=Pre-PeopleTools 8.4
PIA=PeopleSoft
EXTRQSTMSGNAME Character(254) VARCHAR2(254) NOT NULL Integration Server External Request Message Name
RESPMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Response Message Name

Prompt Table: PSMSGDEFNVW1

RESPMSGVER Character(30) VARCHAR2(30) NOT NULL Integration Server Response Message Version

Prompt Table: PSRESPMSGVERVW

EXTRESPMSGNAME Character(254) VARCHAR2(254) NOT NULL Integration Server External Response Message Name
LOGMSGDTLFLG Number(1,0) SMALLINT NOT NULL Log Message Detail?
ROUTINGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
E=Explicit
I=Implicit
CONNOVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Connector

Y/N Table Edit

Default: N

CONNGATEWAYID Character(30) VARCHAR2(30) NOT NULL Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit

Prompt Table: PSGATEWAY

CONNID Character(30) VARCHAR2(30) NOT NULL Integration Server Connector ID

Prompt Table: PSCONNIDVW

EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19