HR_OBD_SRCH_EE

(SQL View)
 Index Back

OnBoarding Srch Index

Additional EE data

SELECT J.EMPLID , J.EMPL_RCD , BU.DESCR , C.DESCR , D.DESCR FROM PS_HR_OBD_TRIGGER T , PS_JOB J , PS_COMPANY_TBL C , PS_DEPT_TBL D , PS_BUS_UNIT_TBL_HR BU WHERE J.EMPLID = T.EMPLID AND J.EMPL_RCD = T.EMPL_RCD AND J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND EFFDT <= %CurrentDateIn ) AND J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB J1 WHERE J1.EMPLID=J.EMPLID AND J1.EMPL_RCD=J.EMPL_RCD AND J1.EFFDT=J.EFFDT) AND D.SETID = J.SETID_DEPT AND D.DEPTID = J.DEPTID AND D.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEPT_TBL D1 WHERE D1.SETID = D.SETID AND D1.DEPTID = D.DEPTID AND D1.EFFDT <= %CurrentDateIn) AND C.COMPANY = J.COMPANY AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = C.COMPANY AND C1.EFFDT <= %CurrentDateIn) AND BU.BUSINESS_UNIT = J.BUSINESS_UNIT

  • Related Language Record: HR_OBD_EE_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 Record
    3 HR_OBD_BU_DESCR Character(30) VARCHAR2(30) NOT NULL Business Unit Name
    4 HR_OBD_CO_DESCR Character(30) VARCHAR2(30) NOT NULL Company Name
    5 HR_OBD_DPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Name