PTIASPRPTNOPTIASPADSNAMERECNAMEPTIASPKEYHASHPTIASPRPTADSOVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.PTIASPRPTNO , A.PTIASPADSNAME , A.RECNAME , A.PTIASPKEYHASH , A.PTKEYVALUE1 , A.PTKEYVALUE2 , A.PTKEYVALUE3 , A.PTKEYVALUE4 , A.PTKEYVALUE5 , A.PTKEYVALUE6 , A.PTKEYVALUE7 , A.PTKEYVALUE8 , NVL(CNT.PTIA_COUNTER , 0) FROM PS_PTIASPRPTADSVW A , PS_PTIAADSCUSCNTVW CNT WHERE A.PTIASPADSNAME = CNT.PTIASPADSNAME (+) AND A.RECNAME = CNT.RECNAME (+) AND A.PTIASPKEYHASH = CNT.PTIASPKEYHASH (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PTIASPRPTNO |
Number(10,0) | DECIMAL(10) NOT NULL | BUG Number |
| 2 | PTIASPADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name |
| 3 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| 4 | PTIASPKEYHASH |
Character(36) | VARCHAR2(36) NOT NULL | Hash of the key column values |
| 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 |
| 13 | PTIA_COUNTER | Number(10,0) | DECIMAL(10) NOT NULL | Customization Count |