# SYSTEMGLOSSARYTERMTRANSLATIONS: Data Dictionary Glossary Term Translations Translations of the glossary terms into every language of the shipped translation files. - Catalog: `DataDictionary` - Schema: `Invantive` - Alias: `gtt` - Label: Glossary Term Translations This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive UniversalSQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API. ## View Columns The columns of the view `SYSTEMGLOSSARYTERMTRANSLATIONS` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `GLOSSARY_CODE` | `varchar2`(240) | Glossary Code | ☑ | Code of the glossary the term belongs to. | | `LANGUAGE_CODE` | `varchar2`(240) | Language Code | ☑ | Code of the language of the translation. | | `RESOURCE_CODE` | `varchar2`(240) | Resource Code | ☐ | Code of the resource whose English text is the term, from which the translation is taken. | | `TERM` | `varchar2`(240) | Term | ☑ | The word or phrase itself. | | `TRANSLATION` | `varchar2`(4000) | Translation | ☐ | Reviewed translation of the term into the language. The term itself when it is the same in every language. Empty when no reviewed translation is known yet. | ## How the Translation of a Term is Derived A glossary term has no translation of its own in the master repository. The translation is derived, in the same way as the Translation Workbench of Invantive Studio does: 1. Take the resources whose English text is the term and which have a text in the language. 2. Of those, take the first one when ordered by the resource flag, descending, and then by resource code. 3. The reviewed text of that resource in the language is the translation. A term which is the same in every language is its own translation. The export applies the rule when the translation files are generated, so the view shows the outcome and needs no rule of its own.