Derived table | table_ID.field_name | The SQL query that defines a derived table can refer to any previously defined table or derived table in the Domain. Therefore, you must include the table ID. |
Join expression | table_alias.field_name | Within a join expression, tables are given alias names that must be used. Even though join expressions may appear in separate joinedDatasetRef elements, the alias declared in each one can be used in any subsequent one. |
Calculated field on a table or derived table | field_name | Calculated fields can only appear on a table if they refer exclusively to fields of the table, in which case no table ID is needed. However, the table ID is not forbidden, and the Domain Designer sometimes includes it. |
Calculated field on a join tree | table_ID.field_name | Calculated fields declared in join trees refer to fields prefixed with their table ID. |
Filter on a table or derived table | field_name | Filters that are evaluated within the table or derived table do not need the table ID. |
Filter on a join tree | table_ID.field_name | Filters that refer to fields in separate tables of the join tree need to use the table ID on each field name. |
Calculated field in an Ad Hoc view | "Field Label" | Calculated fields declared in Ad Hoc views can refer to fields using their Item Labels entered with double quotes ("). Item Labels are created on the Display tab of the Domain Designer. |
| table_ID.field_name | Calculated fields declared in Ad Hoc views can refer to fields prefixed with their table ID. |