Common

System Types Join Field

Use this page to Add Table Join Relationships.

To access this page:

  1. Click Common > System Types in Navigation pane.

  2. Click Tables icon for a System Type.

  3. Click Joins icon for System Type table.
  4. Click Fields for join.

NOTE: Excel Integration has been enabled on this page. Refer to Use Excel Integration for more information.

Field

Description

PRIORITY

Displays the order in which the join occurs.

LEFT SYSTEM TYPE TABLE FIELD ID

Displays table field on the left side of the join.

RIGHT SYSTEM TYPE TABLE FIELD ID

Displays table field on the right side of the join.

TYPE

Displays type of join. Refer to SQL Server documentation for detailed information.

SYSTEM SUPPLIED

If checked, this content is installed with the Stewardship Tier and cannot be edited.

If unchecked, the content was added by a user or process.

NOTE: This is a display-only check box. It cannot be updated.