BEN_JOBCODE_VW

(SQL View)
 Index Back

BEN Jobcode View


SELECT J.JOBCODE ,JB.DESCR FROM PS_JOB J ,PS_JOBCODE_TBL JB WHERE J.JOBCODE=JB.JOBCODE AND JB.SETID=J.SETID_JOBCODE AND J.EFFDT=( SELECT MAX(JD.EFFDT) FROM PS_JOB JD WHERE JD.EMPLID=J.EMPLID AND JD.EMPL_RCD=J.EMPL_RCD AND JD.EFFDT<=%CurrentDateIn) AND J.EFFSEQ=( SELECT MAX(JQ.EFFSEQ) FROM PS_JOB JQ WHERE JQ.EMPLID=J.EMPLID AND JQ.EMPL_RCD=J.EMPL_RCD AND JQ.EFFDT=J.EFFDT) AND JB.EFFDT=( SELECT MAX(JBED.EFFDT) FROM PS_JOBCODE_TBL JBED WHERE JBED.SETID=JB.SETID AND JBED.JOBCODE=JB.JOBCODE AND jbED.effdt<=%CurrentDateIn) AND JB.EFF_STATUS='A'

  • Related Language Record: BEN_JOBCODE_VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Prompt Table: BEN_JOBCODE_VW