GPSC_ELM_CNT_VW

(SQL View)
Index Back

GP Supported Countries View

Global Payroll - Supported Countries Views

SELECT OPRID , COUNTRY , DESCR FROM PS_GP_COUNTRYSS_VW UNION SELECT DISTINCT A.OPRID , B.COUNTRY , B.COUNTRY FROM PS_GP_COUNTRYSS_VW A , PS_GP_COUNTRY B WHERE B.COUNTRY = 'ALL'

  • Related Language Record: GP_CTYSS_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description