PSPTTSTLOGLSTVW

index back

PTF Log List

The Log Header, plus the number of lines
SELECT H.PTTST_NAME , H.PTTST_LOG_ID , H.PTTST_LOG_FOLDER , H.PTTST_LOG_CAPTION , H.PTTST_LOG_RESULT , H.LASTUPDDTTM , H.PTTST_LOG_DELETED , H.PTTST_CASE_NAME , H.OPRID , H.MACHINENAME , H.PTTST_PREFIX , L.PTTST_LOG_LINE_ID FROM PSPTTSTLOG_LIST H , ( SELECT PTTST_NAME ,PTTST_LOG_ID , MAX(PTTST_LOG_LINE_ID) AS PTTST_LOG_LINE_ID FROM PSPTTSTLOG_LNS GROUP BY PTTST_NAME ,PTTST_LOG_ID) L WHERE H.PTTST_NAME = L.PTTST_NAME AND H.PTTST_LOG_ID = L.PTTST_LOG_ID

PeopleSoft Field Name Field Type Column Type Description
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_LOG_ID Number(8,0) INTEGER NOT NULL Script Log ID
PTTST_LOG_FOLDER Character(40) VARCHAR2(40) NOT NULL Log Folder
PTTST_LOG_CAPTION Character(200) VARCHAR2(200) NOT NULL Test Log Caption
PTTST_LOG_RESULT Number(3,0) SMALLINT NOT NULL Scr Final Result
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.
PTTST_LOG_DELETED Character(1) VARCHAR2(1) NOT NULL Test Log Deleted
PTTST_CASE_NAME Character(30) VARCHAR2(30) NOT NULL Test Case Name
OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
PTTST_PREFIX Character(5) VARCHAR2(5) NOT NULL Scr Prefix
PTTST_LOG_LINE_ID Number(8,0) INTEGER NOT NULL Log Line
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19