IB_UPG_VER_VW

Return to Index

View: PS_IB_UPG_VER_VW

Used for IB Upgrade to store transactions that will be migrated to service operations.

PlatformView Text
DefaultSELECT A.MSGNODENAME , %DateOut(A.EFFDT) , A.TRXTYPE , A.RQSTMSGNAME , A.RQSTMSGVER , A.EXTRQSTMSGNAME , A.RESPMSGNAME , A.RESPMSGVER , A.EXTRESPMSGNAME , A.ROUTINGTYPE , A.CONNOVERRIDE , A.CONNGATEWAYID , A.CONNID , A.EFF_STATUS FROM PSNODETRX A , PSMSGDEFN B WHERE A.RQSTMSGNAME = B.MSGNAME AND A.RQSTMSGVER <> B.DEFAULTVER

PeopleSoft Field NameDescription
MSGNODENAMEApplication Message Node Name. Name of the Application Message Node Definition.

Prompt Table: PSMSGNODEDEFN

EFFDTEffective Date

Default: %date

TRXTYPEIntegration Broker Transaction Type
IA=Inbound Asynchronous (default)
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
RQSTMSGNAMEIntegration Server Request Message Name

Prompt Table: PSMSGDEFNVW1

RQSTMSGVERIntegration Broker Request Message Version

Prompt Table: PSRQSTMSGVERVW

EXTRQSTMSGNAMEIntegration Server External Request Message Name
RESPMSGNAMEIntegration Server Response Message Name

Prompt Table: PSMSGDEFNVW1

RESPMSGVERIntegration Server Response Message Version

Prompt Table: PSRESPMSGVERVW

EXTRESPMSGNAMEIntegration Server External Response Message Name
ROUTINGTYPERouting Type
E=Explicit
I=Implicit
CONNOVERRIDEOverride Connector

Y/N Table Edit

Default: N

CONNGATEWAYIDIntegration Broker Connector Gateway ID URL alias to accomodate 30 char managed object key limit

Prompt Table: PSGATEWAY

CONNIDIntegration Server Connector ID

Prompt Table: PSCONNIDVW

EFF_STATUSEffective Status
A=Active
I=Inactive

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010