TL_ESS_JOB_LANG

(SQL View)
 Index Back

Related language view

This view is the related language view for TL_ESS_JOB_VW3

SELECT A.EMPLID ,A.EMPL_RCD ,JCL.LANGUAGE_CD ,JCL.DESCR FROM PS_JOB A , PS_TL_EMPL_DATA B , PS_JOBCODE_TBL JC , PS_JOBCODE_LANG JCL , PS_DEPT_TBL D WHERE B.TIME_RPTG_STATUS = 'A' AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_TL_EMPL_DATA WHERE PS_TL_EMPL_DATA.EMPLID = B.EMPLID AND PS_TL_EMPL_DATA.EMPL_RCD = B.EMPL_RCD AND EFFDT <= %CurrentDateIn) AND A.EFFDT = ( SELECT MAX (EFFDT) FROM PS_JOB WHERE PS_JOB.EMPLID = A.EMPLID AND PS_JOB.EMPL_RCD = A.EMPL_RCD AND EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(PS_JOB.EFFSEQ) FROM PS_JOB WHERE PS_JOB.EMPLID = A.EMPLID AND PS_JOB.EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT) AND JC.SETID = A.SETID_JOBCODE AND JC.JOBCODE = A.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.SETID = A.SETID_JOBCODE AND JC1.JOBCODE = A.JOBCODE AND JC1.EFFDT <= %CurrentDateIn) AND D.SETID = A.SETID_DEPT AND D.DEPTID = A.DEPTID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_DEPT_TBL D1 WHERE D1.SETID = A.SETID_DEPT AND D1.DEPTID = A.DEPTID AND D1.EFFDT <= %CurrentDateIn) AND JCL.SETID = JC.SETID AND JCL.JOBCODE = JC.JOBCODE AND JCL.EFFDT = ( SELECT MAX(JCL1.EFFDT) FROM PS_JOBCODE_LANG JCL1 WHERE JCL1.SETID = JC.SETID AND JCL1.JOBCODE = JC.JOBCODE AND JCL1.EFFDT <= %CurrentDateIn)

  • Related Language Record for TL_ESS_JOB_VW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: NEW

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 JOB_DESCR Character(30) VARCHAR2(30) NOT NULL Job Description