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 NameField TypeColumn TypeDescription
PROCESSINSTANCENumber(10,0)DECIMAL(10) NOT NULLProcess Instance
MESSAGE_SEQNumber(9,0)DECIMAL(9) NOT NULLMessage Sequence
MESSAGE_SET_NBRNumber(5,0)INTEGER NOT NULLMessage Set Number. This field refers to the Message Set Number in the Message Catalog.
MESSAGE_NBRNumber(5,0)INTEGER NOT NULLMessage Number. This field refers to the Message Number in the Message Catalog.
MESSAGE_SEVERITYNumber(5,0)INTEGER NOT NULLMessage Severity
MSGLOG_DTTMDateTime(26)TIMESTAMPLog Date & Time
MSGLOG_TIMETime(15)TIMESTAMPMessage Log Time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19