AE_UPGCONV_VW

index back

Filter view for Msg Log pnl.

Used by the AE_UPGCONV_WRK record. The SQL in this view is utilized by the AE_UPGCONV_WRK.PROCESS_INSTANCE field on the UPGCONV_MSG_LOG panel. It is used to read from the MESSAGE_PARM table, but select on those messages that pertain the upgrade conversion driver program - UPGCONVDRVR. Thus, the PI where the MESSAGE_SET = 1018. At a minimum, message set 1018 will be written to the message_log table for the PI since it is the "START TIME" message for each program driven by the driver.
SELECT DISTINCT(PROCESS_INSTANCE) FROM PS_MESSAGE_LOG WHERE MESSAGE_NBR = 1018

PeopleSoft Field Name Field Type Column Type Description
PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19