# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
PTUPG_SRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Record Name
|
2 |
PTUPG_TRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Record Name
|
3 |
PTUPG_STABNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Table Name
|
4 |
PTUPG_TTABNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Table Name
|
5 |
PTUPG_SRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Record Type
|
6 |
PTUPG_TRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Record Type
|
7 |
PTUPG_STMPTBLINST |
Number(3,0) |
SMALLINT NOT NULL |
Source Temp Table Instance
|
8 |
PTUPG_STMPDEDCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Dedicated Count
|
9 |
PTUPG_STMPGAPCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Gap Count
|
10 |
PTUPG_STMPOPTCNT |
Number(3,0) |
SMALLINT NOT NULL |
Src Tmp Tbl Optional Count
|
11 |
PTUPG_TTMPTBLINST |
Number(3,0) |
SMALLINT NOT NULL |
Target Temp Table Instance
|
12 |
PTUPG_TTMPDEDCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Dedicated Count
|
13 |
PTUPG_TTMPGAPCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Gap Count
|
14 |
PTUPG_TTMPOPTCNT |
Number(3,0) |
SMALLINT NOT NULL |
Tgt Tmp Tbl Optional Count
|
15 |
PTUPG_ALTACTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Alter Action
|
16 |
PTUPG_IDXONLY |
Number(3,0) |
SMALLINT NOT NULL |
Index only changes
|
17 |
PTUPG_TRGONLY |
Number(3,0) |
SMALLINT NOT NULL |
Trigger only changes
|