ImportLog


Description

Data import audit log - Comprehensive audit trail for data import operations including source system mappings, import descriptions, and processing timestamps. This table tracks data migration activities, system integrations, and import operations to support data governance, troubleshooting, and compliance auditing for healthcare data management.

Columns

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

Import log primary key - Unique identifier for each import operation
iCentralID varchar 2147483647 √ null

iCentral identifier - Internal system identifier for the imported record
SungardID varchar 2147483647 √ null

Sungard system ID - External system identifier from Sungard source system
Datasource varchar 2147483647 √ null

Data source - Name or identifier of the source system or file
Description varchar 2147483647 √ null

Import description - Detailed description of the import operation and data
DateCreated datetime 16,3 √ null

Import date - Date and time when the import operation was performed
DeletedDate datetime 16,3 √ null

Deletion date - Date when this import log entry was soft deleted

Indexes

Constraint Name Type Sort Column(s)
PK_ImportLog Primary key Asc ID

Relationships

Close relationships within degrees of separation