PTIASPADSNAME1/0 Table Edit (1=True, 0=False)
Default: 1
PTIAADSPRJCALVW |
index back |
|---|---|
ADS DataSet Definition |
| SELECT PUM.PROJECTNAME , PUM.PTIASPADSNAME , ROW_NUMBER() OVER ( ORDER BY PUM.PROJECTNAME , PUM.PTIASPADSNAME , PUM.PTKEYVALUE1 , PUM.PTKEYVALUE2 , PUM.PTKEYVALUE3 , PUM.PTKEYVALUE4 , PUM.PTKEYVALUE5 , PUM.PTKEYVALUE6 , PUM.PTKEYVALUE7 , PUM.PTKEYVALUE8 , PUM.PTKEYVALUE9 , PUM.PTKEYVALUE10 , PUM.PTKEYVALUE11 , PUM.PTKEYVALUE12 , PUM.PTKEYVALUE13 , PUM.PTKEYVALUE14 , PUM.PTKEYVALUE15 , PUM.PTKEYVALUE16) PTADSCONTENTID , PUM.PTKEYCOL1 , PUM.PTKEYVALUE1 , PUM.PTKEYCOL2 , PUM.PTKEYVALUE2 , PUM.PTKEYCOL3 , PUM.PTKEYVALUE3 , PUM.PTKEYCOL4 , PUM.PTKEYVALUE4 , PUM.PTKEYCOL5 , PUM.PTKEYVALUE5 , PUM.PTKEYCOL6 , PUM.PTKEYVALUE6 , PUM.PTKEYCOL7 , PUM.PTKEYVALUE7 , PUM.PTKEYCOL8 , PUM.PTKEYVALUE8 , PUM.PTKEYCOL9 , PUM.PTKEYVALUE9 , PUM.PTKEYCOL10 , PUM.PTKEYVALUE10 , PUM.PTKEYCOL11 , PUM.PTKEYVALUE11 , PUM.PTKEYCOL12 , PUM.PTKEYVALUE12 , PUM.PTKEYCOL13 , PUM.PTKEYVALUE13 , PUM.PTKEYCOL14 , PUM.PTKEYVALUE14 , PUM.PTKEYCOL15 , PUM.PTKEYVALUE15 , PUM.PTKEYCOL16 , PUM.PTKEYVALUE16 , PUM.UPGRADEACTION , PUM.PTIASPTAKEACTION FROM PS_PTIAADSPRJCALC PUM , PSADSDEFNITEM ADS WHERE PUM.PTIASPADSNAME = ADS.PTADSNAME AND PUM.RECNAME = ADS.RECNAME AND ADS.PTPARENTRECNAME = ' ' GROUP BY PUM.PROJECTNAME, PUM.PTIASPADSNAME, PUM.PTKEYCOL1, PUM.PTKEYVALUE1, PUM.PTKEYCOL2, PUM.PTKEYVALUE2, PUM.PTKEYCOL3, PUM.PTKEYVALUE3, PUM.PTKEYCOL4, PUM.PTKEYVALUE4, PUM.PTKEYCOL5, PUM.PTKEYVALUE5, PUM.PTKEYCOL6, PUM.PTKEYVALUE6, PUM.PTKEYCOL7, PUM.PTKEYVALUE7, PUM.PTKEYCOL8, PUM.PTKEYVALUE8, PUM.PTKEYCOL9, PUM.PTKEYVALUE9, PUM.PTKEYCOL10, PUM.PTKEYVALUE10, PUM.PTKEYCOL11, PUM.PTKEYVALUE11, PUM.PTKEYCOL12, PUM.PTKEYVALUE12, PUM.PTKEYCOL13, PUM.PTKEYVALUE13, PUM.PTKEYCOL14, PUM.PTKEYVALUE14, PUM.PTKEYCOL15, PUM.PTKEYVALUE15, PUM.PTKEYCOL16, PUM.PTKEYVALUE16, PUM.UPGRADEACTION , PUM.PTIASPTAKEACTION |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| PTIASPADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name |
| PTADSCONTENTID | Number(6,0) | INTEGER NOT NULL | ADS Content Identifier |
| PTKEYCOL1 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE1 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 1 |
| PTKEYCOL2 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE2 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 2 |
| PTKEYCOL3 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE3 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 3 |
| PTKEYCOL4 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE4 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 4 |
| PTKEYCOL5 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE5 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 5 |
| PTKEYCOL6 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE6 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 6 |
| PTKEYCOL7 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE7 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 7 |
| PTKEYCOL8 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE8 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 8 |
| PTKEYCOL9 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE9 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 9 |
| PTKEYCOL10 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE10 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 10 |
| PTKEYCOL11 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE11 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 11 |
| PTKEYCOL12 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE12 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 12 |
| PTKEYCOL13 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE13 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 13 |
| PTKEYCOL14 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE14 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 14 |
| PTKEYCOL15 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE15 | Character(150) | VARCHAR2(150) NOT NULL | Obejct Value 15 |
| PTKEYCOL16 | Character(18) | VARCHAR2(18) NOT NULL | |
| PTKEYVALUE16 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 16 |
| UPGRADEACTION | Number(1,0) | SMALLINT NOT NULL | Upgrade Action |
| PTIASPTAKEACTION | Number(1,0) | SMALLINT NOT NULL |
Take Upgrade Action
1/0 Table Edit (1=True, 0=False) Default: 1 |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |