FP_POSN_INC_VW

(SQL View)
 Index Back

Incumbents-Scroll- PS FPS

POSN_INCUMB_WS is a view which retrieves the current incumbents of a position by EmplID. This view is used in a work scroll on the Position Data 1 panel to support the cross-update to Job and Employment for current incumbents.

SELECT A.EMPLID ,A.EMPL_RCD ,A.POSITION_NBR FROM PS_FPAEEPOST_TBL A , PS_FPAEELEGALSTAT B WHERE A.FP_CNL_ROW = 'N' AND A.POSITION_NBR <> ' ' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_FPAEEPOST_TBL 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_FPAEEPOST_TBL D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = EMPL_RCD AND D.EFFDT = A.EFFDT) AND B.FP_POSN_DISCHG <> 'Y' AND B.FP_HIR_DOS_SIT = '02' AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_FPAEELEGALSTAT E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT <= A.EFFDT)

# 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 Rcd Nbr
3 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number