PS_PTUALTRECFLDDAT Table
The following tables describes the fields in the PS_PTUALTRECFLDDAT table.
| Column | Description |
|---|---|
|
PTUPG_SRECNAME |
Source Record Name. |
|
PTUPG_SRECTYPE |
Source Record Type. |
|
PTUPG_SFLDNAME |
Source Record.Field Name. |
|
PTUPG_SFLDTYPE |
Source Record.Field Name and Type. (Platform independent-PeopleTools field type). |
|
PTUPG_SFLDLEN |
Source Record.Field Name, Type, and .Length. |
|
PTUPG_SFLDDECPOS |
Source Record.Field Name, Type, and Decimal Position. |
|
PTUPG_SFLDNOTNULL |
Source Record.Field Name, and Null ability. 0: Null 1: Not Null |
|
PTUPG_SFLDDEFREC |
Default Record Name. |
|
PTUPG_SFLDDEFFLD |
Constant (or) Default Record Name. Field Name. |
|
PTUPG_SENCRYPT |
(Applies only to Oracle databases using TDE.) Source Record.Field, Encryption. 0: No Encryption 1: Encryption |
|
PTUPG_TRECNAME |
Target Record Name. |
|
PTUPG_TRECTYPE |
Target Record, Record Type. |
|
PTUPG_TFLDNAME |
Target Record.Field Name |
|
PTUPG_TFLDTYPE |
Target Record.Field Name, and Type. (Platform independent-PeopleTools field type) |
|
PTUPG_TFLDLEN |
Target Record.Field Name, Type, and Length. |
|
PTUPG_TFLDDECPOS |
Source Record.Field Name, Type, and Decimal Position. |
|
PTUPG_TFLDNOTNULL |
Target Record.Field Name, and Null ability. 0: Null 1: Not Null |
|
PTUPG_TFLDDEFREC |
Default Record Name. |
|
PTUPG_TFLDDEFFLD |
Constant (or) Default Record Name. Field Name. |
|
PTUPG_TENCRYPT |
(Applies to Oracle databases using TDE.) Target Record Field .Encryption. 0: No Encryption 1: Encryption |
|
PTUPG_ALTACT_A |
Indicates whether the field is newly added or not. 0: Not an Added Field 1: Added Field (New) |
|
PTUPG_ALTACT_D |
Indicates whether the field is deleted or not. 0: Not a Deleted Field 1: Deleted Field |
|
PTUPG_ALTACT_CT |
Indicates whether the field type has changed. 0: No Change in Field Type 1: Change in Field Type |
|
PTUPG_ALTACT_CL |
Indicates whether the field length has changed. 0: No Change in Field Length 1: Change in Field Length |
|
PTUPG_ALTACT_CD |
Indicates whether the field decimal position has changed. 0: No Change in Field Decimal Position. 1: Change in Field Decimal Position. |
|
PTUPG_ALTACT_CN |
Indicates whether the field null ability has changed (Null/Not Null). 0: No Change in Null ability 1: Change in Null ability |
|
PTUPG_ALTACT_CDR |
Indicates whether the default record name has changed. 0: No Change in Default Record Name 1: Change in Default Record Name |
|
PTUPG_ALTACT_CDF |
Indicates whether the default field name has changed. 0: No Change in Default Field Name 1: Change in Default Field Name |
|
PTUPG_ALTACT_CEN |
(Applies only to Oracle databases using TDE.) Indicates a change in the field encryption. 0: No Change in Encryption 1: Change in Encryption |
|
PTUPG_ALTACT_FR |
Indicates whether a field has been renamed. 0: No Field Rename 1: Field Renamed |