HCSC_CLK_NACYVW

(SQL View)
Index Back

GP Supported Countries and ALL

Global Payroll - Supported Countries Views + ALL

SELECT A.COUNTRY ,A.DESCR FROM PS_COUNTRY_TBL A WHERE A.COUNTRY IN ('CAN', 'USA') UNION %Sql(HCSC_CLK_UNION_ALLCNTRY)

  • Related Language Record: HCSC_CLK_GPCYLN
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description