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 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |