PTIASPADSNAMERECNAMEPTIASPKEYHASHPTIAADSCUSCNTVW |
index back |
|---|
| SELECT A.PTIASPADSNAME , A.RECNAME , A.PTIASPKEYHASH , COUNT(B.PTIACUSTNAME) , A.PTKEYVALUE1 , A.PTKEYVALUE2 , A.PTKEYVALUE3 , A.PTKEYVALUE4 , A.PTKEYVALUE5 , A.PTKEYVALUE6 , A.PTKEYVALUE7 , A.PTKEYVALUE8 FROM PS_PTIAADSCUSTREPO A , PS_PTIAADSREFREPO B WHERE A.PTIASPADSNAME = B.PTIASPADSNAME (+) AND A.RECNAME = B.RECNAME (+) AND A.PTIASPKEYHASH = B.PTIASPKEYHASH (+) GROUP BY A.PTIASPADSNAME, A.RECNAME, A.PTIASPKEYHASH , A.PTKEYVALUE1, A.PTKEYVALUE2, A.PTKEYVALUE3, A.PTKEYVALUE4, A.PTKEYVALUE5, A.PTKEYVALUE6, A.PTKEYVALUE7, A.PTKEYVALUE8 |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| 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 |
| PTIA_COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | PTIA Counter |
| 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 |