GPCH_TX_VG_SRLN

(SQL View)
 Index Back

Municipality Search

Municipality Search

SELECT DISTINCT A.GPCH_TX_CANTON , B.LANGUAGE_CD , B.DESCR FROM PS_GPCH_TX_VILLAGE A , PS_STATE_TBL_LANG B WHERE B.COUNTRY = 'CHE' AND A.GPCH_TX_CANTON = B.STATE

  • Related Language Record for GPCH_TX_VG_SRCH

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