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 NameField TypeColumn TypeDescription
PM_INSTANCE_IDNumber(20,0)DECIMAL(20) NOT NULLInstance Identifier
PM_PROCESS_IDNumber(8,0)INTEGER NOT NULLProcess ID
PM_AGENT_STRT_DTTMDateTime(26)TIMESTAMPAgent Start Date/Time
PM_MON_STRT_DTTMDateTime(26)TIMESTAMPMonitor Received Date/Time
PM_TRANS_DURATIONNumber(22,3)DECIMAL(21,3) NOT NULLDuration (ms)
PM_PARENT_INST_IDNumber(20,0)DECIMAL(20) NOT NULLParent Instance Identifier
PM_TOP_INST_IDNumber(20,0)DECIMAL(20) NOT NULLTop Instance Identifier
PM_AGENT_TYPECharacter(32)VARCHAR2(32) NOT NULLPerformance Monitor Agent Name.
PM_DOMAIN_NAMECharacter(32)VARCHAR2(32) NOT NULLPerformance Monitor Agent Name.
PM_HOST_PORTCharacter(64)VARCHAR2(64) NOT NULLPerformance Monitor host name.
DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
TOOLSRELCharacter(20)VARCHAR2(20) NOT NULLTools Release Number
PTUSERNAMECharacter(30)VARCHAR2(30) NOT NULLUser Name
PTBUSTRANSACTIONCharacter(60)VARCHAR2(60) NOT NULLBusiness Transaction
PTTST_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Name (see PSPTTSTDEFN).
PTTST_CASE_NAMECharacter(30)VARCHAR2(30) NOT NULLTest Case Name
OBJECTTYPENumber(5,0)INTEGER NOT NULLObject Type
OBJECTVALUE1Character(100)VARCHAR2(100) NOT NULLObject Value 1
OBJECTVALUE2Character(100)VARCHAR2(100) NOT NULLObject Value 2
OBJECTVALUE3Character(30)VARCHAR2(30) NOT NULLObject Value 3
OBJECTVALUE4Character(30)VARCHAR2(30) NOT NULLObject Value 4
OBJECTVALUE5Character(30)VARCHAR2(30) NOT NULLObject Value 5
OBJECTVALUE6Character(30)VARCHAR2(30) NOT NULLObject Value 6
OBJECTVALUE7Character(30)VARCHAR2(30) NOT NULLObject Value 7
ROW_COUNTNumber(8,0)INTEGER NOT NULLNumber to Purge
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19