PMN_MSGLOG_VW

index back

Process Monitor Message Logs

This view is used to list message logs for COBOL and Application Engine processes.
SELECT A.PROCESS_INSTANCE , A.MESSAGE_SEQ , A.MESSAGE_SET_NBR , A.MESSAGE_NBR , A.MESSAGE_SEVERITY , A.DTTM_STAMP_SEC , %TimePart(A.DTTM_STAMP_SEC) FROM PS_MESSAGE_LOG A

PeopleSoft Field Name Field Type Column Type Description
PROCESSINSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
MESSAGE_SEQ Number(9,0) DECIMAL(9) NOT NULL Message Sequence
MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
MESSAGE_SEVERITY Number(5,0) INTEGER NOT NULL Message Severity
MSGLOG_DTTM DateTime(26) TIMESTAMP Log Date & Time
MSGLOG_TIME Time(15) TIMESTAMP Message Log Time
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19