SCC_VISA_CNTLNV

(SQL View)
 Index Back

Country view

Used as prompt for Visa Types in CC Fluid Profile Configuration

SELECT Country ,LANGUAGE_CD , Descr FROM %Table(COUNTRYTBL_LANG) Country WHERE EXISTS( SELECT Country FROM PS_VISA_PERMIT_TBL A WHERE Country = Country.Country AND %EffdtCheck(VISA_PERMIT_TBL B, A, %CurrentDatein) AND Eff_status='A')

  • Related Language Record for SCC_VISA_CNT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description