PSNODETRX_CVW

(SQL View)
 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 A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PSNODETRX B WHERE A.MSGNODENAME=B.MSGNODENAME AND A.TRXTYPE=B.TRXTYPE AND A.RQSTMSGNAME=B.RQSTMSGNAME AND A.RQSTMSGVER=B.RQSTMSGVER AND B.EFFDT<=%CurrentDateIn AND B.EFF_STATUS = 'A' )

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

Prompt Table: PSMSGNODEDEFN

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

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

Default Value: IA

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

Prompt Table: PSMSGDEFNVW

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

Prompt Table: PSRQSTMSGVERVW

6 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
7 EXTRQSTMSGNAME Character(254) VARCHAR2(254) NOT NULL Integration Server External Request Message Name
8 RESPMSGNAME Character(30) VARCHAR2(30) NOT NULL Integration Server Response Message Name

Prompt Table: PSMSGDEFNVW

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

Prompt Table: PSRESPMSGVERVW

10 EXTRESPMSGNAME Character(254) VARCHAR2(254) NOT NULL Integration Server External Response Message Name
11 ROUTINGTYPE Character(1) VARCHAR2(1) NOT NULL Routing Type
E=Explicit
I=Implicit

Default Value: PSMSGNODEDEFN.ROUTINGTYPE

12 CONNOVERRIDE Character(1) VARCHAR2(1) NOT NULL Override Connector

Y/N Table Edit

Default Value: N

13 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

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

Prompt Table: PSCONNIDVW

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

Default Value: 0

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

Default Value: A

17 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.
18 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.
19 COMMENTS Long Character CLOB Comment