Database – Data Import Entity (data_import_entity)
Description
This holds record information for various data import entities.
Column | Data Type | Column Info | Value Notes | Other |
id | int(10) | The id of the entity | ||
entity | varchar(255) | The name of the entity for which data was/is being imported | Entity.LoanRuleAppliedSettings | |
status | varchar(35) | The status of the entity. | ||
description | varchar(100) | The description of the entity instance | ||
file_name | varchar(255) | Name of the file being imported | ||
reverse_file_name | varchar(100) | Name of the reverse import file | ||
rejection_file | varchar(255) | URL for the rejection file | ||
cover_sheet | varchar(255) | URL for the cover sheet | ||
deltas_file | varchar(255) | |||
original_new | int(11) | |||
original_upd | int(11) | |||
original_del | int(11) | |||
stats_new | int(11) | |||
stats_upd | int(11) | |||
stats_del | int(11) | |||
stats_err | int(11) | |||
by_pass_warnings | tinyint(4) | Whether to bypass warnings. | 1 - yes, 0 - no | |
skip_calc | tinyint(4) | Whether or not to bypass running the calculator | 1 - yes, 0 - no | |
errors | mediumtext | List of error codes | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
created | datetime | Timestamp of when the entity was created | ||
created_by | int(11) | ID of agent user that created the entity | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
charged | tinyint(4) | Whether or not to charge for the import | 1 - yes, 0 - no | |
num_rows | int(10) | The number of rows in the import | ||
total_blocks | int(10) | Total number of cells in the import. | ||
verified_blocks | int(10) | Number of verified cells in the import. | ||
imported_blocks | int(11) | Number of imported cells in the import | ||
validation_type | varchar(20) | Whether the import is set to file or line validation | ||
import_progression | varchar(20) | Whether the import will use manual or automatic progression | ||
upload_date | datetime | When the import file was was uploaded. | ||
validate_date | datetime | When the import was validated. | ||
import_date | datetime | When the file was imported. | ||
verify_date | datetime | When the import file was verified. | ||
complete_date | datetime | When the import was completed. |