invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session

read only

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

Audit of rows changed in a session.

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel SESSIONROWSCHANGED worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
COLUMN_1 varchar2 Kolom 1 Name of the first column being updated.
DURATION_MS double Duration Duration in milliseconds of the change.
ERROR_MESSAGE varchar2 Foutmelding Error message that occurred during executing the change.
EXECUTION_DATE_UTC datetime Aanmaakdatum 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) Datacontainer Alias Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) Datacontainer ID Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Provideromschrijving Provider description.
PROVIDER_INSTANCE_UID guid Providerinstantie UID Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Providernaam Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Provider Korte Naam Provider short name.
SQL_REVERT varchar2 SQL Terugdraaien SQL statement to revert all columns changed.
SUCCESSFUL char Succesful Indicator whether the change completed successfully.
TABLE_NAME varchar2(240) Tabelnaam Name of the table or view.
TXN_ID int64 Transactie 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.

Toetsen

Key Column Verwijst naar 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

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: