GPCH_TX_VG_SRCH

(SQL View)
 Index Back

Municipality Search

Municipality Search

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

  • Related Language Record: GPCH_TX_VG_SRLN

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