Audit Trail

RPT_AuditTrail

ID

ID

bigint

(not null)

Auto-generated unique identifier for the log entry.

RPT_Users

UserID

UserID

nvarchar

(100) (null)

User ID (name of the user) who performed the activity.

RPT_AuditTrail

Operation

Operation

nvarchar

(50) (null)

The operation performed by the user. For example, Create, Update, Delete.

RPT_AuditTrail

Data

Data

varbinary

(max) (null)

The data that the user requested for the activity initiated.

RPT_AuditTrail

CreateDate

CreateDate

datetime

(not null)

RPT_AuditTrail

PageName

PageName

varchar

(50) (null)

The application page or component where this activity is performed. For example, Campaign, Global Uploader, and so on.

RPT_AuditTrail

EnterpriseId

EnterpriseId

int

(not null)

The unique identifier for the Enterprise.

RPT_AuditTrail

IsActive

IsActive

bit

(not null)

Denotes Active Entry and default is set to 1

RPT_AuditTrail

IsDeleted

IsDeleted

bit

(not null)

Denotes entry is soft deleted and default is set to 0

RPT_AuditTrail

TenantID

TenantID

int

(null)

The Tenant ID auto-generated by the application when a new tenant is created.