GVT_LV_APP_SRCH

(SQL View)
 Index Back

Federal Leave Record App


SELECT A.EMPLID ,A.EMPL_RCD ,A.GVT_LEAVE_XFR_TYPE ,A.EFFSEQ ,A.EFFDT ,D.NAME ,A.GVT_LV_APP_STATUS FROM PS_GVT_LV_REC_APP A , PS_GVT_XFR_TYP_TBL B , PS_PERSON_NAME D WHERE A.GVT_LEAVE_XFR_TYPE = B.GVT_LEAVE_XFR_TYPE AND A.EMPLID = D.EMPLID AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_GVT_LV_REC_APP A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT AND A2.GVT_LV_APP_STATUS = 'A' AND A2.GVT_LEAVE_REASON = A.GVT_LEAVE_REASON) AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_GVT_XFR_TYP_TBL C WHERE C.GVT_LEAVE_XFR_TYPE = B.GVT_LEAVE_XFR_TYPE AND C.EFFDT <= A.EFFDT) AND B.GVT_LEAVE_XFR_PRGM = 'V'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_LV_REC_EMPLID Character(11) VARCHAR2(11) NOT NULL Leave Recipient EMPLID

Prompt Table: PERSON_NAME

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 GVT_LEAVE_XFR_TYPE Character(3) VARCHAR2(3) NOT NULL Type of leave requested by employee.

Prompt Table: GVT_LV_VOL_VW

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 REQUEST_DT Date(10) DATE Request Date
6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 GVT_LV_APP_STATUS Character(1) VARCHAR2(1) NOT NULL The status of the leave request
A=Approved
C=Cancelled
D=Denied
P=Pending
S=Separated