AE_UPGCONV_VW (SQL View)	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.

AE_UPGCONV_VW

(SQL View)

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 PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance