PS_PTUALTRECDATA Table
The following table describes the fields in the PS_PTUALTRECDATA table.
| Column Name | Description |
|---|---|
|
PTUPG_SRECNAME |
Source Record Name. |
|
PTUPG_TRECNAME |
Target Record Name. |
|
PTUPG_STABNAME |
Source Table Name. |
|
PTUPG_TTABNAME |
Target Table Name. |
|
PTUPG_SRECTYPE |
Source Record’s Type. |
|
PTUPG_TRECTYPE |
Target Record’s Type. |
|
PTUPG_STMPTBLINST |
Temp Table Instances count for Source temp table. (Applies only to temporary tables). Default value is 0. |
|
PTUPG_TTMPTBLINST |
Temp Table Instances count for Target temp table. (Applies only to temporary tables’). Default value is 0. |
|
PTUPG_ALTACTION |
Indicates the Alter action: A: Add Record (New) D: Delete Record RR: Rename Record CR: Record Added. DR: Record Deleted RR: Record Renamed AR: Alter Record with Field changes, Index changes, and Trigger changes. NA: Not applicable, Record with only Trigger, Index, or both changes. TC: Record type changed between source and target. Source table is a non-table (SQL View, Dynamic View, Derived/Work table, and so on) and in the Target the table is an actual SQL table (SQL Table, Temporary Table). TD: Record type changed between source and target. |
|
PTUPG_IDXONLY |
Indicates whether changes are only to indexes. 0: Default 1: Only Index Changes |
|
PTUPG_TRGONLY |
Indicates whether changes are only to triggers. 0: Default 1: Only Trigger Changes |