Many tables contain a pair of column_name and column_name_EN columns. These are used to support sites that use multiple languages. In these cases, the column_name column holds the default version of the data, which is used if no locale is specified for the report. The column_name_EN column holds the data in English. You can add additional columns with additional languages if necessary. For example, to add gender data in French, add a GENDER_NAME_FR column to the ARF_GENDER table.
When a user is working with the metadata model, the ATGDW metadata model allows the Framework Manager to select the appropriate column to display based on the user’s locale. If the user’s locale is not known or there is no column for that locale, then data from the default column is used.
