- DarkLight
Audit Trail
- DarkLight
Source Table | Column Name | Display Name | Data Type | Description | Platform |
---|---|---|---|---|---|
RPT_AuditTrail | ID | ID | bigint (not null) | Auto-generated unique identifier for the log entry. | All |
RPT_Users | UserID | UserID | nvarchar (100) (null) | User ID (name of the user) who performed the activity. | All |
RPT_AuditTrail | Operation | Operation | nvarchar (50) (null) | The operation performed by the user. For example, Create, Update, Delete. | All |
RPT_AuditTrail | Data | Data | varbinary (max) (null) | The data that the user requested for the activity initiated. | All |
RPT_AuditTrail | CreateDate | CreateDate | datetime (not null) | The date and time the application created this log entry. | All |
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. | All |
RPT_AuditTrail | EnterpriseId | EnterpriseId | int (not null) | The unique identifier for the Enterprise. | All |
RPT_AuditTrail | IsActive | IsActive | bit (not null) | Denotes Active Entry and default is set to 1 | All |
RPT_AuditTrail | IsDeleted | IsDeleted | bit (not null) | Denotes entry is soft deleted and default is set to 0 | All |
RPT_AuditTrail | TenantID | TenantID | int (null) | The Tenant ID auto-generated by the application when a new tenant is created. | All |
RPT_AuditTrail | SubTenantID | SubTenantID | int (null) | The Sub Tenant ID autogenerated by the application when a new tenant is created. | All |