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 |