RD_LANGUAGE_VW

(SQL View)
 Index Back

Installed Language View

Available Languages for PS CRM system.

SELECT A.LANGUAGE_CD , B.XLATLONGNAME FROM PSXLATITEM B , PSLANGUAGES A WHERE A.LANGUAGE_CD = B.FIELDVALUE AND A.INSTALLED = 1 AND B.FIELDNAME = 'LANGUAGE_CD'

  • Related Language Record: RD_LANGUAGE_LNG

  • Parent Record Of RD_FILTER_SET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANG_CD Character(3) VARCHAR2(3) NOT NULL Language Code Field. This Field is imported into CRM DB from Human Resources Database.
    2 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name