PTIASPCHART2VW

(SQL View)
 Index Back

Bug Applied for All Prod

Updates applied for All Products, relative to Total Updates in Image for that Product

SELECT A.DBNAME , A.USERID , A.PTIASPSPVERS , A.PTIASPPRDCD , ROUND(PART/TOTAL , 3) FROM ( SELECT DBNAME , USERID , PTIASPSPVERS , PTIASPPRDCD , COUNT(PTIASPRPTNO) AS TOTAL FROM PS_PTIASPRPTTYPEVW WHERE PTIASPAPPLIED <> 'O' GROUP BY DBNAME, USERID, PTIASPSPVERS ,PTIASPPRDCD ) A , ( SELECT DBNAME , USERID ,PTIASPSPVERS , PTIASPPRDCD , COUNT(PTIASPAPPLIED) AS PART FROM PS_PTIASPRPTTYPEVW WHERE PTIASPAPPLIED = 'P' GROUP BY DBNAME, USERID, PTIASPSPVERS, PTIASPPRDCD ) B WHERE A.DBNAME = B.DBNAME AND A.USERID = B.USERID AND A.PTIASPSPVERS = B.PTIASPSPVERS AND A.PTIASPPRDCD = B.PTIASPPRDCD ORDER BY B.DBNAME, B.PTIASPSPVERS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
2 USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
3 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
4 PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
5 PTIASPRATIO Number(8,3) DECIMAL(7,3) NOT NULL Ratio