| PeopleSoft Field Name |
Field Type |
Column Type |
Description |
| PTUPG_SRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Record Name
|
| PTUPG_SRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Record Type
|
| PTUPG_SFLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Field Name
|
| PTUPG_SFLDTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Type
|
| PTUPG_SFLDLEN |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Length
|
| PTUPG_SFLDDECPOS |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Decimal Position
|
| PTUPG_SFLDNOTNULL |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Nullability
|
| PTUPG_SFLDDEFREC |
Character(15) |
VARCHAR2(15) NOT NULL |
Source Field Default Record Na
|
| PTUPG_SFLDDEFFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Source Field Default Field Nam
|
| PTUPG_SENCRYPT |
Number(3,0) |
SMALLINT NOT NULL |
Source Field Encryption
|
| PTUPG_TRECNAME |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Record Name
|
| PTUPG_TRECTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Record Type
|
| PTUPG_TFLDNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Field Name
|
| PTUPG_TFLDTYPE |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Type
|
| PTUPG_TFLDLEN |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Length
|
| PTUPG_TFLDDECPOS |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Decimal Position
|
| PTUPG_TFLDNOTNULL |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Nullability
|
| PTUPG_TFLDDEFREC |
Character(15) |
VARCHAR2(15) NOT NULL |
Target Field Default Record Na
|
| PTUPG_TFLDDEFFLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Target Field Default Field Nam
|
| PTUPG_TENCRYPT |
Number(3,0) |
SMALLINT NOT NULL |
Target Field Encryption
|
| PTUPG_ALTACT_A |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Add
|
| PTUPG_ALTACT_D |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Delete
|
| PTUPG_ALTACT_CT |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Change Field Type
|
| PTUPG_ALTACT_CL |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Length
|
| PTUPG_ALTACT_CD |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Decimal
|
| PTUPG_ALTACT_CN |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Nullability
|
| PTUPG_ALTACT_CDR |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Default Record
|
| PTUPG_ALTACT_CDF |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Default Field
|
| PTUPG_ALTACT_CEN |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Encryption Change
|
| PTUPG_ALTACT_FR |
Number(3,0) |
SMALLINT NOT NULL |
Alter Action Field Rename
|