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.


How did we do?


Powered by HelpDocs (opens in a new tab)