PTIASPCHART1VW

 index back

Bug Applied Info by Product

Updates applied by Product, relative to Total Updates in Image for that Product
SELECT A.DBNAME , A.USERID , A.PTIASPSPVERS , A.PTIASPPRDCD , B.PTIASPAPPLIED , 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 , PTIASPAPPLIED , COUNT(PTIASPAPPLIED) AS PART FROM PS_PTIASPRPTTYPEVW WHERE PTIASPAPPLIED <> 'O' GROUP BY DBNAME, USERID, PTIASPSPVERS, PTIASPPRDCD, PTIASPAPPLIED) 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, B.PTIASPPRDCD

PeopleSoft Field Name Field Type Column Type Description
DBNAME Character(8) VARCHAR2(8) NOT NULL Database Name
USERID Character(30) VARCHAR2(30) NOT NULL A user's ID
PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
PTIASPPRDCD Character(8) VARCHAR2(8) NOT NULL Product
PTIASPAPPLIED Character(1) VARCHAR2(1) NOT NULL Apply Info
N=Unapplied
O=Other Products
P=Applied
PTIASPRATIO Number(8,3) DECIMAL(7,3) NOT NULL Ratio
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20