Co-Operative PeopleTools Table Reference

PSNODETRXVW2	Return to Index

Integration Broker Node/Transaction Self Service View

Platform View Text
Default 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)

Platform	View Text
Default	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 Description
MSGNODENAME Application Message Node Name. Name of the Application Message Node Definition.
Prompt Table: PSMSGNODEDEFN
EFFDT Effective Date
Default: %date
TRXTYPE Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
RQSTMSGNAME Integration Server Request Message Name
Prompt Table: PSMSGDEFN
RQSTMSGVER Integration Broker Request Message Version
Prompt Table: PSRQSTMSGVERVW
EXTRQSTMSGNAME Integration Server External Request Message Name
RESPMSGNAME Integration Server Response Message Name
Prompt Table: PSMSGDEFN
RESPMSGVER Integration Server Response Message Version
Prompt Table: PSRESPMSGVERVW
EXTRESPMSGNAME Integration Server External Response Message Name
ROUTINGTYPE Routing Type
E=Explicit
I=Implicit
CONNID Integration Server Connector ID
Prompt Table: PSCONNIDVW
CONNGATEWAYID Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit
Default: LOCAL
Prompt Table: PSCONNGATEWAYVW
CONNOVERRIDE Override Connector
Y/N Table Edit
Default: N
EFF_STATUS Effective Status
A=Active
I=Inactive
LASTUPDDTTM 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 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 Comment
Author: PeopleTools
Return to Index © Go-Faster Consultancy Ltd. Last updated 24 July 2010

PeopleSoft Field Name	Description
MSGNODENAME	Application Message Node Name. Name of the Application Message Node Definition. Prompt Table: PSMSGNODEDEFN
EFFDT	Effective Date Default: %date
TRXTYPE	Integration Broker Transaction Type IA=Inbound Asynchronous IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous
RQSTMSGNAME	Integration Server Request Message Name Prompt Table: PSMSGDEFN
RQSTMSGVER	Integration Broker Request Message Version Prompt Table: PSRQSTMSGVERVW
EXTRQSTMSGNAME	Integration Server External Request Message Name
RESPMSGNAME	Integration Server Response Message Name Prompt Table: PSMSGDEFN
RESPMSGVER	Integration Server Response Message Version Prompt Table: PSRESPMSGVERVW
EXTRESPMSGNAME	Integration Server External Response Message Name
ROUTINGTYPE	Routing Type E=Explicit I=Implicit
CONNID	Integration Server Connector ID Prompt Table: PSCONNIDVW
CONNGATEWAYID	Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit Default: LOCAL Prompt Table: PSCONNGATEWAYVW
CONNOVERRIDE	Override Connector Y/N Table Edit Default: N
EFF_STATUS	Effective Status A=Active I=Inactive
LASTUPDDTTM	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	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	Comment

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd. Last updated 24 July 2010

PSNODETRXVW2