IB_NOD_TRX_VW

Platform

View Text

Default

SELECT A.MSGNODENAME , A.EFFDT , A.TRXTYPE , A.RQSTMSGNAME , A.RQSTMSGVER , C.NODE_TYPE , A.EXTRQSTMSGNAME , A.RESPMSGNAME , A.RESPMSGVER , A.LOGMSGDTLFLG , A.EXTRESPMSGNAME , A.ROUTINGTYPE , A.CONNOVERRIDE , A.CONNGATEWAYID , A.CONNID , A.EFF_STATUS FROM PSNODETRX A , PSMSGNODEDEFN C WHERE A.EFFDT = ( SELECT MAX (B.EFFDT) FROM PSNODETRX B WHERE B.EFFDT <= %CurrentDateIn AND A.MSGNODENAME = B.MSGNODENAME AND A.TRXTYPE = B.TRXTYPE AND A.RQSTMSGVER = B.RQSTMSGVER AND A.RQSTMSGNAME = B.RQSTMSGNAME) AND A.MSGNODENAME = C.MSGNODENAME

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 (default) IS=Inbound Synchronous OA=Outbound Asynchronous OS=Outbound Synchronous
RQSTMSGNAME	Integration Server Request Message Name Prompt Table: PSMSGDEFNVW1
RQSTMSGVER	Integration Broker Request Message Version Prompt Table: PSRQSTMSGVERVW
NODE_TYPE	Node Type EX=External ICT=ICType=format PIA=PeopleSoft
EXTRQSTMSGNAME	Integration Server External Request Message Name
RESPMSGNAME	Integration Server Response Message Name Prompt Table: PSMSGDEFNVW1
RESPMSGVER	Integration Server Response Message Version Prompt Table: PSRESPMSGVERVW
LOGMSGDTLFLG	Log Message Detail?
EXTRESPMSGNAME	Integration Server External Response Message Name
ROUTINGTYPE	Routing Type E=Explicit I=Implicit
CONNOVERRIDE	Override Connector Y/N Table Edit Default: N
CONNGATEWAYID	Integration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit Prompt Table: PSGATEWAY
CONNID	Integration Server Connector ID Prompt Table: PSCONNIDVW
EFF_STATUS	Effective Status A=Active I=Inactive

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