PTIASPADSNAME1/0 Table Edit (1=True, 0=False)
Default Value: 1
PTIAADSPRJCALVW(SQL View) |
Index Back |
|---|---|
ADS DataSet DefinitionThis table describes the records and key values that form the ADS dataset |
| 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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROJECTNAME | Character(30) | VARCHAR2(30) NOT NULL | Project Name (see PSPROJECTDEFN). |
| 2 | PTIASPADSNAME |
Character(30) | VARCHAR2(30) NOT NULL | Data Set Name |
| 3 | PTADSCONTENTID | Number(6,0) | INTEGER NOT NULL | ADS Content Identifier |
| 4 | PTKEYCOL1 | Character(18) | VARCHAR2(18) NOT NULL | |
| 5 | PTKEYVALUE1 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 1 |
| 6 | PTKEYCOL2 | Character(18) | VARCHAR2(18) NOT NULL | |
| 7 | PTKEYVALUE2 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 2 |
| 8 | PTKEYCOL3 | Character(18) | VARCHAR2(18) NOT NULL | |
| 9 | PTKEYVALUE3 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 3 |
| 10 | PTKEYCOL4 | Character(18) | VARCHAR2(18) NOT NULL | |
| 11 | PTKEYVALUE4 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 4 |
| 12 | PTKEYCOL5 | Character(18) | VARCHAR2(18) NOT NULL | |
| 13 | PTKEYVALUE5 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 5 |
| 14 | PTKEYCOL6 | Character(18) | VARCHAR2(18) NOT NULL | |
| 15 | PTKEYVALUE6 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 6 |
| 16 | PTKEYCOL7 | Character(18) | VARCHAR2(18) NOT NULL | |
| 17 | PTKEYVALUE7 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 7 |
| 18 | PTKEYCOL8 | Character(18) | VARCHAR2(18) NOT NULL | |
| 19 | PTKEYVALUE8 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 8 |
| 20 | PTKEYCOL9 | Character(18) | VARCHAR2(18) NOT NULL | |
| 21 | PTKEYVALUE9 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 9 |
| 22 | PTKEYCOL10 | Character(18) | VARCHAR2(18) NOT NULL | |
| 23 | PTKEYVALUE10 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 10 |
| 24 | PTKEYCOL11 | Character(18) | VARCHAR2(18) NOT NULL | |
| 25 | PTKEYVALUE11 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 11 |
| 26 | PTKEYCOL12 | Character(18) | VARCHAR2(18) NOT NULL | |
| 27 | PTKEYVALUE12 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 12 |
| 28 | PTKEYCOL13 | Character(18) | VARCHAR2(18) NOT NULL | |
| 29 | PTKEYVALUE13 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 13 |
| 30 | PTKEYCOL14 | Character(18) | VARCHAR2(18) NOT NULL | |
| 31 | PTKEYVALUE14 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 14 |
| 32 | PTKEYCOL15 | Character(18) | VARCHAR2(18) NOT NULL | |
| 33 | PTKEYVALUE15 | Character(150) | VARCHAR2(150) NOT NULL | Obejct Value 15 |
| 34 | PTKEYCOL16 | Character(18) | VARCHAR2(18) NOT NULL | |
| 35 | PTKEYVALUE16 | Character(150) | VARCHAR2(150) NOT NULL | Object Value 16 |
| 36 | UPGRADEACTION | Number(1,0) | SMALLINT NOT NULL | Upgrade Action |
| 37 | PTIASPTAKEACTION | Number(1,0) | SMALLINT NOT NULL |
Take Upgrade Action
1/0 Table Edit (1=True, 0=False) Default Value: 1 |