PSPMTRANS35_VW

index back

SELECT PMT.PM_INSTANCE_ID ,PMT.PM_PROCESS_ID ,PMT.PM_AGENT_STRT_DTTM ,PMT.PM_MON_STRT_DTTM ,PMT.PM_TRANS_DURATION ,PMT.PM_PARENT_INST_ID ,PMT.PM_TOP_INST_ID ,AGNT.PM_AGENT_TYPE ,AGNT.PM_DOMAIN_NAME ,AGNT.PM_HOST_PORT ,SYSD.DBNAME ,SYSV.TOOLSREL ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE1 ,1 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE1 ,31 ,60) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE1 ,91 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE1 ,121 ,30) ,' ') ,PMT.PM_METRIC_VALUE2 ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE2 ,1 ,100) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE2 ,101 ,100) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE2 ,201 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE3 ,1 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE3 ,31 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE3 ,61 ,30) ,' ') ,%Coalesce(%TrimSubstr(PMT.PM_CONTEXT_VALUE3 ,91 ,30) ,' ') ,PM_METRIC_VALUE1 FROM PSPMTRANSHIST PMT , PSPMAGENT AGNT , PSPMSYSDEFN SYSD , PSPMSYSVERSION SYSV WHERE PMT.PM_TRANS_DEFN_SET = 1 AND PMT.PM_TRANS_DEFN_ID=440 AND PMT.PM_AGENTID = AGNT.PM_AGENTID AND AGNT.PM_SYSTEMID = SYSD.PM_SYSTEMID AND AGNT.PM_SYSTEMID = SYSV.PM_SYSTEMID

PeopleSoft Field Name Field Type Column Type Description
PM_INSTANCE_ID Number(20,0) DECIMAL(20) NOT NULL Instance Identifier
PM_PROCESS_ID Number(8,0) INTEGER NOT NULL Process ID
PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time
PM_MON_STRT_DTTM DateTime(26) TIMESTAMP Monitor Received Date/Time
PM_TRANS_DURATION Number(22,3) DECIMAL(21,3) NOT NULL Duration (ms)
PM_PARENT_INST_ID Number(20,0) DECIMAL(20) NOT NULL Parent Instance Identifier
PM_TOP_INST_ID Number(20,0) DECIMAL(20) NOT NULL Top Instance Identifier
PM_AGENT_TYPE Character(32) VARCHAR2(32) NOT NULL Performance Monitor Agent Name.
PM_DOMAIN_NAME Character(32) VARCHAR2(32) NOT NULL Performance Monitor Agent Name.
PM_HOST_PORT Character(64) VARCHAR2(64) NOT NULL Performance Monitor host name.
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
TOOLSREL Character(20) VARCHAR2(20) NOT NULL Tools Release Number
PTUSERNAME Character(30) VARCHAR2(30) NOT NULL User Name
PTBUSTRANSACTION Character(60) VARCHAR2(60) NOT NULL Business Transaction
PTTST_NAME Character(30) VARCHAR2(30) NOT NULL Test Name (see PSPTTSTDEFN).
PTTST_CASE_NAME Character(30) VARCHAR2(30) NOT NULL Test Case Name
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
OBJECTVALUE1 Character(100) VARCHAR2(100) NOT NULL Object Value 1
OBJECTVALUE2 Character(100) VARCHAR2(100) NOT NULL Object Value 2
OBJECTVALUE3 Character(30) VARCHAR2(30) NOT NULL Object Value 3
OBJECTVALUE4 Character(30) VARCHAR2(30) NOT NULL Object Value 4
OBJECTVALUE5 Character(30) VARCHAR2(30) NOT NULL Object Value 5
OBJECTVALUE6 Character(30) VARCHAR2(30) NOT NULL Object Value 6
OBJECTVALUE7 Character(30) VARCHAR2(30) NOT NULL Object Value 7
ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19