HCDL_MJOB_LANG

(SQL View)
 Index Back

Delegation Muti Job Lang View

Delegation Muti Job Language View

SELECT A.EMPLID ,A.EMPL_RCD ,B.LANGUAGE_CD ,A.SETID_DEPT , %Coalesce(DL.DESCR, B.DESCR) , %Coalesce(JL.DESCR, C.DESCR) FROM PS_HCDL_ALL_JOB_VW A , PS_HCDL_DEPT_AL_VW B LEFT OUTER JOIN PS_DEPT_TBL_EFF_LN DL ON DL.SETID = B.SETID AND DL.DEPTID = B.DEPTID AND DL.LANGUAGE_CD = B.LANGUAGE_CD , PS_HCDL_JOBCD_AL_V C LEFT OUTER JOIN PS_JOBCODE_EFF_LN JL ON JL.SETID = C.SETID AND JL.JOBCODE = C.JOBCODE AND JL.LANGUAGE_CD = C.LANGUAGE_CD WHERE A.SETID_DEPT = B.SETID AND A.DEPTID = B.DEPTID AND A.SETID_JOBCODE = C.SETID AND A.JOBCODE = C.JOBCODE AND B.LANGUAGE_CD = C.LANGUAGE_CD

  • Related Language Record for EPO_MULTI_JOB_V HCDL_ALL_JOB_VW HCDL_MULTI_JOB HCDL_PROXY_VW HCDL_PRXY_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
    5 DEPTNAME Character(30) VARCHAR2(30) NOT NULL Department Name
    6 JOBTITLE Character(30) VARCHAR2(30) NOT NULL Job Title