PSNODETRX_CVW |
index back |
|---|---|
Node 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 | 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: PSMSGDEFNVW |
| 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: PSMSGDEFNVW |
| 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 Default: PSMSGNODEDEFN.ROUTINGTYPE |
| 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: 0 |
| EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default: A |
| 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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |