PM_INSTANCE_IDPM_INSTANCE_SEQ0=0-Start
1=1-Update
2=2-Stop
3=3-Atomic
4=4-Unknown
PSPMTRANS1_VW |
index back |
|---|---|
Current PMU view |
| SELECT C.PM_INSTANCE_ID , C.PM_INSTANCE_SEQ , C.PM_TRANS_DEFN_SET , C.PM_TRANS_DEFN_ID , C.PM_AGENTID , C.OPRID , C.PM_PERF_TRACE , C.PM_ACTION , C.PM_TRANS_DELETED , C.PM_CONTEXT_VALUE1 , C.PM_CONTEXT_VALUE2 , C.PM_CONTEXT_VALUE3 , C.PM_CONTEXTID_1 , C.PM_CONTEXTID_2 , C.PM_CONTEXTID_3 , C.PM_AGENT_STRT_DTTM , C.PM_AGENT_LAST_DTTM , C.PM_MON_STRT_DTTM , C.PM_MON_LAST_DTTM , C.PM_TIMEOUT_DTTM , C.PM_PARENT_INST_ID , C.PM_TOP_INST_ID , C.PM_PROCESS_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 , C.PM_ADDTNL_DESCR FROM PSPMTRANSCURR C WHERE PM_TRANS_DELETED <> 'Y' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PM_INSTANCE_ID |
Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
| PM_INSTANCE_SEQ |
Number(5,0) | INTEGER NOT NULL | Instance sequence number |
| PM_TRANS_DEFN_SET | Number(5,0) | INTEGER NOT NULL | Performance monitor transaction definition set number. |
| PM_TRANS_DEFN_ID | Number(5,0) | INTEGER NOT NULL | Performance Monitor Transaction Definition Identifier. |
| PM_AGENTID | Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
| OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| PM_PERF_TRACE | Character(128) | VARCHAR2(128) NOT NULL | Performance Trace Name |
| PM_ACTION | Character(1) | VARCHAR2(1) NOT NULL |
Action
0=0-Start 1=1-Update 2=2-Stop 3=3-Atomic 4=4-Unknown |
| PM_TRANS_DELETED | Character(1) | VARCHAR2(1) NOT NULL | PMU Deleted |
| PM_CONTEXT_VALUE1 | Character(254) | VARCHAR2(254) NOT NULL | Context 1 |
| PM_CONTEXT_VALUE2 | Character(254) | VARCHAR2(254) NOT NULL | Context 2 |
| PM_CONTEXT_VALUE3 | Character(254) | VARCHAR2(254) NOT NULL | Context 3 |
| PM_CONTEXTID_1 | Number(5,0) | INTEGER NOT NULL | Context Identifier 1 |
| PM_CONTEXTID_2 | Number(5,0) | INTEGER NOT NULL | Context Identifier 2 |
| PM_CONTEXTID_3 | Number(5,0) | INTEGER NOT NULL | Context Identifier 3 |
| PM_AGENT_STRT_DTTM | DateTime(26) | TIMESTAMP | Agent Start Date/Time |
| PM_AGENT_LAST_DTTM | DateTime(26) | TIMESTAMP | Agent Last Update Date/Time |
| PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |
| PM_MON_LAST_DTTM | DateTime(26) | TIMESTAMP | Monitor Last Update Date/Time |
| PM_TIMEOUT_DTTM | DateTime(26) | TIMESTAMP | Timeout datetime |
| 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_PROCESS_ID | Number(8,0) | INTEGER NOT NULL | Process ID |
| PM_METRIC_VALUE1 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 1 |
| PM_METRIC_VALUE2 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 2 |
| PM_METRIC_VALUE3 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 3 |
| PM_METRIC_VALUE4 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 4 |
| PM_METRIC_VALUE5 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 5 |
| PM_METRIC_VALUE6 | Signed Number(30,4) | DECIMAL(28,4) NOT NULL | Metric Value 6 |
| PM_METRIC_VALUE7 | Character(128) | VARCHAR2(128) NOT NULL | Metric Value 7 |
| PM_ADDTNL_DESCR | Long Character | CLOB | Additional Description |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |