PSIBWNODETRXVW

index back

Node Transaction Definition

Integration Server Business Entity Transaction Definition
SELECT MSGNODENAME ,EFFDT ,TRXTYPE ,RQSTMSGNAME ,RQSTMSGVER ,VERSION ,EXTRQSTMSGNAME ,RESPMSGNAME , RESPMSGVER ,EXTRESPMSGNAME ,ROUTINGTYPE ,CONNOVERRIDE ,CONNGATEWAYID ,CONNID ,LOGMSGDTLFLG , EFF_STATUS ,LASTUPDDTTM ,LASTUPDOPRID ,COMMENTS FROM PSNODETRX

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

VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
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
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

LOGMSGDTLFLG Number(1,0) SMALLINT NOT NULL Log Message Detail?

Default: 2

EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
COMMENTS Long Character CLOB Comment
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19