CANTON_CHE_VW

(SQL View)
 Index Back

Canton View

This view lists all the canton names for Switzerland.

SELECT STATE , DESCR FROM PS_STATE_TBL WHERE COUNTRY = 'CHE'

  • Related Language Record: CANTON_CHE_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STATE Character(6) VARCHAR2(6) NOT NULL State
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description