ETH_SGP_LANG_VW

(SQL View)
 Index Back

Employee Ethnic Data view

Employee Ethnic Data Related Language view - Singapore

SELECT A.EMPLID , C.LANGUAGE_CD , C.DESCRSHORT FROM PS_DIVERS_ETHNIC A , PS_REG_REGION_TBL B , PS_ETHNIC_GRP_LANG C WHERE A.REG_REGION = B.REG_REGION AND B.COUNTRY = 'SGP' AND C.SETID = A.SETID AND C.ETHNIC_GRP_CD = A.ETHNIC_GRP_CD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_ETHNIC_GRP_TBL C1 WHERE C1.SETID = C.SETID AND C1.ETHNIC_GRP_CD = C.ETHNIC_GRP_CD)

  • Related Language Record for ETHNIC_SGP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description