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 NameField TypeColumn TypeDescription
PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
PTTST_LOG_IDNumber(8,0)INTEGER NOT NULLScript Log ID
PTTST_LOG_FOLDERCharacter(40)VARCHAR2(40) NOT NULLLog Folder
PTTST_LOG_CAPTIONCharacter(200)VARCHAR2(200) NOT NULLTest Log Caption
PTTST_LOG_RESULTNumber(3,0)SMALLINT NOT NULLScr Final Result
LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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_DELETEDCharacter(1)VARCHAR2(1) NOT NULLTest Log Deleted
PTTST_CASE_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Case Name
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
MACHINENAMECharacter(30)VARCHAR2(30) NOT NULLMachine Name
PTTST_PREFIXCharacter(5)VARCHAR2(5) NOT NULLScr Prefix
PTTST_LOG_LINE_IDNumber(8,0)INTEGER NOT NULLLog Line
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19