PTIAADSPRJCALVW

index back

ADS DataSet Definition

This 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 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 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19