invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

SESSIONROWSCHANGED: Data Dictionary Rows Changed in Session

read only

  • Catálogo: DataDictionary
  • Esquema: Invantive
  • Label: Rows Changed in Session

Audit of rows changed in a session.

Solo puede recuperar datos.

Columnas de la Tabla

A continuación se muestran las columnas de la tabla SESSIONROWSCHANGED. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.

Name Tipo de Datos Label Required Marks Documentation
COLUMN_1 varchar2 Columna 1 Name of the first column being updated.
DURATION_MS double Duration Duration in milliseconds of the change.
ERROR_MESSAGE varchar2 Mensaje de Error Error message that occurred during executing the change.
EXECUTION_DATE_UTC datetime Fecha de Creación 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) Alias del Contenedor de Datos Data container alias.
PROVIDER_DATA_CONTAINER_ID varchar2(4000) ID del Contenedor de Datos Data container ID.
PROVIDER_DESCRIPTION varchar2(16000) Descripción del proveedor Provider description.
PROVIDER_INSTANCE_UID guid UID de instancia de proveedor Unique ID of the provider instance.
PROVIDER_NAME varchar2(240) Nombre del Proveedor Name of the provider.
PROVIDER_SHORT_NAME varchar2(240) Nombre abreviado del proveedor Provider short name.
SQL_REVERT varchar2 Revertir SQL SQL statement to revert all columns changed.
SUCCESSFUL char Succesful Indicator whether the change completed successfully.
TABLE_NAME varchar2(240) Nombre de la Tabla Name of the table or view.
TXN_ID int64 Identificación de la Transacción 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.

Teclas

Key Column Se refiere a 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.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: