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.


How did we do?


Powered by HelpDocs (opens in a new tab)