PeopleSoft Wiki

— tranlation in related language.

select distinct c.language_cd,
a.MESSAGE_TEXT as English_Text,c.MESSAGE_TEXT as other_language
from PSMSGCATdefn a ,PSMSGCATLANG c
where a.MESSAGE_SET_NBR=c.MESSAGE_SET_NBR
and a.MESSAGE_NBR=c.MESSAGE_NBR and c.language_cd in ('FRA', 'GER', 'ITA')
and UPPER(a.MESSAGE_TEXT) in ('GRADE') order by 2

—Using related language table for page fields
SELECT DISTINCT b.pnlname,b.LABEL_ID,b.FIELDNAME,a.LANGUAGE_CD,B.LBLTEXT AS ENG_LABEL , A.LBLTEXT as other_lang FROM
PSPNLFIELDLang A, PSPNLFIELD B
WHERE A.pnlfldid=B.pnlfldid
AND B.LABEL_ID=A.LABEL_ID
and a.pnlname=b.pnlname
AND UPPER(b.LBLTEXT)
like upper('QUALIFICATION%')

AND LANGUAGE_CD IN ('ITA','FRA','GER') order by 2;

— from fieldlabels
SELECT DISTINCT a.LANGUAGE_CD,B.LONGNAME AS ENG_LABEL , A.longname,A.shortname FROM
PSDBFLDLABLLANG A, PSDBFLDLABL B
WHERE A.FIELDNAME=B.FIELDNAME
AND B.LABEL_ID=A.LABEL_ID
AND UPPER(b.LONGNAME) like
upper('QUALIFICATION')

AND LANGUAGE_CD IN ('ITA','FRA','GER') order by 2;