GVT_LEAVE_XFR_TYPEGVT_LV_VOL_VW(SQL View) |
Index Back |
|---|---|
Voluntary Leave View |
| SELECT A.GVT_LEAVE_XFR_TYPE FROM PS_GVT_XFR_TYP_TBL A WHERE A.GVT_LEAVE_XFR_PRGM = 'V' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_GVT_XFR_TYP_TBL B WHERE B.GVT_LEAVE_XFR_TYPE = A.GVT_LEAVE_XFR_TYPE AND B.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GVT_LEAVE_XFR_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Type of leave requested by employee. |