HR_EERCD_VW1

(SQL View)
Index Back

HR - Active Emp Rcd No. View.

View lists the Empl_Rcd for an Active person to be used in Layoff Roster List.

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , P.NAME , P.LAST_NAME FROM PS_JOB A , PS_PERSON_NAME 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)

  • Related Language Record: HR_EERCD_LW1
  • # 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 NAME Character(50) VARCHAR2(50) NOT NULL Name
    4 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name