PeopleSoft Field Name |
Field Type |
Column Type |
Description |
PTUPG_SRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Record Name
|
PTUPG_TRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Record Name
|
PTUPG_STABNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Table Name
|
PTUPG_TTABNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Table Name
|
PTUPG_SRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Record Type
|
PTUPG_TRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Record Type
|
PTUPG_STMPTBLINST |
Number(3,0) |
SMALLINT NOT NULL |
Source Temp Table Instance
|
PTUPG_STMPDEDCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Dedicated Count
|
PTUPG_STMPGAPCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Gap Count
|
PTUPG_STMPOPTCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Optional Count
|
PTUPG_TTMPTBLINST |
Number(3,0) |
SMALLINT NOT NULL |
Target Temp Table Instance
|
PTUPG_TTMPDEDCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Dedicated Count
|
PTUPG_TTMPGAPCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Gap Count
|
PTUPG_TTMPOPTCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Optional Count
|
PTUPG_ALTACTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Alter Action
|
PTUPG_IDXONLY |
Number(3,0) |
SMALLINT NOT NULL |
Index only changes
|
PTUPG_TRGONLY |
Number(3,0) |
SMALLINT NOT NULL |
Trigger only changes
|