GVT_LEAVE_XFR_TYPEGVT_LV_WITH_CONTRC=Contribution
W=Withdrawal
Default Value: C
EFFDTDefault Value: %DATE
GVT_LV_AGY_LDGR(SQL Table) |
Index Back |
|---|---|
Federal LV AGY LDGR |
| # | 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. |
| 2 | GVT_LV_WITH_CONTR |
Character(1) | VARCHAR2(1) NOT NULL |
Contribute / Withdrawal value for leave bank members
C=Contribution W=Withdrawal Default Value: C |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %DATE |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | 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 |