PTIASPRPTADSDAT

index back

ADS DataSet Definition

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

PeopleSoft Field NameField TypeColumn TypeDescription
PTIASPRPTNONumber(10,0)DECIMAL(10) NOT NULLBUG Number
PTIASPZIPFILENAMECharacter(254)VARCHAR2(254) NOT NULLzip file name
PTIASPADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTIASPKEYHASHCharacter(36)VARCHAR2(36) NOT NULLHash of the key column values
PTIASPNONKEYHASHCharacter(36)VARCHAR2(36) NOT NULLHash of the none key column values
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
PTIASPUPGACTIONCharacter(1)VARCHAR2(1) NOT NULLUpgrade Action
0=Copy
1=Delete
2=None
3=Copy Property

Default: 0

PTIASPTAKEACTIONNumber(1,0)SMALLINT NOT NULLTake Upgrade Action

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

Default: 1

index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19