PSPMTRANS35_VW(SQL View) |
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 Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_INSTANCE_ID | Number(20,0) | DECIMAL(20) NOT NULL | Instance Identifier |
| 2 | PM_PROCESS_ID | Number(8,0) | INTEGER NOT NULL | Process ID |
| 3 | PM_AGENT_STRT_DTTM | DateTime(26) | TIMESTAMP | Agent Start Date/Time |
| 4 | PM_MON_STRT_DTTM | DateTime(26) | TIMESTAMP | Monitor Received Date/Time |
| 5 | PM_TRANS_DURATION | Number(22,3) | DECIMAL(21,3) NOT NULL | Duration (ms) |
| 6 | PM_PARENT_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Parent Instance Identifier |
| 7 | PM_TOP_INST_ID | Number(20,0) | DECIMAL(20) NOT NULL | Top Instance Identifier |
| 8 | PM_AGENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| 9 | PM_DOMAIN_NAME | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| 10 | PM_HOST_PORT | Character(254) | VARCHAR2(254) NOT NULL | Performance Monitor host name. |
| 11 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 12 | TOOLSREL | Character(20) | VARCHAR2(20) NOT NULL | Tools Release Number |
| 13 | PTUSERNAME | Character(30) | VARCHAR2(30) NOT NULL | User Name |
| 14 | PTBUSTRANSACTION | Character(60) | VARCHAR2(60) NOT NULL | Business Transaction |
| 15 | PTTST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Name (see PSPTTSTDEFN). |
| 16 | PTTST_CASE_NAME | Character(30) | VARCHAR2(30) NOT NULL | Test Case Name |
| 17 | OBJECTTYPE | Number(5,0) | INTEGER NOT NULL | Object Type |
| 18 | OBJECTVALUE1 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 1 |
| 19 | OBJECTVALUE2 | Character(100) | VARCHAR2(100) NOT NULL | Object Value 2 |
| 20 | OBJECTVALUE3 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 3 |
| 21 | OBJECTVALUE4 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 4 |
| 22 | OBJECTVALUE5 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 5 |
| 23 | OBJECTVALUE6 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 6 |
| 24 | OBJECTVALUE7 | Character(30) | VARCHAR2(30) NOT NULL | Object Value 7 |
| 25 | ROW_COUNT | Number(8,0) | INTEGER NOT NULL | Number to Purge |