EMPLIDGVT_DONATE_EFFDTGVT_LEAVE_XFR_TYPEEFFSEQGVT_LV_REC_EMPLIDB=Bank
D=Donor
GVT_LV_DONOR_VW(SQL View) |
Index Back |
|---|---|
Federal Leave Donor View |
| SELECT A.GVT_LV_DON_EMPLID ,A.EFFDT ,D.GVT_LEAVE_XFR_TYPE ,A.EFFSEQ ,A.EMPLID ,B.COMPANY ,B.GVT_SUB_AGENCY ,A.GVT_HRS_DONATED ,A.GVT_HRS_USED ,A.PAY_END_DT ,A.GVT_PAY_PRD_RET_DT ,A.GVT_LV_RETURN ,A.GVT_LV_BANKELTP_ID ,A.GVT_LV_RESTORED ,C.NATIONAL_ID FROM PS_GVT_LV_DONOR A ,PS_GVT_JOB B , PS_PERS_NID C , PS_GVT_LV_APP_SRCH D WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND B.EMPL_RCD = 0 AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_GVT_JOB B2 WHERE B2.EMPLID = B.EMPLID AND B2.EMPL_RCD = B.EMPL_RCD AND B2.EFFDT <= A.EFFDT) AND B.EFFSEQ = ( SELECT MAX(B3.EFFSEQ) FROM PS_GVT_JOB B3 WHERE B3.EMPLID = B.EMPLID AND B3.EMPL_RCD = B.EMPL_RCD AND B3.EFFDT = B.EFFDT) AND A.GVT_LV_DON_EMPLID <> ' ' AND D.GVT_LV_REC_EMPLID = B.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFSEQ = A.EFFSEQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | GVT_DONATE_EFFDT |
Date(10) | DATE | The effective date that the annual leave can be made available to the leave recipient |
| 3 | GVT_LEAVE_XFR_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Type of leave requested by employee. |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | GVT_LV_REC_EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Leave Recipient EMPLID |
| 6 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL | Company |
| 7 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL | Sub-Agency |
| 8 | GVT_HRS_DONATED | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | The amount of annual leave hours the donor is transferring from his annual leave balance to a leave recipient for the leave emergency |
| 9 | GVT_HRS_USED | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | The used amount of annual leave hours the donor is transferring from his annual leave balance to a leave recipient for the leave emergency |
| 10 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 11 | GVT_PAY_PRD_RET_DT | Date(10) | DATE | The pay period which any unused remaining leave was returned to the donor(s), if applicable |
| 12 | GVT_LV_RETURN | Character(1) | VARCHAR2(1) NOT NULL |
Where leave will be returned to. Values are "Donor" and "Bank"
B=Bank D=Donor |
| 13 | GVT_LV_BANKELTP_ID | Character(3) | VARCHAR2(3) NOT NULL | ID for Various types of leave transfer programs |
| 14 | GVT_LV_RESTORED | Character(1) | VARCHAR2(1) NOT NULL | Updated by the leave transfer process during payroll. Donating employees will be restored a portion of their leave donation, if applicable |
| 15 | NATIONAL_ID | Character(20) | VARCHAR2(20) NOT NULL | National ID |