Audits View

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

Contains detailed information on the made changes.

Dependencies

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.

Description  :  varchar (max 1 char), allows null: no

The column is reserved for system use only.

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 Text Feature.

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 Text Feature.

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.

UserName  :  varchar (max 78 chars), allows null: yes

The name of the user who made the changes.

See Also

Audits Table
History

Highlight search results