How To Modify Export Table Definitions

Tables and columns can be added, deleted or modified from the DB_INTERFACE_HDR and DB_INTERFACE_DTL tables. The following steps outline how to modify the export table definition:

1. Click on the Export Table Definition Link. The Setup Export Table Definition screen is displayed. The lists of tables that can be populated are listed.
2. Click the Table Name to modify the parameters used to load data into the specified table. The following fields can be modified:
   • File Name: make sure to include the file extension. No need to add the file path.
   • Import From: name of the table or view from which data originates.
   • Update Option: field identifies the way that data in the table will be updated. Choose one of the following options:
     • Full/Update/Insert: Marks all data in the table as inactive, then uploads new data into the table. This does not delete any data already loaded into the database.
     • Partial/Update/Insert: Does not modify any of the data already in the database, then uploads new data into the table.
     • Delete/Insert: Deletes all data in the table, then uploads new into the table.
3. Click the Columns link to define the columns that will be exported.
4. Click the Column Name link to modify the parameters for the specified column. The following fields can be modified:
   • The Retrieval Key is used to extract timesheet with a current batch number.
   • The Data Type field determines the type of data to be loaded into the field. (String, Integer, Date/Time, Number/Long)
   • 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 Tag Name field identifies the name of the column for XML
   • The Enable Order by field 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 exported.