common.data_import_errors

Field Type Null Default Key Extra Comment
die_id int(11) NO PRI auto_increment Primary key
die_cus_id int(11) NO MUL Customer ID for the import error
die_cli_id int(11) NO MUL Client ID for the import error
die_dicmd_id int(11) NO MUL Foreign key
die_line_num int(11) NO Line number from the import file that contains the error
die_record_id varchar(50) YES MUL The record ID from the CSV file if available (e.g. Patient ID, Appointment ID, etc)
die_errors_only tinyint(1) NO 0 Indicates if the entry was from running the import only checking for errors (no records actually imported)
die_record_imported tinyint(1) NO 0 Indicates if the record was still imported into Azalea (or would’ve been)
die_error_message text YES The error message from the import process
die_created timestamp YES CURRENT_TIMESTAMP

References

Local Column References