PTUNIRVWMORPTVW

index back

SELECT PTSESSIONID , PTPRESENCE , PTDIFFTYPE , COMPARETYPE , PTTYPENAME , OBJECTTYPE , PTKEYVALUE1 , PTKEYVALUE2 , PTKEYVALUE3 , PTKEYVALUE4 , PTKEYVALUE5 , PTKEYVALUE6 , PTKEYVALUE7 , PTKEYVALUE8 , PTKEYVALUE9 , PTKEYVALUE10 , PTKEYVALUE11 , PTKEYVALUE12 , PTKEYVALUE13 , PTKEYVALUE14 , PTKEYVALUE15 , PTKEYVALUE16 , PTFIELDNAME , PTLOCALVALTYPE , PTLOCALVALUE , PTREMOTEVALTYPE , PTREMOTEVALUE , SEQNO FROM PSCOMPOBJDIFF

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
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
PTFIELDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
PTLOCALVALTYPE Number(3,0) SMALLINT NOT NULL Local Type
PTLOCALVALUE Character(254) VARCHAR2(254) NOT NULL Source Value
PTREMOTEVALTYPE Number(3,0) SMALLINT NOT NULL Target Value
PTREMOTEVALUE Character(254) VARCHAR2(254) NOT NULL Target Value
SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
PTRef generated on 21-DEC-20