PSPMTRANSHIST

Return to Index

Performance monitor PMU history table. Stores all PMUs received by the monitoring system.

PeopleSoft Field NameField TypeDescription
PM_INSTANCE_IDDECIMAL(20) NOT NULLInstance Identifier
PM_TRANS_DEFN_SETINTEGER NOT NULLPerformance monitor transaction definition set number.
PM_TRANS_DEFN_IDINTEGER NOT NULLPerformance Monitor Transaction Definition Identifier.
PM_AGENTIDDECIMAL(10) NOT NULLPerformance Monitor Agent Identifier.
PM_TRANS_STATUSVARCHAR2(1) NOT NULLPMU Status
1=Success
2=Abort
3=Failed
4=Unknown
5=Admin Timeout
6=Timeout
7=Reaper Timeout
OPRIDVARCHAR2(30) NOT NULLA user's ID
PM_PERF_TRACEVARCHAR2(30) NOT NULLPerformance Trace Name
PM_CONTEXT_VALUE1VARCHAR2(254) NOT NULLContext 1
PM_CONTEXT_VALUE2VARCHAR2(254) NOT NULLContext 2
PM_CONTEXT_VALUE3VARCHAR2(254) NOT NULLContext 3
PM_CONTEXTID_1INTEGER NOT NULLContext Identifier 1
PM_CONTEXTID_2INTEGER NOT NULLContext Identifier 2
PM_CONTEXTID_3INTEGER NOT NULLContext Identifier 3
PM_PROCESS_IDINTEGER NOT NULLProcess ID
PM_AGENT_STRT_DTTMDATEAgent Start Date/Time
PM_MON_STRT_DTTMDATEMonitor Received Date/Time
PM_TRANS_DURATIONDECIMAL(21,3) NOT NULLDuration (ms)
PM_PARENT_INST_IDDECIMAL(20) NOT NULLParent Instance Identifier
PM_TOP_INST_IDDECIMAL(20) NOT NULLTop Instance Identifier
PM_METRIC_VALUE1DECIMAL(28,4) NOT NULLMetric Value 1
PM_METRIC_VALUE2DECIMAL(28,4) NOT NULLMetric Value 2
PM_METRIC_VALUE3DECIMAL(28,4) NOT NULLMetric Value 3
PM_METRIC_VALUE4DECIMAL(28,4) NOT NULLMetric Value 4
PM_METRIC_VALUE5DECIMAL(28,4) NOT NULLMetric Value 5
PM_METRIC_VALUE6DECIMAL(28,4) NOT NULLMetric Value 6
PM_METRIC_VALUE7VARCHAR2(128) NOT NULLMetric Value 7
PM_ADDTNL_DESCRLONG VARCHARAdditional Description

Author: PeopleTools 8.52

Return to Index

© David Kurtz  Last updated 01 August 2015