PTIAMMCPKRBYREG(SQL View) |
Index Back |
|---|
| SELECT DISTINCT C.DBNAME , C.PTIASPPKGNAME , A.PTIASPSPVERS , A.PTIASPRPTNO FROM PS_PTIASPRPTHEAD A , PS_PTIASPRPTTAGS B , PS_PTIAMMCPKGBYFIX C , PS_PTIAMMCINPBYDB D WHERE 1=1 AND A.PTIASPRPTNO = B.PTIASPRPTNO AND A.PTIASPRPTNO = C.PTIASPRPTNO AND A.PTIASPPRDID = D.PTIASPPRDID AND C.DBNAME = D.DBNAME AND B.PTIASPRPTTAGNAME IN ('Legislative/Regulatory','Tax Update (PSFT)') ORDER BY A.PTIASPRPTNO |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 2 | PTIASPPKGNAME | Character(30) | VARCHAR2(30) NOT NULL | Package Name |
| 3 | PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |
| 4 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |