GP_PSLP_CTRYLVW

(SQL View)
 Index Back

All GP Countries

Countries with description

SELECT A.COUNTRY ,B.LANGUAGE_CD , B.DESCR FROM PS_GP_COUNTRY A , PS_COUNTRYTBL_LANG B WHERE A.COUNTRY = B.COUNTRY(+)

  • Related Language Record for GP_PSLP_CTRY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description