SCH_COMMON_VW

(SQL View)
 Index Back

Common View for Scheduling

Common View for Scheduling panels which are used by TL/GP.

SELECT J.EMPLID , J.EMPL_RCD , P.NAME , J.DEPTID , J.JOBCODE , JC.DESCR FROM PS_JOBCODE_TBL JC , PS_JOB J , PS_PERSON_NAME P WHERE J.EMPLID = P.EMPLID AND J.JOBCODE = JC.JOBCODE AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID = J.EMPLID AND J1.EMPL_RCD = J.EMPL_RCD ) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT = J.EFFDT ) AND JC.SETID = J.SETID_JOBCODE AND JC.JOBCODE = J.JOBCODE AND JC.EFFDT = ( SELECT MAX(JC1.EFFDT) FROM PS_JOBCODE_TBL JC1 WHERE JC1.SETID = J.SETID_JOBCODE AND JC1.JOBCODE = J.JOBCODE AND JC1.EFFDT <= J.EFFDT)

  • Related Language Record: SCH_COMMON_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    5 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    6 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description