PTIASPRPTNOPTIASPZIPFILENAMEPTIASPADSNAMERECNAMEPTIASPKEYHASHPTIASPRPTADSVW |
index back |
|---|
| SELECT PTIASPRPTNO , PTIASPZIPFILENAME , PTIASPADSNAME , RECNAME , PTIASPKEYHASH , PTKEYVALUE1 , PTKEYVALUE2 , PTKEYVALUE3 , PTKEYVALUE4 , PTKEYVALUE5 , PTKEYVALUE6 , PTKEYVALUE7 , PTKEYVALUE8 FROM PS_PTIASPRPTADSDAT WHERE EXISTS ( SELECT 'X' FROM PSADSDEFNITEM AI , PSADSGROUPPROP MO WHERE PS_PTIASPRPTADSDAT.PTIASPADSNAME = AI.PTADSNAME AND AI.PTADSNAME = MO.PTADSNAME AND PS_PTIASPRPTADSDAT.RECNAME = AI.RECNAME AND AI.PTPARENTRECNAME = ' ' AND MO.PTPROPNAME LIKE 'MO_%') |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PTIASPRPTNO |
Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| PTIASPZIPFILENAME |
Character(254) | VARCHAR2(254) NOT NULL | zip file name |
| PTIASPADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name |
| RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| PTIASPKEYHASH |
Character(36) | VARCHAR2(36) NOT NULL | Hash of the key column values |
| PTKEYVALUE1 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 1 |
| PTKEYVALUE2 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 2 |
| PTKEYVALUE3 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 3 |
| PTKEYVALUE4 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 4 |
| PTKEYVALUE5 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 5 |
| PTKEYVALUE6 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 6 |
| PTKEYVALUE7 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 7 |
| PTKEYVALUE8 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 8 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |