FileExports


Description

Report export tracking - Audit trail for exported reports and data files including export metadata, user tracking, and deletion management. This table maintains a complete history of report exports, file generation activities, and data extraction operations to support compliance auditing, data governance, and export activity monitoring.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
fileExportID int identity 4 √ null

Export primary key - Unique identifier for each file export operation
reportID int 4 null

Report reference - Links to the report that was exported
exportName varchar 200 null

Export file name - Name of the exported file
exportDate datetime 16,3 null

Export date - Date and time when the file was exported
exportBy int 4 null

Exported by user - UserID of the person who performed the export
deleteDate datetime 16,3 √ null

Deletion date - Date when the exported file was deleted
deleteBy int 4 √ null

Deleted by user - UserID of the person who deleted the exported file

Indexes

Constraint Name Type Sort Column(s)
PK_FileExports1 Primary key Asc fileExportID

Relationships

Close relationships within degrees of separation