PC_EMP_JOB_LVW

(SQL View)
 Index Back

Active Project Job Codes

Search view for active Project Employee Job Codes for a selected project employee.

SELECT DISTINCT C.BUSINESS_UNIT , C.EMPLID , C.EMPL_RCD_NUM , C.PC_JOBCODE , D.LANGUAGE_CD , D.DESCR50 FROM PS_PC_JOBCODE_TBL A , PS_SET_CNTRL_REC B , PS_PC_JOB C , PS_PC_JOBCODE_LANG D WHERE C.EFF_STATUS = 'A' AND C.EFFDT = ( SELECT MAX (C1.EFFDT) FROM PS_PC_JOB C1 WHERE C1.BUSINESS_UNIT = C.BUSINESS_UNIT AND C1.EMPLID = C.EMPLID AND C1.EMPL_RCD_NUM = C.EMPL_RCD_NUM AND C1.PC_JOBCODE = C.PC_JOBCODE AND C1.EFFDT <= %CurrentDateIn) AND C.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_PC_JOB C2 WHERE C2.BUSINESS_UNIT = C.BUSINESS_UNIT AND C2.EMPLID = C.EMPLID AND C2.EMPL_RCD_NUM = C.EMPL_RCD_NUM AND C2.PC_JOBCODE = C.PC_JOBCODE AND C2.EFFDT = C.EFFDT) AND A.PC_JOBCODE = C.PC_JOBCODE AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX (A1.EFFDT) FROM PS_PC_JOBCODE_TBL A1 WHERE A1.SETID = A.SETID AND A1.PC_JOBCODE = A.PC_JOBCODE AND A1.EFFDT <= %CurrentDateIn) AND B.SETCNTRLVALUE = C.BUSINESS_UNIT AND B.RECNAME = 'PC_JOBCODE_TBL' AND A.SETID = B.SETID

  • Related Language Record for PC_EMP_JOB_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 EMPL_RCD_NUM Number(3,0) SMALLINT NOT NULL Project Employee Job Record #
    4 PC_JOBCODE Character(6) VARCHAR2(6) NOT NULL Project Employee Job Code
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50