PSNODETRXVW2(SQL View) |
Index Back |
|---|---|
Node/Trans Self Service ViewIntegration Broker Node/Transaction Self Service View |
| SELECT A.MSGNODENAME , A.EFFDT , A.TRXTYPE , A.RQSTMSGNAME , A.RQSTMSGVER , A.EXTRQSTMSGNAME , A.RESPMSGNAME , A.RESPMSGVER , A.EXTRESPMSGNAME , A.ROUTINGTYPE , A.CONNID , A.CONNGATEWAYID , A.CONNOVERRIDE , A.EFF_STATUS , A.LASTUPDDTTM , A.LASTUPDOPRID , A.COMMENTS FROM PSNODETRX A WHERE A.EFFDT=( SELECT MAX(B.EFFDT) FROM PSNODETRX B WHERE B.MSGNODENAME=A.MSGNODENAME AND B.TRXTYPE=A.TRXTYPE AND B.RQSTMSGNAME=A.RQSTMSGNAME AND B.RQSTMSGVER=A.RQSTMSGVER AND B.EFF_STATUS='A' AND B.EFFDT<=%CurrentDateIn) |
| # | 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 |
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 |
| 4 | RQSTMSGNAME |
Character(30) | VARCHAR2(30) NOT NULL |
Integration Server Request Message Name
Prompt Table: PSMSGDEFN |
| 5 | RQSTMSGVER |
Character(30) | VARCHAR2(30) NOT NULL |
Integration Broker Request Message Version
Prompt Table: PSRQSTMSGVERVW |
| 6 | EXTRQSTMSGNAME | Character(254) | VARCHAR2(254) NOT NULL | Integration Server External Request Message Name |
| 7 | RESPMSGNAME | Character(30) | VARCHAR2(30) NOT NULL |
Integration Server Response Message Name
Prompt Table: PSMSGDEFN |
| 8 | RESPMSGVER | Character(30) | VARCHAR2(30) NOT NULL |
Integration Server Response Message Version
Prompt Table: PSRESPMSGVERVW |
| 9 | EXTRESPMSGNAME | Character(254) | VARCHAR2(254) NOT NULL | Integration Server External Response Message Name |
| 10 | ROUTINGTYPE | Character(1) | VARCHAR2(1) NOT NULL |
Routing Type
E=Explicit I=Implicit |
| 11 | CONNID | Character(30) | VARCHAR2(30) NOT NULL |
Integration Server Connector ID
Prompt Table: PSCONNIDVW |
| 12 | CONNGATEWAYID | Character(30) | VARCHAR2(30) NOT NULL |
Integration Broker Connector Gateway ID
URL alias to accomodate 30 char managed object key limit
Default Value: LOCAL Prompt Table: PSCONNGATEWAYVW |
| 13 | CONNOVERRIDE | Character(1) | VARCHAR2(1) NOT NULL |
Override Connector
Y/N Table Edit Default Value: N |
| 14 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 15 | 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. |
| 16 | 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. |
| 17 | COMMENTS | Long Character | CLOB | Comment |