GB_CURR_JOB_VW

(SQL View)
 Index Back

Group Build Current Job view

Group Build Current Job view.

SELECT A.EMPLID ,A.EMPL_RCD ,A.EFFDT ,A.EFFSEQ ,A.SETID_JOBCODE ,A.JOBCODE ,JC.DESCR FROM PS_JOB A , PS_JOBCODE_TBL 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: GB_CURR_JOB_LW

    • # 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 EFFDT_NOKEY Date(10) DATE Used in Records /Views where the EFFDT won't be a key
    4 EFFSEQ_NOKEY Number(3,0) SMALLINT NOT NULL Field used in views where EFFSEQ won't be a key
    5 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code

    Prompt Table: JOBCODE_TBL

    7 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description