BulkDeletionData Table

The BulkDeletionData table stores objects that have been marked for bulk deletion.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for BulkDeletionData table

Database Column

Details

BulkDeletionDataID

Type: integer. Key. Generated ID

Auto-increment primary key for this table.

ObjectToBeDeletedID

Type: integer. Key

Foreign key ID of the object marked for deletion.

ObjectTypeID

Type: integer. Key

The type of object marked for deletion (e.g., Asset, PurchaseOrder, etc.).Foreign key ID of the object BulkDeletionObjectType

DateAdded

Type: datetime. Key. Nullable

Date and time when the object was marked for deletion.

MarkedBy

Type: text (max 128 characters). Nullable

ID of the compliance operator context when marked for deletion.

DateDeleted

Type: datetime. Nullable

Date and time when the object was deleted.