PTF Tables & a Handy SQL

PeopleSoft Test Framework is used in several projects now a days. Although some are not ready to accept this testing tool, the benefits and the flexibility this tool provides in the testing phase is inevitable.

Couple of handy tips related to PTF given below.

Below are the main tables in PTF if you want to create a custom easy reporting from the back end.

PSPTTSTDEFN --Get information about the Test from the Test Definition Tabl
PSPTTSTERROR --Get all error messages associated with the Test
PSPTTSTDESCR --Get comments associated with the Test from the Test Description Table
PSPTTSTCASE --Get information about the Test Cases for this Test from the Test Case
PSPTTSTCOMMAND -- Get information about the Test Steps for this Test from the Test Command
PSPTTSTCMDDESCR --Get comments associated with the Test Steps from the Test Command
PSPTTSTCASEVAL --Get the values associated with the Test Cases from the Test Case Values
PSPTTSTLOG_LIST  --Get the PTF test status from this table
PSPTTSTLOG_LNS --Get the test log lines from tis table

Although there are couple of user level reports available with the package, those aren't much intuitive for the testing resources.

A simple but a very handy piece of SQL is given below:
SELECT A.PTTST_NAME,A.DESCR,B.PTTST_LOG_ID,CASE PTTST_LOG_RESULT WHEN 110 THEN 'Pass' WHEN 121 THEN 'Warning' WHEN 120 THEN 'Fail' END AS TEST_STATUS,
A.LASTUPDDTTM,A.LASTUPDOPRID FROM PSPTTSTDEFN A,PSPTTSTLOG_LIST B WHERE A.PTTST_NAME=B.PTTST_NAME
ORDER BY PTTST_NAME,PTTST_LOG_ID;