PTIASPADSNAMERECNAMEPTIASPKEYHASHPTIAADSCUSCNTVW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 3 | PTIASPKEYHASH |
Character(36) | VARCHAR2(36) NOT NULL | Hash of the key column values |
| 4 | PTIA_COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | PTIA Counter |
| 5 | PTKEYVALUE1 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 1 |
| 6 | PTKEYVALUE2 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 2 |
| 7 | PTKEYVALUE3 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 3 |
| 8 | PTKEYVALUE4 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 4 |
| 9 | PTKEYVALUE5 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 5 |
| 10 | PTKEYVALUE6 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 6 |
| 11 | PTKEYVALUE7 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 7 |
| 12 | PTKEYVALUE8 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 8 |