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