GPCH_CANTON_VW

(SQL View)
 Index Back

Swiss Canton View CHE

Swiss Canton View CHE

SELECT DISTINCT %Substring(A.STATE, 1, 2) , A.DESCR FROM PS_STATE_TBL A WHERE A.COUNTRY = 'CHE'

  • Related Language Record: GPCH_CANT_LN_VW

    • # 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