Export Table Header (DB_INTERFACE_HDR)

Field

Description

TABLE_NAME**

Name of the table in TESite database that data will be exported from.

INTERFACE_TYPE*

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

TABLE_DESCR

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

TABLE_MAP

Not used. Default value is 'N'

FILE_NAME*

Store the file name of the extracted data. This field will be used only if the export process is to a file.

LOAD_SEQ*

Stores the sequence number of the table to be exported. Sequence numbers greater than zero flag entries for export.

UPDATE_OPTION

Not used.

VIEW_NAME

Stores the view name or table name where data is going into to. This field is ignored if data is going into a file source.

ROOT_ELEMENT

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

*Required Field

**Primary Key

2024 DATABASICS, Inc