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 NameField TypeColumn TypeDescription
PTP_TEST_CASE_IDCharacter(30)VARCHAR2(30) NOT NULLPerformance Test Page Test Case Identifier
PTP_DTTM_A1DateTime(26)TIMESTAMPPTP Time Stamp A1
PTP_TOTAL_TIMENumber(9,3)DECIMAL(8,3) NOT NULLWeb Browser Elapsed Time
PTP_TIME_DNumber(9,3)DECIMAL(8,3) NOT NULLPTP Time Spend in database
PTP_WBNW_TIMENumber(9,3)DECIMAL(8,3) NOT NULLBrowser and Network Time
PTP_WSNW_TIMENumber(9,3)DECIMAL(8,3) NOT NULLWebServer and Network Time
PTP_ASNW_TIMENumber(9,3)DECIMAL(8,3) NOT NULLAppServer and Network Time
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19