invantive documentation
Invantive SupportforenAnmelden / Eintragen

AUDITEVENTS: Data Dictionary Audit Events

insert

  • Katalog: DataDictionary
  • Schema: Invantive
  • Label: Audit Events

Application-specific events for billing, monitoring and analysis.

Mit insert können Daten abgerufen und geändert werden.

Tabellenspalten

Die Spalten der Tabelle AUDITEVENTS sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp Label Required Marks Documentation
APPLICATION_NAME varchar2(240) Anwendungsname Application name.
APPLICATION_USER varchar2(240) Anwendungsbenutzer Application user.
BILLING_ID varchar2 Rechnungs-ID ID for billing.
BILLING_POOL_IDENTITY_ID varchar2 Abrechnungspool-Identitäts-ID Pool identity ID for billing.
BILLING_REFERENCE varchar2 Rechnungsreferenz Reference for billing, such as your cost centers.
DATA_CONTAINER_ID varchar2 Datenkontainer ID ID of the data container.
DIMENSION10_NAME varchar2 Dimension 10 Name Name of dimension 10.
DIMENSION10_VALUE varchar2 Dimension 10 Wert Value of dimension 10.
DIMENSION11_NAME varchar2 Dimension 11 Name Name of dimension 11.
DIMENSION11_VALUE varchar2 Dimension 11 Wert Value of dimension 11.
DIMENSION12_NAME varchar2 Dimension 12 Name Name of dimension 12.
DIMENSION12_VALUE varchar2 Dimension 12 Wert Value of dimension 12.
DIMENSION13_NAME varchar2 Dimension 13 Name Name of dimension 13.
DIMENSION13_VALUE varchar2 Dimension 13 Wert Value of dimension 13.
DIMENSION14_NAME varchar2 Dimension 14 Name Name of dimension 14.
DIMENSION14_VALUE varchar2 Dimension 14 Wert Value of dimension 14.
DIMENSION15_NAME varchar2 Dimension 15 Name Name of dimension 15.
DIMENSION15_VALUE varchar2 Dimension 15 Wert Value of dimension 15.
DIMENSION16_NAME varchar2 Dimension 16 Name Name of dimension 16.
DIMENSION16_VALUE varchar2 Dimension 16 Wert Value of dimension 16.
DIMENSION17_NAME varchar2 Dimension 17 Name Name of dimension 17.
DIMENSION17_VALUE varchar2 Dimension 17 Wert Value of dimension 17.
DIMENSION18_NAME varchar2 Dimension 18 Name Name of dimension 18.
DIMENSION18_VALUE varchar2 Dimension 18 Wert Value of dimension 18.
DIMENSION19_NAME varchar2 Dimension 19 Name Name of dimension 19.
DIMENSION19_VALUE varchar2 Dimension 19 Wert Value of dimension 19.
DIMENSION1_NAME varchar2 Dimension 1 Name Name of dimension 1.
DIMENSION1_VALUE varchar2 Dimension 1 Wert Value of dimension 1.
DIMENSION20_NAME varchar2 Dimension 20 Name Name of dimension 20.
DIMENSION20_VALUE varchar2 Dimension 20 Wert Value of dimension 20.
DIMENSION2_NAME varchar2 Dimension 2 Name Name of dimension 2.
DIMENSION2_VALUE varchar2 Dimension 2 Wert Value of dimension 2.
DIMENSION3_NAME varchar2 Dimension 3 Name Name of dimension 3.
DIMENSION3_VALUE varchar2 Dimension 3 Wert Value of dimension 3.
DIMENSION4_NAME varchar2 Dimension 4 Name Name of dimension 4.
DIMENSION4_VALUE varchar2 Dimension 4 Wert Value of dimension 4.
DIMENSION5_NAME varchar2 Dimension 5 Name Name of dimension 5.
DIMENSION5_VALUE varchar2 Dimension 5 Wert Value of dimension 5.
DIMENSION6_NAME varchar2 Dimension 6 Name Name of dimension 6.
DIMENSION6_VALUE varchar2 Dimension 6 Wert Value of dimension 6.
DIMENSION7_NAME varchar2 Dimension 7 Name Name of dimension 7.
DIMENSION7_VALUE varchar2 Dimension 7 Wert Value of dimension 7.
DIMENSION8_NAME varchar2 Dimension 8 Name Name of dimension 8.
DIMENSION8_VALUE varchar2 Dimension 8 Wert Value of dimension 8.
DIMENSION9_NAME varchar2 Dimension 9 Name Name of dimension 9.
DIMENSION9_VALUE varchar2 Dimension 9 Wert Value of dimension 9.
GUI_ACTION varchar2(240) GUI-Aktion Action performed within the user interface.
GUI_IP_ADDRESS_EXTERNAL varchar2(240) GUI Externe IP-Adresse External IP address of the GUI application.
GUI_IP_ADDRESS_INTERNAL varchar2(240) GUI interne IP-Adresse Internal IP address of the GUI application.
GUI_MACHINE varchar2(240) GUI Computer Name of the machine running the GUI application.
GUI_MODULE varchar2(240) GUI-Modul Module within the GUI application currently running.
GUI_MODULE_NAME varchar2(240) Name des GUI-Moduls Module within the GUI application currently running.
GUI_MODULE_VERSION varchar2(240) GUI-Modul Version Version of module within the GUI application currently running.
GUI_OS_USER varchar2(240) GUI-OS-Benutzer OS user running the GUI application.
IIID varchar2 IIID Invantive installation ID.
IS_APPLICATION_MANAGED char Anwendungsverwaltet Indicator whether event was managed by the application.
IS_MONITORING char Ist Überwachung Indicator whether event must be forwarded for monitoring.
IUID varchar2 IUID Invantive user ID.
LAST_LOGON_TIME datetime Anmelde-Zeit Date at which the last logon found place.
LAST_NATURAL_KEY varchar2(4000) Letzter natürlicher Schlüssel Last seen natural key of business object.
LICENSE_CONTRACT_CODE varchar2 Lizenzvertragscode License contract code.
LICENSE_KEY_IDENTIFIER varchar2 ID des Lizenzschlüssels License key identifier.
LOGGING_LEVEL varchar2(30) Protokollierungsstufe Type of logging message.
MANAGED_THREAD_ID int32 Verwaltete Thread-ID Managed thread ID.
MESSAGE_CODE varchar2(30) Meldung-Code Code of the message.May not start with 'itgen' or 'bubs'.
MESSAGE_UID guid Beitrags-UID Specific UID for easy recognition.
METRIC_NAME varchar2 Metrikname Name of monitoring metric.
METRIC_VALUE varchar2 Metrischer Wert Value of monitoring metric.
OCCURRENCE_DATE_UTC datetime Ereignisdatum (UTC) UTC date at which the event occurred.
PARAMETER_VALUES varchar2(4000) Parameterwerte Parameter values.
PARTITION varchar2(240) Partition Specific partition on which the event was registered.
POOL_IDENTITY varchar2(60) Pool-Identität Pool identity.
PROVIDER_INSTANCE_UID guid Treiber Instanz-UID Unique ID of the provider instance.
PROVIDER_NAME varchar2 Provider Name of provider.
REFERENCE_KEY varchar2 Referenzschlüssel Key of the referenced business object.
REFERENCE_TABLE_CODE varchar2 Referenztabellen-Code Table code of the referenced business object.
REQUEST_ID varchar2(60) ID der Anfrage Request ID.
SERVICE_NAME varchar2 Dienstname Name of service.
SERVICE_STATE varchar2 Dienstzustand Status of service (production, acceptance, test).
SESSION_ID varchar2(240) Session-ID ID of the session.
SHOWN_TO_USER char Dem Benutzer angezeigt Indicator whether event was shown to the user.
SQL_STATEMENT varchar2 SQL Anweisung SQL statement.
TASK_ID int32 Aufgaben-ID Task ID.
UNIT_OF_MEASURE varchar2 Maßeinheit Unit of Measure of value of monitoring metric.
USER_MESSAGE varchar2 Benutzermeldung Text of the message without message code.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: