HR_DTLN_LW1

(SQL View)
 Index Back

Rel Lang for HR_DTLN_VW1

Related language record for HR_DTLN_VW1.

SELECT A.HRCD_DT_EMP , A.HRCD_DT_MGR , L.LANGUAGE_CD , COALESCE(( SELECT BL.NAME_DISPLAY FROM PS_NAMES_LNG BL WHERE BL.EMPLID = A.HRCD_DT_EMP AND BL.NAME_TYPE = 'PRI' AND BL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(NAMES_LNG BL1, BL, %CurrentDateIn)), ( SELECT B.NAME_DISPLAY FROM PS_NAMES B WHERE B.EMPLID = A.HRCD_DT_EMP AND B.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES B1, B, %CurrentDateIn)), ' ') , COALESCE(( SELECT CL.NAME_DISPLAY FROM PS_NAMES_LNG CL WHERE CL.EMPLID = A.HRCD_DT_MGR AND CL.NAME_TYPE = 'PRI' AND CL.LANGUAGE_CD = L.LANGUAGE_CD AND %EffdtCheck(NAMES_LNG CL1, CL, %CurrentDateIn)), ( SELECT C.NAME_DISPLAY FROM PS_NAMES C WHERE C.EMPLID = A.HRCD_DT_MGR AND C.NAME_TYPE = 'PRI' AND %EffdtCheck(NAMES C1, C, %CurrentDateIn)), ' ') FROM PS_HRCD_DT_MAIN A , PSLANGUAGES L WHERE L.INSTALLED = 1 AND L.LANGUAGE_CD <> ( SELECT O.LANGUAGE_CD FROM PSOPTIONS O)

  • Related Language Record for HR_DTLN_VW1

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRCD_DT_EMP Character(11) VARCHAR2(11) NOT NULL Dotted Line Employee
    2 HRCD_DT_MGR Character(11) VARCHAR2(11) NOT NULL Dotted Line Manager
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 HRCD_NAME_EMP Character(50) VARCHAR2(50) NOT NULL Report Name
    5 HRCD_NAME_MGR Character(50) VARCHAR2(50) NOT NULL Manager Name