PSAPMSGARCHPH

index back

App Messaging Header Archive

This table is used to archive table PSAPMSGPUBHDR

PeopleSoft Field Name Field Type Column Type Description
IBTRANSACTIONID Character(36) VARCHAR2(36) NOT NULL Transaction ID
EXTOPERATIONNAME Character(254) VARCHAR2(254) NOT NULL External Service Name
IB_OPERATIONNAME Character(30) VARCHAR2(30) NOT NULL Service Operation (see PSOPERATION).
EXTERNALMESSAGEID Character(70) VARCHAR2(70) NOT NULL External Message 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.
QUEUENAME Character(30) VARCHAR2(30) NOT NULL Channel Name (see PSQUEUEDEFN).
QUEUESEQID Signed Number(11,0) DECIMAL(10) NOT NULL Queue Sequence ID
SUBQUEUE Character(60) VARCHAR2(60) NOT NULL Sub Queue
ORIGPUBNODE Character(30) VARCHAR2(30) NOT NULL Original Publishing Node
PUBCLASS Character(30) VARCHAR2(30) NOT NULL Class of publication
PUBLISHER Character(30) VARCHAR2(30) NOT NULL PeopleSoft Operator ID
PUBPROC Character(30) VARCHAR2(30) NOT NULL Publication Process
TRXTYPE Character(4) VARCHAR2(4) NOT NULL Integration Broker Transaction Type
IA=Inbound Asynchronous
IS=Inbound Synchronous
OA=Outbound Asynchronous
OS=Outbound Synchronous
CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
PUBLISHTIMESTAMP DateTime(26) TIMESTAMP Pub/Sub Timestamp
NRID Signed Number(11,0) DECIMAL(10) NOT NULL Non-Repudiation ID
DESTPUBNODE Character(248) VARCHAR2(248) NOT NULL Destination Publish Node
CONVERSATIONID Character(36) VARCHAR2(36) NOT NULL Conversation ID
INREPLYTOID Character(36) VARCHAR2(36) NOT NULL In Reply To ID
ISREQUEST Number(1,0) SMALLINT NOT NULL Is Request
CANONICALTRSFRMID Character(36) VARCHAR2(36) NOT NULL Canonical Transform ID
PUBSTATUS Number(2,0) SMALLINT NOT NULL Publication Status
STATUSSTRING Character(5) VARCHAR2(5) NOT NULL Status String
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.
RETRYCOUNT Number(10,0) DECIMAL(10) NOT NULL Pub/Sub Retry Count
MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
SLAVEPROCESSNAME Character(15) VARCHAR2(15) NOT NULL Slave Process Name
IB_SLAVEQUEUED Number(1,0) SMALLINT NOT NULL IB Slave Queued
TUXDOMAIN Character(30) VARCHAR2(30) NOT NULL Tuxedo Domain Name
PROCESSID Signed Number(11,0) DECIMAL(10) NOT NULL Process Identifier
PUBROUTINGTRAIL Character(248) VARCHAR2(248) NOT NULL Publication Routing Trail
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19