ImportDetails


Description

Data import tracking details managing field-level import information and audit trails for data migration and integration operations. This table tracks specific field imports, source table mappings, import timestamps, and user accountability for data import processes, supporting data governance, troubleshooting, and audit requirements for healthcare data management and system integration workflows.

Columns

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

Primary key - Unique identifier for each import detail record
ImportedFieldId int 4 √ null

Imported field reference - Links to the specific field that was imported
TableName varchar 100 √ null

Target table name - Name of the database table where data was imported
ImportedDate datetime 16,3 √ null

Import timestamp - Date and time when the field data was imported
ImportedBy int 4 √ null

Import user reference - Links to AccessUser table for the user who performed the import
FkImportFileID int 4 √ null

Import file reference - Links to the source import file or batch
FkRowID varchar 50 √ null

Source row identifier - Identifier of the source row from the import file

Relationships

Close relationships within degrees of separation