In PeopleSoft, you create metadata using a base language specified in the PeopleSoft application. You can also include non-base language translations for language-sensitive metadata. Language-sensitive metadata can include column names, business names, descriptions, and comments.

When you import a PeopleSoft source definition, the Designer imports metadata in the base language by default. If you want language-sensitive metadata in a different language, enter a PeopleSoft language code. If the source has language-sensitive metadata for the language code, the Designer imports it. If the source does not have language-sensitive metadata for the language code, the Designer imports metadata in the base language.

For example, you want to import a source definition that uses French as its base language. You want to import the PeopleSoft records with English metadata. In the Import from PeopleSoft dialog box, enter the PeopleSoft language code ENG to import English translations. The Designer imports available English metadata for the records you select. If English translations are not available, the Designer imports French metadata.

By default, PeopleSoft stores data for each source in a base table. Typically, language-sensitive data in the base table is in the base language. PeopleSoft stores translations of language-sensitive data in a related language table.

By default, the PowerCenter Integration Service extracts all data for a PeopleSoft source from the base table. If you want language-sensitive data in a particular language, enter the corresponding PeopleSoft language code in the application connection for the PeopleSoft system.

The PowerCenter Integration Service queries both the base table and the related language table. When language-sensitive data exists for the specified language code, the PowerCenter Integration Service extracts the data. When data does not exist for the specified language code, the PowerCenter Integration Service extracts all data from the base table.

The following table lists common PeopleSoft language codes:

The language codes associated with a PeopleSoft system might differ based on the PeopleSoft version and installation. For details specific to your installation, see the PeopleSoft documentation.