PTIASPCHART1VW(SQL View) |
Index Back |
|---|---|
Bug Applied Info by ProductUpdates 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 | 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 | PTIASPAPPLIED | Character(1) | VARCHAR2(1) NOT NULL |
Apply Info
N=Unapplied O=Other Products P=Applied |
| 6 | PTIASPRATIO | Number(8,3) | DECIMAL(7,3) NOT NULL | Ratio |