ENTITY_AUDIT

This table displays audit information of actions and changes made to entities (objects) by a user or process.

Important! Spectrum Auditing Schema (LOFTAUDIT) tables are read-only. Modifications to these tables could cause errors and prevent Spectrum from functioning.

Note: If you are using Loftware Spectrum Cloud, Loftware Cloud Operations may have assigned unique names for the reporting schema and the auditing schema for your Spectrum instance. Contact Loftware Cloud Operations for details.

Note: All timestamps are relative to the time on the database server.

Column Name	Type	Description
ID	Number	The internal identification number of this audit detail. Key: Primary Key
ACTION	String	The action that caused an audit entry. CREATE UPDATE DELETE
ACTION_TIME	Timestamp	The date and time the action was performed on the object.
AUDIT_TIME	Timestamp	The date and time the audit was recorded.
CONTEXT	String	Not used.
ENTITY_ID	Number	The ID number of the audited object.
ENTITY_NAME	String	The cased name of the audited object. This may contain version information if appropriate.
ENTITY_TYPE	String	The type of object being audited.
FOLDER_NAME	String	The fully-qualified path of the folder that contains the audited object. Key: Foreign Key, join with R_FOLDERS.FULL_NAME
FOLDER_ID	Number	The ID of the parent folder where the object exists.
JVM_ID	Number	The JVM that the changes were performed and audited on. In a single JVM environment this is 0.
SUB_ACTION	String	Not used.
TRANSACTION_ID	Number	An identifier that ties together multiple audit entries that occur within the same transaction. Note: This ID is not guaranteed to be unique within the audit table.
USER_ID	Number	The ID of the user that performed the action.
USER_NAME	String	The (cased) name of the user that performed the action in the format <username>@<domain>.
XML_DIFFS	XML	The XML data containing the values for fields that have changed.