TL_WFA_REP_VW

(SQL View)
 Index Back

Reports to Name


SELECT C.EMPLID , C.EMPL_RCD , C.REPORTS_tO , MIN(A.NAME_DISPLAY) FROM PS_NAMES A , PS_JOB B , PS_TL_JOB_EMPL_DAT C WHERE B.EMPLID=A.EMPLID AND C.REPORTS_TO <> ' ' AND C.REPORTS_tO = B.POSITION_NBR AND A.NAME_TYPE='PRI' AND B.HR_STATUS = 'A' AND A.EFFDT=( SELECT MAX(B1.EFFDT) FROM PS_NAMES B1 WHERE A.EMPLID=B1.EMPLID AND A.NAME_TYPE=B1.NAME_TYPE AND B1.EFFDT <= %CurrentDateIn) AND B.EFFDT=( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE B.EMPLID=A1.EMPLID AND B.EMPL_RCD=A1.EMPL_RCD AND A1.EFFDT <= %CurrentDateIn) AND B.EFFSEQ=( SELECT MAX(A1.EFFSEQ) FROM PS_JOB A1 WHERE B.EMPLID=A1.EMPLID AND B.EMPL_RCD = A1.EMPL_rCD AND B.EFFDT = A1.EFFDT) GROUP BY C.EMPLID, C.EMPL_RCD, C.REPORTS_TO UNION SELECT EMPLID ,EMPL_RCD , ' ' ,' ' FROM PS_TL_JOB_EMPL_DAT WHERE REPORTS_TO=' '

# 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 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
4 REPORTS_TO_NAME Character(50) VARCHAR2(50) NOT NULL Reports To Name