PTIASPTAGVW

(SQL View)
 Index Back

BUG Status by TAG

BUG Percentage Applied / Unapplied by TAGs

SELECT DISTINCT D.DBNAME , T.PTIASPRPTTAGNAME , T.PTIASPRPTTAGVALUE , ROUND((( SELECT COUNT(*) FROM PS_PTIASPLOGTGT L , PS_PTIASPRPTTAGS T2 WHERE L.PTIASPRPTNO = T2.PTIASPRPTNO AND L.DBNAME = D.DBNAME AND T2.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T2.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE ) * 100 / ( SELECT COUNT(*) FROM PS_PTIASPRPTTAGS T1 WHERE T1.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T1.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE)),2) AS PERCENT ,'Applied' AS "BUG Status" FROM PS_PTIASPRPTTAGS T, PS_PTIASPTGTDBVW D UNION SELECT DISTINCT D.DBNAME , T.PTIASPRPTTAGNAME , T.PTIASPRPTTAGVALUE , ROUND(100-(( SELECT COUNT(*) FROM PS_PTIASPLOGTGT L , PS_PTIASPRPTTAGS T2 WHERE L.PTIASPRPTNO = T2.PTIASPRPTNO AND L.DBNAME = D.DBNAME AND T2.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T2.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE ) * 100 / ( SELECT COUNT(*) FROM PS_PTIASPRPTTAGS T1 WHERE T1.PTIASPRPTTAGNAME = T.PTIASPRPTTAGNAME AND T1.PTIASPRPTTAGVALUE = T.PTIASPRPTTAGVALUE)),2) AS PERCENT ,'Unapplied' AS "BUG Status" FROM PS_PTIASPRPTTAGS T, PS_PTIASPTGTDBVW D ORDER BY 1,2,3

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 PTIASPRPTTAGNAME Character(30) VARCHAR2(30) NOT NULL TAG Name
3 PTIASPRPTTAGVALUE Character(254) VARCHAR2(254) NOT NULL TAG Value
4 PTIA_PCT Signed Number(7,2) DECIMAL(5,2) NOT NULL Percent field for PTIA use.
5 PTIA_TEXT1 Character(15) VARCHAR2(15) NOT NULL Text field for PTIA use.