Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Description | varchar | 2147483647 | √ | null |
|
|
File description - Description of the import file contents |
|
| ErrorCount | Unknown | 0 | null |
|
|
Error count - Number of records that failed processing |
||
| FileID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each import file |
|
| FileName | varchar | 500 | √ | null |
|
|
File name - System file name for the uploaded import file |
|
| FilePath | Unknown | 0 | null |
|
|
File path - Path where the file is stored |
||
| FileSize | Unknown | 0 | null |
|
|
File size - Size of the import file in bytes |
||
| OriginalFileName | varchar | 500 | √ | null |
|
|
Original file name - Original name of the file before upload |
|
| IsTemp | bit | 1 | √ | null |
|
|
Temporary flag - Boolean indicating if this is a temporary file |
|
| ProcessedDate | Unknown | 0 | null |
|
|
Processed date - Date when the file was processed |
||
| ProcessingStatus | Unknown | 0 | null |
|
|
Processing status - Current status of file processing |
||
| ReceivedDate | Unknown | 0 | null |
|
|
Received date - Date when the file was received |
||
| RecordCount | Unknown | 0 | null |
|
|
Record count - Number of records in the file |
||
| Status | varchar | 20 | √ | null |
|
|
File status - Status of the import file (Uploaded, Processing, Complete, etc.) |
|
| SuccessCount | Unknown | 0 | null |
|
|
Success count - Number of records successfully processed |
||
| UploadedDate | datetime | 16,3 | √ | null |
|
|
Upload date - Date when the file was uploaded |
|
| UploadedBy | int | 4 | √ | null |
|
|
Uploaded by user - UserID of the person who uploaded the file |
Relationships
Close relationships within degrees of separation
