| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
PTUPG_SRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Record Name
|
| 2 |
PTUPG_SRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Record Type
|
| 3 |
PTUPG_SFLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Field Name
|
| 4 |
PTUPG_SFLDTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Type
|
| 5 |
PTUPG_SFLDLEN |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Length
|
| 6 |
PTUPG_SFLDDECPOS |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Decimal Position
|
| 7 |
PTUPG_SFLDNOTNULL |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Nullability
|
| 8 |
PTUPG_SFLDDEFREC |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Field Default Record Na
|
| 9 |
PTUPG_SFLDDEFFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Field Default Field Nam
|
| 10 |
PTUPG_SENCRYPT |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Encryption
|
| 11 |
PTUPG_TRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Record Name
|
| 12 |
PTUPG_TRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Record Type
|
| 13 |
PTUPG_TFLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Field Name
|
| 14 |
PTUPG_TFLDTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Type
|
| 15 |
PTUPG_TFLDLEN |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Length
|
| 16 |
PTUPG_TFLDDECPOS |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Decimal Position
|
| 17 |
PTUPG_TFLDNOTNULL |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Nullability
|
| 18 |
PTUPG_TFLDDEFREC |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Field Default Record Na
|
| 19 |
PTUPG_TFLDDEFFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Field Default Field Nam
|
| 20 |
PTUPG_TENCRYPT |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Encryption
|
| 21 |
PTUPG_ALTACT_A |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Add
|
| 22 |
PTUPG_ALTACT_D |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Delete
|
| 23 |
PTUPG_ALTACT_CT |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Change Field Type
|
| 24 |
PTUPG_ALTACT_CL |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Length
|
| 25 |
PTUPG_ALTACT_CD |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Decimal
|
| 26 |
PTUPG_ALTACT_CN |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Nullability
|
| 27 |
PTUPG_ALTACT_CDR |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Default Record
|
| 28 |
PTUPG_ALTACT_CDF |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Default Field
|
| 29 |
PTUPG_ALTACT_CEN |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Encryption Change
|
| 30 |
PTUPG_ALTACT_FR |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Rename
|