SCH_CURRJOB_LNG

(SQL View)
 Index Back

Current Job Info for EEs

Current JOB information.

SELECT A.EMPLID , A.EMPL_RCD ,J.LANGUAGE_CD , J.DESCR FROM PS_JOB A , PS_JOBCODE_LANG J WHERE A.PER_ORG = 'EMP' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT) AND J.JOBCODE = A.JOBCODE AND J.SETID = A.SETID_JOBCODE AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOBCODE_TBL J1 WHERE J.JOBCODE = J1.JOBCODE AND J1.SETID = J.SETID AND J1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SCH_CURRJOB_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
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description