PTP_TST_CASE_VW(SQL View) |
Index Back |
|---|
| SELECT PTP_TEST_CASE_ID , PTP_DTTM_A1 , PTP_TOTAL_TIME , PTP_TIME_D , PTP_TOTAL_TIME - PTP_WS_TIME , PTP_WS_TIME - PTP_AS_TIME , PTP_AS_TIME - PTP_TIME_D FROM PS_PTP_TST_CASES |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTP_TEST_CASE_ID | Character(30) | VARCHAR2(30) NOT NULL | Performance Test Page Test Case Identifier |
| 2 | PTP_DTTM_A1 | DateTime(26) | TIMESTAMP | PTP Time Stamp A1 |
| 3 | PTP_TOTAL_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | Web Browser Elapsed Time |
| 4 | PTP_TIME_D | Number(9,3) | DECIMAL(8,3) NOT NULL | PTP Time Spend in database |
| 5 | PTP_WBNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | Browser and Network Time |
| 6 | PTP_WSNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | WebServer and Network Time |
| 7 | PTP_ASNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | AppServer and Network Time |