PTUNIRVWNAMEPSPTUNIRVWSR_VW |
index back |
|---|---|
Unified review search result |
| SELECT A.PTUNIRVWNAME , A.DESCR254 , A.PTUNIRVWMOPRJNAME , A.SESSIONID1 , A.PTUNIRVWADSPRJNAME FROM PSPTUNIRVWDEFN A WHERE A.RUNDTTM = ( SELECT MAX(B.RUNDTTM) FROM PSPTUNIRVWDEFN B WHERE A.PTUNIRVWNAME=B.PTUNIRVWNAME) |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTUNIRVWNAME |
Character(30) | VARCHAR2(30) NOT NULL | Unified ADS/MO compare review name |
| DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| PTUNIRVWMOPRJNAME | Character(30) | VARCHAR2(30) NOT NULL | Unified ADS/MO compare review name |
| SESSIONID1 | Character(36) | VARCHAR2(36) NOT NULL | Compare Session 1 |
| PTUNIRVWADSPRJNAME | Character(30) | VARCHAR2(30) NOT NULL | Unified ADS/MO compare review name |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |