Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EndTime | Unknown | 0 | null |
|
|
End timestamp - When the import operation completed |
||
| ErrorCount | Unknown | 0 | null |
|
|
Error count - Total number of errors encountered during import |
||
| ErrorLog | Unknown | 0 | null |
|
|
Error log - Detailed log of errors encountered during import |
||
| PkID | int identity | 4 | √ | null |
|
|
Primary key identifier - Primary key value for the imported record |
|
| ImportedFieldId | int | 4 | √ | null |
|
|
Field identifier - Reference to specific field or column being imported |
|
| ImportedDate | datetime | 16,3 | √ | null |
|
|
Import timestamp - When the import operation was completed |
|
| ImportedBy | int | 4 | √ | null |
|
|
Import user - User who initiated or performed the import operation |
|
| FkImportFileID | int | 4 | √ | null |
|
|
Import file reference - Foreign key linking to the source import file |
|
| FkRowID | varchar | 50 | √ | null |
|
|
Row reference - Foreign key linking to specific row in source data |
|
| ID | Unknown | 0 | null |
|
|
Primary key - Unique identifier for each import operation, auto-incrementing integer |
||
| ImportJobId | Unknown | 0 | null |
|
|
Import job reference - Reference to the parent import job |
||
| ImportStatus | Unknown | 0 | null |
|
|
Import status - Current status of the import operation |
||
| RecordsProcessed | Unknown | 0 | null |
|
|
Records processed - Number of records successfully processed |
||
| RecordsSkipped | Unknown | 0 | null |
|
|
Records skipped - Number of records skipped due to errors or validation failures |
||
| StartTime | Unknown | 0 | null |
|
|
Start timestamp - When the import operation began |
||
| TableName | varchar | 100 | √ | null |
|
|
Target table - Database table being populated by the import |