RELG_MYS_LNG_VW

(SQL View)
 Index Back

Employee Religion Data view

Employee Religion Data Related Language view - Malaysia

SELECT A.EMPLID , C.LANGUAGE_CD , C.DESCRSHORT FROM PS_DIVERS_RELIGION A , PS_REG_REGION_TBL B , PS_RELIGION_LANG C WHERE A.REG_REGION = B.REG_REGION AND B.COUNTRY = 'MYS' AND C.SETID = A.SETID AND C.RELIGION_CD = A.RELIGION_CD AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_RELIGION_TBL C1 WHERE C1.SETID = C.SETID AND C1.RELIGION_CD = C.RELIGION_CD)

  • Related Language Record for RELIGION_MYS_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