PSPTTSTLOGLSTVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
1 PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
2 PTTST_LOG_ID Number(8,0) INTEGER NOT NULL Script Log ID
3 PTTST_LOG_FOLDER Character(40) VARCHAR2(40) NOT NULL Log Folder
4 PTTST_LOG_CAPTION Character(200) VARCHAR2(200) NOT NULL Test Log Caption
5 PTTST_LOG_RESULT Number(3,0) SMALLINT NOT NULL Scr Final Result
6 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.
7 PTTST_LOG_DELETED Character(1) VARCHAR2(1) NOT NULL Test Log Deleted
8 PTTST_CASE_NAME Character(30) VARCHAR2(30) NOT NULL Test Case Name
9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
10 MACHINENAME Character(30) VARCHAR2(30) NOT NULL Machine Name
11 PTTST_PREFIX Character(5) VARCHAR2(5) NOT NULL Scr Prefix
12 PTTST_LOG_LINE_ID Number(8,0) INTEGER NOT NULL Log Line