PTIASPOBJDIFF

(SQL Table)
Index Back

Object Differences Table

This tables stores the object differences as a result of patching

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number
2 PTSESSIONID Character(36) VARCHAR2(36) NOT NULL Compare Session Id
3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
4 PTIASPSEQ Number(12,0) DECIMAL(12) NOT NULL Rework sequence
5 COMPARETYPE Number(5,0) INTEGER NOT NULL Compare Type
6 PTTYPENAME Character(30) VARCHAR2(30) NOT NULL Type Name
7 OBJECTTYPE Number(5,0) INTEGER NOT NULL Object Type
8 PTKEYVALUE1 Character(150) VARCHAR2(150) NOT NULL Object Value 1
9 PTKEYVALUE2 Character(150) VARCHAR2(150) NOT NULL Object Value 2
10 PTKEYVALUE3 Character(150) VARCHAR2(150) NOT NULL Object Value 3
11 PTKEYVALUE4 Character(150) VARCHAR2(150) NOT NULL Object Value 4
12 PTKEYVALUE5 Character(150) VARCHAR2(150) NOT NULL Object Value 5
13 PTKEYVALUE6 Character(150) VARCHAR2(150) NOT NULL Object Value 6
14 PTKEYVALUE7 Character(150) VARCHAR2(150) NOT NULL Object Value 7
15 PTKEYVALUE8 Character(150) VARCHAR2(150) NOT NULL Object Value 8
16 PTKEYVALUE9 Character(150) VARCHAR2(150) NOT NULL Object Value 9
17 PTKEYVALUE10 Character(150) VARCHAR2(150) NOT NULL Object Value 10
18 PTKEYVALUE11 Character(150) VARCHAR2(150) NOT NULL Object Value 11
19 PTKEYVALUE12 Character(150) VARCHAR2(150) NOT NULL Object Value 12
20 PTKEYVALUE13 Character(150) VARCHAR2(150) NOT NULL Object Value 13
21 PTKEYVALUE14 Character(150) VARCHAR2(150) NOT NULL Object Value 14
22 PTKEYVALUE15 Character(150) VARCHAR2(150) NOT NULL Obejct Value 15
23 PTKEYVALUE16 Character(150) VARCHAR2(150) NOT NULL Object Value 16
24 PTFIELDNAME Character(30) VARCHAR2(30) NOT NULL Field Name
25 PTLOCALVALUE Character(254) VARCHAR2(254) NOT NULL Local Value
26 PTLOCALVALTYPE Number(3,0) SMALLINT NOT NULL Local Type
27 PTREMOTEVALUE Character(254) VARCHAR2(254) NOT NULL Remote Value
28 PTREMOTEVALTYPE Number(3,0) SMALLINT NOT NULL Remote Type