PSCOMPOBJDIFF

index back

PeopleSoft Field Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTPRESENCE Character(20) VARCHAR2(20) NOT NULL Existence Of the object
PTDIFFTYPE Number(3,0) SMALLINT NOT NULL Difference Type
COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
PTTYPENAME Character(30) VARCHAR2(30) NOT NULL
OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
PTKEYHASH Character(28) VARCHAR2(28) NOT NULL
PTLOCALHASH Character(28) VARCHAR2(28) NOT NULL
PTREMOTEHASH Character(28) VARCHAR2(28) NOT NULL
PTRECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1
PTRECNAME2 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME3 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME4 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME5 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME6 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME7 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME8 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME9 Character(15) VARCHAR2(15) NOT NULL
PTRECNAME10 Character(15) VARCHAR2(15) NOT NULL
PTTABLENAME1 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME2 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME3 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME4 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME5 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME6 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME7 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME8 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME9 Character(18) VARCHAR2(18) NOT NULL
PTTABLENAME10 Character(18) VARCHAR2(18) NOT NULL
PTNUMKEYS1 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS2 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS3 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS4 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS5 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS6 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS7 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS8 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS9 Number(3,0) SMALLINT NOT NULL
PTNUMKEYS10 Number(3,0) SMALLINT 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
PTKEYTYPE1 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE2 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE3 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE4 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE5 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE6 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE7 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE8 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE9 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE10 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE11 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE12 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE13 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE14 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE15 Character(4) VARCHAR2(4) NOT NULL
PTKEYTYPE16 Character(4) VARCHAR2(4) NOT NULL
PTFIELDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
PTLOCALVALUE Character(254) VARCHAR2(254) NOT NULL Local Value
PTLOCALVALTYPE Number(3,0) SMALLINT NOT NULL Local Type
PTREMOTEVALUE Character(254) VARCHAR2(254) NOT NULL Remote Value
PTREMOTEVALTYPE Number(3,0) SMALLINT NOT NULL Target Value
PTMERGEACTION Number(3,0) SMALLINT NOT NULL Merge Action
PTMERGESTATUS Number(3,0) SMALLINT NOT NULL Merge Status
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19