GB_CURR_JOB_LW

(SQL View)
 Index Back

Rel Lang for GB_CURR_JOB_VW

Related language record for for GB_CURR_JOB_VW.

SELECT A.EMPLID ,A.EMPL_RCD ,JC.LANGUAGE_CD ,JC.DESCR FROM PS_JOB A , PS_JOBCODE_LANG JC WHERE A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB JOB2 WHERE A.EMPLID = JOB2.EMPLID AND A.EMPL_RCD = JOB2.EMPL_RCD AND JOB2.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB JOB3 WHERE JOB3.EMPLID = A.EMPLID AND JOB3.EMPL_RCD = A.EMPL_RCD AND JOB3.EFFDT = A.EFFDT) AND JC.SETID = A.SETID_JOBCODE AND JC.JOBCODE = A.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC2.EFFDT) FROM PS_JOBCODE_TBL JC2 WHERE JC2.SETID = A.SETID_JOBCODE AND JC2.JOBCODE = A.JOBCODE AND JC2.EFFDT <= A.EFFDT)

  • Related Language Record for GB_CURR_JOB_VW

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

    Prompt Table: PERSON

    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

    Default Value: 0

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description