Database – Data Import Entity (data_import_entity)
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 | |
import_id | int(11) | The id of the import | ||
entity_id | int(11) | The ID for the Odata entity for the import, such as LoanSetup or Customers. | ||
lastUpdated | timestamp | The last date and time when the table was updated. | ||
row | int(11) | |||
status | varchar(35) | Status code 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 | Unused | |
stats_new | int(11) | Number of new entities from the import | ||
stats_upd | int(11) | Number of updated entities from the import | ||
stats_del | int(11) | Number of deleted entities from the import | ||
stats_err | int(11) | Number of rows with errors | ||
by_pass_warnings | tinyint(4) | Whether or not to bypass system 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 | ||
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) | |||
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. |