PTIASPRPTQRYVW(SQL View) |
Index Back |
|---|
| SELECT A.PTIASPRPTNO , A.PTIASPSPVERS , A.PTIASPRPTSEVERITY , B.PTIASPPRDFMLY FROM PS_PTIASPRPTHEAD A , PS_PTIASPPRDFMLY B WHERE B.PTIASPPRDID = A.PTIASPPRDID AND A.PTIASPRPTNO>1000 AND A.PTIASPRPTNO<600000000 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPRPTNO | Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 2 | PTIASPSPVERS | Number(5,0) | INTEGER NOT NULL | Numeric value for Patch Database Version Number |
| 3 | PTIASPRPTSEVERITY | Character(45) | VARCHAR2(45) NOT NULL | BUG Severity Description |
| 4 | PTIASPPRDFMLY | Character(5) | VARCHAR2(5) NOT NULL | Product Family |