invantive documentation
Invantive Support ForumsLog In / Sign Up

SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session

read only

  • Catalog: DataDictionary
  • Schema: Invantive
  • Label: Rows Changed in Session

Audit of rows changed in a session.

Can only retrieve data.

Table Columns

The columns of the table SESSIONROWSCHANGED are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

Name Data Type Label Required Marks Documentation
COLUMN_1 varchar2 Column 1 Name of the first column being updated.
DURATION_MS double Duration Duration in milliseconds of the change.
ERROR_MESSAGE varchar2 Error Message Error message that occurred during executing the change.
EXECUTION_DATE_UTC datetime Creation Date Date at which the change was executed (UTC).
ID int32 ID Unique ID of the change.
NEW_VALUE_TEXT_1 varchar2 New Value 1 New value of the first column.
OLD_VALUE_TEXT_1 varchar2 Old Value 1 Old value of the first column.
PARTITION varchar2(30) Partition Specific partition on which the change was executed.
PROVIDER_DATA_CONTAINER_ALIAS varchar2(4000) Data Container Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Data Container ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provider Description Provider description.
PROVIDER_INSTANCE_UID guid Provider Instance UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Provider Name Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Short Name Provider short name.
SQL_REVERT varchar2 SQL Revert SQL statement to revert all columns changed.
SUCCESSFUL char Succesful Indicator whether the change completed successfully.
TABLE_NAME varchar2(240) Table Name Name of the table or view.
TXN_ID int64 Transaction ID Transaction ID of the change.
UNIQUE_KEY_1 varchar2 Unique Key 1 Value of the first column of the unique key.
UNIQUE_KEY_2 varchar2 Unique Key 2 Value of the second column of the unique key.
UNIQUE_KEY_3 varchar2 Unique Key 3 Value of the third column of the unique key.
UNIQUE_KEY_4 varchar2 Unique Key 4 Value of the fourth column of the unique key.
UNIQUE_KEY_5 varchar2 Unique Key 5 Value of the fifth column of the unique key.
UNIQUE_KEY_6 varchar2 Unique Key 6 Value of the sixth column of the unique key.

Keys

Key Column Refers to Kind Description
SESSIONROWSCHANGED_PROVIDER_INSTANCE_UID_SYSTEMDATACONTAINERS_txt PROVIDER_INSTANCE_UID SYSTEMDATACONTAINERS.PROVIDER_INSTANCE_UID Textual The data container of the change, while that data container is active; the history of changes outlives a data container that was closed.

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: