Export Table Detail (DB_INTERFACE_DTL)

COL_NAME**

Stores the name of column to be exported.

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

PK_COLUMN*

A flag to identify a primary key column. If no data is provided from the source, the record will not be loaded to the TESite. Only one column is allowed to be a primary key. The column with this flag set to "Yes" will be used to retrieve data. Most of the time the Batch Number is used as a primary key.

Field values:
Y= Primary Key
N=Not a primary key

LENGTH_1*

The length of the column. For date/datetime field use any number.

LENGTH_2

Stores the precision for long/decimal data type. Ignore for other data types.

DATA_TYPE*

Stores the data type of the column.
Field values:
C=Character/String
D=Date/Datetime
L=Long/Decimal (with precision)
I=Integer

FK_TABLE

Not used.

FK_COL

Not used.

REQD_YN*

A flag to indicate if this column is required field.
Field Value:
Y=Required
N=Not Required

DFLT_VAL

Not used.

ALLOW_MODIFY*

Not used. Default value is Y.
Field Values:
Y=Yes
N=No

SEQ_NO*

Sequence Number of the column. If the sequence number is greater than zero, then it may be flagged for export. This sequence must coincide with the order of fields in the table or view from which the table is being exported.

FMT_TYPE

Not in use.

CRF_COLUMN

Not in use.

CRF_TABLE

Not in use.

TAG_NAME

A custom tag for the column name. If no value is provided, the column name will be used.

ELEMENT_ATTRIBUTE

Defines the element name of the primary key. If no value is provided, the table name will be used.

ENABLE_ORDER_BY

A flag to identify the order of the data.