Target table

All attributes support the concept of a ‘target table’.  This represents the database table upon which the attribute is based.  Target table is defined in accordance with the attribute’s type:

• Database column: target table is the table in which the column exposed by the attribute is to be found.

• Exists: target table is specified when creating the attribute; for example, in an ‘Exists in Orders Table’ attribute, the target table might be defined as Customers and the linked table as Orders.

• Flag: target table is defined as the table associated with the attribute’s selection rule’s resolution level.

• Aggregation: target table is specified when creating the attribute; for example, when creating a ‘Max Order Amount’ aggregation attribute, target table might be defined as Customers and aggregation table as Orders.

• Function: target table is specified when creating the attribute; for example, an ‘Uppercase Surname’ function attribute might have its target table set to Customer (from which the surname attribute was sourced).

• Banding: a banding attribute’s target table is inherited from the target table of the Banding attribute with which it is configured.

• SQL expression: a SQL expression attribute’s target table is defined when creating the attribute and represents the table against which the Expression configured in the attribute is to be run.

Note that if one or more auxiliary databases have been configured at the current RPI tenant, you can select a target table from such a context.