PSAPMSGPC_VW

index back

SELECT P.IBTRANSACTIONID , P.IB_SEGMENTINDEX , P.SUBNODE , P.IBPUBTRANSACTID , P.PUBNODE , P.IB_OPERATIONNAME , P.QUEUENAME , P.LASTUPDDTTM , H.CREATEDTTM FROM PSAPMSGPUBCON P , PSAPMSGPUBHDR H WHERE P.IBPUBTRANSACTID = H.IBTRANSACTIONID

PeopleSoft Field Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
IB_SEGMENTINDEX Number(4,0) SMALLINT NOT NULL IB Segment Index
SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
IBPUBTRANSACTID Character(36) VARCHAR2(36) NOT NULL Orig Transaction ID
PUBNODE Character(30) VARCHAR2(30) NOT NULL Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from.
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
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.
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19