PSPMTRANS21_VW(SQL View) |
Index Back |
---|---|
PeopleCode summary trans.Performance monitor view of completed transactions of type PeopleCode summary. |
SELECT C.PM_INSTANCE_ID , C.PM_TRANS_DEFN_SET , C.PM_TRANS_DEFN_ID , C.PM_AGENTID , C.OPRID , C.PM_PERF_TRACE , C.PM_CONTEXT_VALUE1 , C.PM_CONTEXT_VALUE2 , C.PM_CONTEXT_VALUE3 , C.PM_AGENT_STRT_DTTM , C.PM_MON_STRT_DTTM , C.PM_TRANS_DURATION , C.PM_PARENT_INST_ID , C.PM_TOP_INST_ID , C.PM_METRIC_VALUE1 , C.PM_METRIC_VALUE2 , C.PM_METRIC_VALUE3 , C.PM_METRIC_VALUE4 , C.PM_METRIC_VALUE5 , C.PM_METRIC_VALUE6 , C.PM_METRIC_VALUE7 , ' ' , ' ' , ' ' , 0 , 0 , 0 , C.PM_ADDTNL_DESCR FROM PSPMTRANSHIST C WHERE C.PM_TRANS_DEFN_SET = 1 AND C.PM_TRANS_DEFN_ID = 404 |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PM_INSTANCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
2 | PM_TRANS_DEFN_SET | Number(5,0) | INTEGER NOT NULL | Performance monitor transaction definition set number. |
3 | PM_TRANS_DEFN_ID | Number(5,0) | INTEGER NOT NULL | Performance Monitor Transaction Definition Identifier. |
4 | PM_AGENTID | Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
5 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
6 | PM_PERF_TRACE | Character(128) | VARCHAR2(128) NOT NULL | Performance Trace Name |
7 | PM_CONTEXT_VALUE1 | Character(254) | VARCHAR2(254) NOT NULL | Context 1 |
8 | PM_CONTEXT_VALUE2 | Character(254) | VARCHAR2(254) NOT NULL | Context 2 |
9 | PM_CONTEXT_VALUE3 | Character(254) | VARCHAR2(254) NOT NULL | Context 3 |
10 | PM_AGENT_STRT_DTTM | DateTime(26) | TIMESTAMP | Agent Start Date/Time |
11 | PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |
12 | PM_TRANS_DURATION | Number(22,3) | DECIMAL(21,3) NOT NULL | Duration (ms) |
13 | PM_PARENT_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Parent Instance Identifier |
14 | PM_TOP_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Top Instance Identifier |
15 | PM_METRIC_VALUE1 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 1 |
16 | PM_METRIC_VALUE2 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 2 |
17 | PM_METRIC_VALUE3 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 3 |
18 | PM_METRIC_VALUE4 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 4 |
19 | PM_METRIC_VALUE5 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 5 |
20 | PM_METRIC_VALUE6 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 6 |
21 | PM_METRIC_VALUE7 | Character(128) | VARCHAR2(128) NOT NULL | Metric Value 7 |
22 | PM_CHART_XAXIS | Character(100) | VARCHAR2(100) NOT NULL | Chart X-Axis Text |
23 | PM_CHART_SERIES | Character(30) | VARCHAR2(30) NOT NULL | Data Series |
24 | PM_CHART_HINTS | Character(128) | VARCHAR2(128) NOT NULL | Data Hints |
25 | PM_CHART_COLOR | Number(3,0) | SMALLINT NOT NULL | Chart Color |
26 | PM_CHART_YAXIS | Number(13,2) | DECIMAL(12,2) NOT NULL | Chart Y-Axis Values |
27 | PM_CHART_POS | Number(3,0) | SMALLINT NOT NULL | Chart position |
28 | PM_ADDTNL_DESCR | Long Character | CLOB | Additional Description |