RS_RES_WM_VW

(SQL View)
 Index Back

SELECT G.SETID , A.EMPLID , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH FROM %Table(RS_WORKER_TBL) A , %Table(RS_WRKR_EFFDT) B , %Table(PERSONAL_DATA) C , %Table(INSTALL_RES_WM) D ,%Table(RS_WM_CURJOB_VW) F ,%Table(SET_CNTRL_GROUP) G WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND C.PER_STATUS = 'E' AND B.EFFDT = ( SELECT MAX(EFFDT) FROM %Table(RS_WRKR_EFFDT) E WHERE A.EMPLID = E.EMPLID AND B.SYSTEM_SOURCE = 'WM' AND E.EFFDT <= %CurrentDateIn) AND A.EMPLID = F.EMPLID AND F.BUSINESS_UNIT = G.SETCNTRLVALUE AND G.REC_GROUP_ID IN ( SELECT REC_GROUP_ID FROM PS_REC_GROUP_REC WHERE RECNAME = 'RS_RES_WM_VW')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name