PTP_TST_CASE_VW |
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 | Field Type | Column Type | Description |
---|---|---|---|
PTP_TEST_CASE_ID | Character(30) | VARCHAR2(30) NOT NULL | Performance Test Page Test Case Identifier |
PTP_DTTM_A1 | DateTime(26) | TIMESTAMP | PTP Time Stamp A1 |
PTP_TOTAL_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | Web Browser Elapsed Time |
PTP_TIME_D | Number(9,3) | DECIMAL(8,3) NOT NULL | PTP Time Spend in database |
PTP_WBNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | Browser and Network Time |
PTP_WSNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | WebServer and Network Time |
PTP_ASNW_TIME | Number(9,3) | DECIMAL(8,3) NOT NULL | AppServer and Network Time |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |