Promote

Structures - Data Sub Tables H

Structures - Data Sub Tables V

Use this page to Add Sub Tables.

To access this page:

  1. Click Configuration > Structure Data.
  2. Click the Tables icon for a structure.
  3. Click the Sub Tables icon for a table.

Field

Description

DATA SOURCE ID

Displays the data source that contains the child table.

TABLE

Displays the name of the child table.

Columns

Click to view the Structures - Data Table Columns page to view and configure columns of the child table.

Sub Tables

Click to add a child table of a child table.

PASS THROUGH

If checked, the Compare and Sync check boxes on the Structures - Data Table Columns page are unchecked for all columns associated with the table. Columns needed to identify the record must be manually set to Compare and Sync. Additionally, during the compare process, a table identified as a Pass Through Though table is by default not added to the queue for transport.

If unchecked, the Compare and Sync check boxes on the Structures - Data Table Columns page are checked for all columns associated with the table.

NOTE: If a table is selected as being a "Pass Through" table, it means that the table is required only to support the selection of records at a lower level. It is recommended that a few fields are selected in order to identify the record when the package is compared for transport.

Structures - Data Sub Tables V

Structures - Data Sub Tables H

Field

Description

Database

Displays the data source that contains the child table.

Table

Displays the name of the child table.

Pass Through

If checked, the Compare and Sync check boxes on the Structures - Data Table Columns page are unchecked for all columns associated with the table. Columns needed to identify the record must be manually set to Compare and Sync. Additionally, during the compare process, a table identified as a Pass Through Though table is by default not added to the queue for transport.

If unchecked, the Compare and Sync check boxes on the Structures - Data Table Columns page are checked for all columns associated with the table.

NOTE: If a table is selected as being a "Pass Through" table, it means that the table is required only to support the selection of records at a lower level. It is recommended that a few fields are selected in order to identify the record when the package is compared for transport.

Where Clause

This field is not used.

Columns

Click to view the Structures - Data Table Columns page to view and configure columns of the child table.

Sub Tables

Click to add a child table of a child table.