PTIAADSPRJCALC

index back

ADS DataSet Definition

This table describes the records and key values that form the ADS dataset

PeopleSoft Field NameField TypeColumn TypeDescription
PROJECTNAMECharacter(30)VARCHAR2(30) NOT NULLProject Name (see PSPROJECTDEFN).
PTIASPADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTKEYCOL1Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE1Character(150)VARCHAR2(150) NOT NULLObject Value 1
PTKEYCOL2Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE2Character(150)VARCHAR2(150) NOT NULLObject Value 2
PTKEYCOL3Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE3Character(150)VARCHAR2(150) NOT NULLObject Value 3
PTKEYCOL4Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE4Character(150)VARCHAR2(150) NOT NULLObject Value 4
PTKEYCOL5Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE5Character(150)VARCHAR2(150) NOT NULLObject Value 5
PTKEYCOL6Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE6Character(150)VARCHAR2(150) NOT NULLObject Value 6
PTKEYCOL7Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE7Character(150)VARCHAR2(150) NOT NULLObject Value 7
PTKEYCOL8Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE8Character(150)VARCHAR2(150) NOT NULLObject Value 8
PTKEYCOL9Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE9Character(150)VARCHAR2(150) NOT NULLObject Value 9
PTKEYCOL10Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE10Character(150)VARCHAR2(150) NOT NULLObject Value 10
PTKEYCOL11Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE11Character(150)VARCHAR2(150) NOT NULLObject Value 11
PTKEYCOL12Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE12Character(150)VARCHAR2(150) NOT NULLObject Value 12
PTKEYCOL13Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE13Character(150)VARCHAR2(150) NOT NULLObject Value 13
PTKEYCOL14Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE14Character(150)VARCHAR2(150) NOT NULLObject Value 14
PTKEYCOL15Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE15Character(150)VARCHAR2(150) NOT NULLObejct Value 15
PTKEYCOL16Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE16Character(150)VARCHAR2(150) NOT NULLObject Value 16
PTIASPADSCATCharacter(30)VARCHAR2(30) NOT NULLADS Project Category
UPGRADEACTIONNumber(1,0)SMALLINT NOT NULLUpgrade Action
PTIASPTAKEACTIONNumber(1,0)SMALLINT NOT NULLTake Upgrade Action

1/0 Table Edit (1=True, 0=False)

Default: 1

NVSROWNUMNumber(10,0)DECIMAL(10) NOT NULLRow Number
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19