Using Language-Sensitive Queries
PeopleSoft Query supports language-sensitive query output. If you create a query on a table that has a related language record, or if your query includes such a table, PeopleTools automatically performs the language lookup on the related language record. This means that the output of the query appears in the current, preferred language, if translations exist in the related language tables.
For example, if you built a simple query on the Country table (COUNTRY_TBL), the country descriptions in your query would appear in your preferred language, even through you queried the base language record (COUNTRY_TBL) and not the related language record (COUNTRYTBL_LANG). PeopleSoft Query performs the necessary join to the related language table to retrieve the translations; if they don’t exist, it retrieves the descriptions in the database’s base language.
The related language join is performed only when you run the query. Therefore, if you create a query as an English user and then execute the same query as a French user, the output appears in French, even though the query was created in English. The language preference of the user who is running the query drives the language joins.
Note: WHERE criteria, HAVING criteria, and ORDER BY clauses are applied only to the base language data. For example, assuming that the base language of your database is English, if you set a WHERE criterion that restricts country descriptions to those that begin with Ger, PeopleSoft Query retrieves the Allemagne country description when the query is run by a French language user. This is because the English description of Allemagne is Germany.
The automatic language join features in PeopleSoft Query are also used when you access your PeopleSoft database via the PeopleSoft Open Query ODBC interface.
For scheduled queries, the system uses the language specified in the user’s profile. It does not use the language selected during sign-in. The system will also use the international and regional settings the user has specified using the My Personalizations page. If no personal setting have been specified, the system uses the default installation international settings.
Note: Most PeopleSoft components appear by default from international settings on the browser if the user has not set any user-specific settings. However, this is not available for scheduled queries or any PeopleSoft Process Scheduler processes.