How To Modify Import Table Definitions

Tables and columns can be added, deleted or modified in the DB_INTERFACE_HDR and DB_INTERFACE_DTL tables at any time. The following are the steps on how to modify the Import Table Definition in the Profiles module.

1. Click on the Import Table Definition Link. The list of tables that can be populated are listed.
2. Click the link under the table name column to modify the parameters to load data into the selected table. The following fields can be modified:
   • File Name: The name of the file were the data is stored. Make sure to include the file extension. No need to add the file path. This field will be ignored if the source of the data is not a file.
   • Import From: Name of the table or view from which data is coming from. This field will be ignored if the source of the data is file.
   • Update Option: field identifies the way that data in the table will be updated. Choose one of the following options (Please refer to the field UPDATE_OPTION in section Import Table Header for the definition of this value):
     • Full/Update/Insert: Marks all data in the table as inactive, then uploads new data into the table. The new data is marked active.
     • Partial/Update/Insert: Leaves all data in the table marked active, then uploads new data into the table. The new data is marked active.
     • Delete/Insert: Deletes all data in the table, then uploads new data into the table.
   • Description: The description of the table. This field is not required.
   • Root Element: Alternate name for the table name to be used in XML import.
3. Click Columns link to define the columns that will be loaded.
4. Click the Column Name link to modify the parameters for the specified column. . The following fields can be modified:
   • The Modify field determines whether the data in the field can be modified.
   • The Default field determines the default value to be entered in the specified field if no data is loaded for this field.
   • The PK field determines whether or not the field is a primary key for the table.
   • The Data Type field determines the type of data to be loaded into the field (String, Integer, Date/Time, Number/Long).
   • The Required field determines whether the field is required in the table.
   • The Length field determines the maximum length of data to be loaded into the field.
   • The Precision field is required if the data type is Numeric.
   • The FK Table provides the table name to which data in this field is referring.
   • The FK Column field provides the column name in the FK table to which data in this field is referring
   • The Tag Name field identifies the name of the column for XML
   • The Enable Order by field is not in use.
   • The Element field identifies the Element name of the table for XML
5. Click the Sequence button to determine the order in which the fields in the table will be loaded.