PSCOMPOBJDIF_VW

index back

Compare Differences


SELECT PTSESSIONID , PTTYPENAME , PTDIFFTYPE , COMPARETYPE , CASE WHEN PTNUMKEYS10 > 0 THEN PTRECNAME10 WHEN PTNUMKEYS9 > 0 THEN PTRECNAME9 WHEN PTNUMKEYS8 > 0 THEN PTRECNAME8 WHEN PTNUMKEYS7 > 0 THEN PTRECNAME7 WHEN PTNUMKEYS6 > 0 THEN PTRECNAME6 WHEN PTNUMKEYS5 > 0 THEN PTRECNAME5 WHEN PTNUMKEYS4 > 0 THEN PTRECNAME4 WHEN PTNUMKEYS3 > 0 THEN PTRECNAME3 WHEN PTNUMKEYS2 > 0 THEN PTRECNAME2 ELSE PTRECNAME1 END , PTFIELDNAME , CASE WHEN PTDIFFTYPE = 0 THEN 'S' ELSE CASE WHEN PTPRESENCE = 'B' THEN 'C' WHEN PTPRESENCE = 'S' THEN 'C' ELSE 'A' END END , CASE WHEN PTDIFFTYPE = 0 THEN 'S' ELSE CASE WHEN PTPRESENCE = 'B' THEN 'C' WHEN PTPRESENCE = 'T' THEN 'C' ELSE 'A' END END , CASE WHEN PTPRESENCE = 'S' THEN 'A' WHEN PTPRESENCE = 'T' THEN 'D' WHEN PTLOCALVALUE = PTREMOTEVALUE THEN 'S' ELSE 'C' END , CASE WHEN PTPRESENCE = 'S' THEN 'A' WHEN PTPRESENCE = 'T' THEN 'D' WHEN PTLOCALVALUE = PTREMOTEVALUE THEN 'S' ELSE 'C' END , PTLOCALVALUE , PTLOCALVALTYPE , PTLOCALVALUE , PTLOCALVALTYPE , PTREMOTEVALUE , PTREMOTEVALTYPE , PTMERGEACTION , PTMERGESTATUS , '' , '' , '' , '' , 0 , PTRECNAME1 , PTRECNAME2 , PTRECNAME3 , PTRECNAME4 , PTRECNAME5 , PTRECNAME6 , PTRECNAME7 , PTRECNAME8 , PTRECNAME9 , PTRECNAME10 , PTNUMKEYS1 , PTNUMKEYS2 , PTNUMKEYS3 , PTNUMKEYS4 , PTNUMKEYS5 , PTNUMKEYS6 , PTNUMKEYS7 , PTNUMKEYS8 , PTNUMKEYS9 , PTNUMKEYS10 , PTKEYCOL1 , PTKEYCOL2 , PTKEYCOL3 , PTKEYCOL4 , PTKEYCOL5 , PTKEYCOL6 , PTKEYCOL7 , PTKEYCOL8 , PTKEYCOL9 , PTKEYCOL10 , PTKEYCOL11 , PTKEYCOL12 , PTKEYCOL13 , PTKEYCOL14 , PTKEYCOL15 , PTKEYCOL16 , PTKEYVALUE1 , PTKEYVALUE2 , PTKEYVALUE3 , PTKEYVALUE4 , PTKEYVALUE5 , PTKEYVALUE6 , PTKEYVALUE7 , PTKEYVALUE8 , PTKEYVALUE9 , PTKEYVALUE10 , PTKEYVALUE11 , PTKEYVALUE12 , PTKEYVALUE13 , PTKEYVALUE14 , PTKEYVALUE15 , PTKEYVALUE16 FROM PSCOMPOBJDIFF

PeopleSoft Field Name Field Type Column Type Description
PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
PTTYPENAME Character(30) VARCHAR2(30) NOT NULL
PTDIFFTYPE Number(3,0) SMALLINT NOT NULL Difference Type
COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
PTFIELDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
PTSOURCESTATUS Character(4) VARCHAR2(4) NOT NULL Source Status
A=Absent
C=Changed
CC=Custom Changed
CS=Custom Unchanged
S=Unchanged
PTTARGETSTATUS Character(4) VARCHAR2(4) NOT NULL Target Status
A=Absent
C=Changed
CC=Custom Changed
CS=Custom Unchanged
S=Unchanged
PTADSPREMRGSTATUS Character(1) VARCHAR2(1) NOT NULL No-Merge Action
A=Addition
C=Different
D=Deletion
K=Kept
S=Same
U=Unknown

Default: U

PTADSPOSTMRGSTATUS Character(1) VARCHAR2(1) NOT NULL Merge Action
A=Addition
C=Different
D=Deletion
K=Kept
S=Same
U=Unknown

Default: U

PTLOCALVALUE Character(254) VARCHAR2(254) NOT NULL Source Value
PTLOCALVALTYPE Number(3,0) SMALLINT NOT NULL Local Type
PTPROPOSEDVALUE Character(254) VARCHAR2(254) NOT NULL Configuration Value
PTPROPOSEDVALTYPE Number(3,0) SMALLINT NOT NULL Proposed Value Type
PTREMOTEVALUE Character(254) VARCHAR2(254) NOT NULL Current Target 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
DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
PTMERGEACTION2 Character(1) VARCHAR2(1) NOT NULL Merge Action
0=Copy
1=Delete
C=Copy from Source
D=Remove from Target
M=Copy and Keep Configurations
N=Take no Action
W=Copy from Source

Default: 0

PTMERGESTATUS2 Character(1) VARCHAR2(1) NOT NULL Merge Upgrade
0=NoUpgrade
1=YesUpgrade
N=False
Y=True
PTDONE Character(1) VARCHAR2(1) NOT NULL Done
N=No
Y=Yes
PTADSCONTENTID Number(6,0) INTEGER NOT NULL ADS Content Identifier
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
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
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19