PSADSTRACKING

index back

PeopleSoft Field Name Field Type Column Type Description
PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTKEYHASH Character(28) VARCHAR2(28) NOT NULL
PTKEYCOL1 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL2 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL3 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL4 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL5 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL6 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL7 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL8 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL9 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL10 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL11 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL12 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL13 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL14 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL15 Character(18) VARCHAR2(18) NOT NULL
PTKEYCOL16 Character(18) VARCHAR2(18) NOT NULL
PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1
PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2
PTKEYVALUE3 Character(150) VARCHAR2(150) NOT NULL Object Value 3
PTKEYVALUE4 Character(150) VARCHAR2(150) NOT NULL Object Value 4
PTKEYVALUE5 Character(150) VARCHAR2(150) NOT NULL Object Value 5
PTKEYVALUE6 Character(150) VARCHAR2(150) NOT NULL Object Value 6
PTKEYVALUE7 Character(150) VARCHAR2(150) NOT NULL Object Value 7
PTKEYVALUE8 Character(150) VARCHAR2(150) NOT NULL Object Value 8
PTKEYVALUE9 Character(150) VARCHAR2(150) NOT NULL Object Value 9
PTKEYVALUE10 Character(150) VARCHAR2(150) NOT NULL Object Value 10
PTKEYVALUE11 Character(150) VARCHAR2(150) NOT NULL Object Value 11
PTKEYVALUE12 Character(150) VARCHAR2(150) NOT NULL Object Value 12
PTKEYVALUE13 Character(150) VARCHAR2(150) NOT NULL Object Value 13
PTKEYVALUE14 Character(150) VARCHAR2(150) NOT NULL Object Value 14
PTKEYVALUE15 Character(150) VARCHAR2(150) NOT NULL Obejct Value 15
PTKEYVALUE16 Character(150) VARCHAR2(150) NOT NULL Object Value 16
LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20