HRMH_OWNER_VW

(SQL View)
 Index Back

HRMH - Active Emp View

View lists the Active EMPLIDS to be used in Matrix Hierarchy Setup.

SELECT DISTINCT A.EMPLID , P.NAME_DISPLAY , P.LAST_NAME FROM PS_JOB A , PS_NAMES P WHERE A.EMPLID = P.EMPLID AND A.HR_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT) AND P.NAME_TYPE = 'PRI' AND P.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_NAMES B WHERE B.EMPLID = P.EMPLID AND B.NAME_TYPE = P.NAME_TYPE AND B.EFFDT <= %CurrentDateIn )

  • Related Language Record: HRMH_OWNER_LW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HRMH_OWNER_EMPLID Character(11) VARCHAR2(11) NOT NULL Matrix Owner Employee ID
    2 NAME Character(50) VARCHAR2(50) NOT NULL Name
    3 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name