Audits Table

Applies to QAComplete 14.5, last modified on August 06, 2024

Description

The audits table stores the history of changes made by users.

Columns

The table contains the following columns:

DateCreated  :  datetime, allows null: no, default: Current date and time

The date and time the change was made.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

EntityCode  :  varchar (max 100 chars), allows null: no

The code of the module where the change was made.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FKId  :  int, allows null: no

The unique numeric identifier of the changed item.

NewValue  :  varchar (max 1000 chars), allows null: yes

The new value.

This column may correspond to a field that is available for rich editing.

OldValue  :  varchar (max 1000 chars), allows null: yes

The original value that was changed.

This column may correspond to a field that is available for rich editing.

ProjId  :  int, allows null: no

The ID of the project that contains the item.

Title  :  varchar (max 100 chars), allows null: no

The description of the change.

UpdateUserId  :  int, allows null: no

The ID of the user who made the change.

See Also

Audits View
DbLogs Table
History

Highlight search results