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