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 NameField TypeColumn TypeDescription
PTSESSIONIDCharacter(36)VARCHAR2(36) NOT NULLCompare Session Id
PTTYPENAMECharacter(30)VARCHAR2(30) NOT NULL
PTDIFFTYPENumber(3,0)SMALLINT NOT NULLDifference Type
COMPARETYPENumber(5,0)INTEGER NOT NULLCompare Type
RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).
PTFIELDNAMECharacter(30)VARCHAR2(30) NOT NULLField Name
PTSOURCESTATUSCharacter(4)VARCHAR2(4) NOT NULLSource Status
A=Absent
C=Changed
CC=Custom Changed
CS=Custom Unchanged
S=Unchanged
PTTARGETSTATUSCharacter(4)VARCHAR2(4) NOT NULLTarget Status
A=Absent
C=Changed
CC=Custom Changed
CS=Custom Unchanged
S=Unchanged
PTADSPREMRGSTATUSCharacter(1)VARCHAR2(1) NOT NULLNo-Merge Action
A=Addition
C=Different
D=Deletion
K=Kept
S=Same
U=Unknown

Default: U

PTADSPOSTMRGSTATUSCharacter(1)VARCHAR2(1) NOT NULLMerge Action
A=Addition
C=Different
D=Deletion
K=Kept
S=Same
U=Unknown

Default: U

PTLOCALVALUECharacter(254)VARCHAR2(254) NOT NULLSource Value
PTLOCALVALTYPENumber(3,0)SMALLINT NOT NULLLocal Type
PTPROPOSEDVALUECharacter(254)VARCHAR2(254) NOT NULLConfiguration Value
PTPROPOSEDVALTYPENumber(3,0)SMALLINT NOT NULLProposed Value Type
PTREMOTEVALUECharacter(254)VARCHAR2(254) NOT NULLCurrent Target Value
PTREMOTEVALTYPENumber(3,0)SMALLINT NOT NULLTarget Value
PTMERGEACTIONNumber(3,0)SMALLINT NOT NULLMerge Action
PTMERGESTATUSNumber(3,0)SMALLINT NOT NULLMerge Status
DESCR254Character(254)VARCHAR2(254) NOT NULLDescription of length 254
PTMERGEACTION2Character(1)VARCHAR2(1) NOT NULLMerge 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

PTMERGESTATUS2Character(1)VARCHAR2(1) NOT NULLMerge Upgrade
0=NoUpgrade
1=YesUpgrade
N=False
Y=True
PTDONECharacter(1)VARCHAR2(1) NOT NULLDone
N=No
Y=Yes
PTADSCONTENTIDNumber(6,0)INTEGER NOT NULLADS Content Identifier
PTRECNAME1Character(15)VARCHAR2(15) NOT NULLRecord Name 1
PTRECNAME2Character(15)VARCHAR2(15) NOT NULL
PTRECNAME3Character(15)VARCHAR2(15) NOT NULL
PTRECNAME4Character(15)VARCHAR2(15) NOT NULL
PTRECNAME5Character(15)VARCHAR2(15) NOT NULL
PTRECNAME6Character(15)VARCHAR2(15) NOT NULL
PTRECNAME7Character(15)VARCHAR2(15) NOT NULL
PTRECNAME8Character(15)VARCHAR2(15) NOT NULL
PTRECNAME9Character(15)VARCHAR2(15) NOT NULL
PTRECNAME10Character(15)VARCHAR2(15) NOT NULL
PTNUMKEYS1Number(3,0)SMALLINT NOT NULL
PTNUMKEYS2Number(3,0)SMALLINT NOT NULL
PTNUMKEYS3Number(3,0)SMALLINT NOT NULL
PTNUMKEYS4Number(3,0)SMALLINT NOT NULL
PTNUMKEYS5Number(3,0)SMALLINT NOT NULL
PTNUMKEYS6Number(3,0)SMALLINT NOT NULL
PTNUMKEYS7Number(3,0)SMALLINT NOT NULL
PTNUMKEYS8Number(3,0)SMALLINT NOT NULL
PTNUMKEYS9Number(3,0)SMALLINT NOT NULL
PTNUMKEYS10Number(3,0)SMALLINT NOT NULL
PTKEYCOL1Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL2Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL3Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL4Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL5Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL6Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL7Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL8Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL9Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL10Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL11Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL12Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL13Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL14Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL15Character(18)VARCHAR2(18) NOT NULL
PTKEYCOL16Character(18)VARCHAR2(18) NOT NULL
PTKEYVALUE1Character(150)VARCHAR2(150) NOT NULLObject Value 1
PTKEYVALUE2Character(150)VARCHAR2(150) NOT NULLObject Value 2
PTKEYVALUE3Character(150)VARCHAR2(150) NOT NULLObject Value 3
PTKEYVALUE4Character(150)VARCHAR2(150) NOT NULLObject Value 4
PTKEYVALUE5Character(150)VARCHAR2(150) NOT NULLObject Value 5
PTKEYVALUE6Character(150)VARCHAR2(150) NOT NULLObject Value 6
PTKEYVALUE7Character(150)VARCHAR2(150) NOT NULLObject Value 7
PTKEYVALUE8Character(150)VARCHAR2(150) NOT NULLObject Value 8
PTKEYVALUE9Character(150)VARCHAR2(150) NOT NULLObject Value 9
PTKEYVALUE10Character(150)VARCHAR2(150) NOT NULLObject Value 10
PTKEYVALUE11Character(150)VARCHAR2(150) NOT NULLObject Value 11
PTKEYVALUE12Character(150)VARCHAR2(150) NOT NULLObject Value 12
PTKEYVALUE13Character(150)VARCHAR2(150) NOT NULLObject Value 13
PTKEYVALUE14Character(150)VARCHAR2(150) NOT NULLObject Value 14
PTKEYVALUE15Character(150)VARCHAR2(150) NOT NULLObejct Value 15
PTKEYVALUE16Character(150)VARCHAR2(150) NOT NULLObject Value 16
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19