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)

Encoded information about the entity being imported

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)

total_blocks

int(10)

verified_blocks

int(10)

imported_blocks

int(11)


How did we do?


Powered by HelpDocs (opens in a new tab)