PM_PERF_TRACEPM_INSTANCE_IDPM_TOP_INST_IDPSPMTRANS29_VW |
| Platform | View Text |
|---|---|
| Default | SELECT A.PM_PERF_TRACE ,A.PM_INSTANCE_ID ,A.PM_TOP_INST_ID ,A.PM_PARENT_INST_ID ,A.PM_TRANS_DEFN_SET ,A.PM_TRANS_DEFN_ID ,%DecDiv(A.PM_TRANS_DURATION, 1000) ,A.PM_CONTEXT_VALUE1 ,A.PM_CONTEXT_VALUE2 ,A.PM_CONTEXT_VALUE3 ,A.PM_METRIC_VALUE1 ,A.PM_METRIC_VALUE7 ,A.PM_MON_STRT_DTTM ,A.PM_AGENT_STRT_DTTM FROM PSPMTRANSHIST A WHERE A.PM_TRANS_DEFN_SET = 1 AND A.PM_TRANS_DEFN_ID = 404 AND A.PM_TOP_INST_ID = ( SELECT B.PM_TOP_INST_ID FROM PSPMTRANSHIST B WHERE A.PM_TOP_INST_ID = B.PM_TOP_INST_ID AND B.PM_TRANS_DEFN_ID = 401) |
| PeopleSoft Field Name | Description |
|---|---|
| PM_PERF_TRACE | Performance Trace Name |
| PM_INSTANCE_ID | Instance Identifier |
| PM_TOP_INST_ID | Top Instance Identifier |
| PM_PARENT_INST_ID | Parent Instance Identifier |
| PM_TRANS_DEFN_SET | Performance monitor transaction definition set number. |
| PM_TRANS_DEFN_ID | Performance Monitor Transaction Definition Identifier. |
| PM_TRANS_DURATION | Duration (ms) |
| PM_CONTEXT_VALUE1 | Context 1 |
| PM_CONTEXT_VALUE2 | Context 2 |
| PM_CONTEXT_VALUE3 | Context 3 |
| PM_METRIC_VALUE1 | Metric Value 1 |
| PM_METRIC_VALUE7 | Metric Value 7 |
| PM_MON_STRT_DTTM | Monitor Received Date/Time |
| PM_AGENT_STRT_DTTM | Agent Start Date/Time |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |