Understanding Related Language Tables

You can use several possible scenarios to familiarize yourself with related languages when setting up related languages for a message.

A department table, for example, must publish information in German as well as English. In the following example, the base application tables and related-language tables have a parent-child relationship. The related-language table has the same name as the parent table, but is suffixed with _LANG, in accordance with PeopleSoft naming conventions.

This example illustrates the fields and controls on the Related-language record definitions. You can find definitions for the fields and controls later on this page.

Related-language record definitions

Consider the following points:

  • The parent table, DEPT_TBL, has the related-language child table, DEPT_TBL_LANG.

  • The child table has the same fields as the parent table, plus an additional field of LANGUAGE_CD.

  • The attributes of the child table are all of the translatable textual fields of the parent record.