Import Table Detail (DB_INTERFACE_DTL)

COL_NAME**

Stores the name of column to be imported.

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

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 system.
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

Define 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

Foreign key table. Incoming data will be validated against the data in this table. If no data is specified in this field, there will be no checking for foreign key dependencies.

FK_COL

Foreign Key Column.

REQD_YN*

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

DFLT_VAL

Stores the default value. If the column is a required field and if no data is provided from the incoming source, this default value will be used as the value of the column. Otherwise this field will be ignored.

ALLOW_MODIFY*

A flag to identify if a data already in the system is allowed to change. If the data is loaded for the first time this flag has no effect.
Field Values:
Y=Yes
N=No

SEQ_NO*

Sequence Number of the column. The sequence number is greater than zero and expects a value from the source data. If no data is provided and the column is not a primary key, the default value will be the value of the field. This sequence must coincide with the order of fields in the file, table, or view from which the table is being loaded.

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.