Import Table Header (DB_INTERFACE_HDR)

TABLE_NAME**

Name of the table in TESite database that data will be loaded into.

INTERFACE_TYPE*

A flag used to identify if a table is used for import or export.
Field values:
I= Import table

TABLE_DESCR

This field is used to describe the purpose of the table.

TABLE_MAP

Not used. Default value is 'N'

FILE_NAME*

Stores the name of the file from where data is coming from. Once the file has been loaded two files will be created each into two separate folders. The first folder is named Loaded, which will create a file by this same filename that contains all the successfully loaded data. The second folder is named Exception, which will create a file by this same filename that contains all the unsuccessfully loaded data.

LOAD_SEQ*

Stores the sequence number of the table according to the parent/child relationship in the TESite database. For example, before loading Employee information, it is important to load the Department of the employee into the system. Tables with LOAD_SEQ number less than one are ignored during import.

UPDATE_OPTION

This field is an option for update, append or delete when loading data.
Field values:
A=Full/Update/Insert - inactivate all records in the table and only activate records that are loaded during the import process.
U=Partial/Update/Insert - insert and activate the records that are loaded during the import process. Leave existing data as active.
D=Delete/Insert - delete all records in the table before inserting all recordsinto the table.
Make sure there is no data dependency on this table.

VIEW_NAME

Stores the view name or table name where data is coming from. This field is ignored if data is coming from a file source.

ROOT_ELEMENT

Store the alias to the XML root elements. If no value is provided, the table name will be the same as the value of the root element.