GVT_LEAVE_XFR_TYPEEMPLIDEMPL_RCDEFFDTGVT_LV_WITH_CONTRC=Contribution
W=Withdrawal
A=Approved
C=Contributor
D=Denied
P=Applied
X=Cancelled
GVT_LVBANK_LDGR(SQL Table) |
Index Back |
|---|---|
Federal Leave Bank Ledger |
| # | 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 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Record |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | GVT_LV_WITH_CONTR |
Character(1) | VARCHAR2(1) NOT NULL |
Contribute / Withdrawal value for leave bank members
C=Contribution W=Withdrawal |
| 6 | 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 |
| 7 | GVT_LV_MEM_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
The leave bank member status
A=Approved C=Contributor D=Denied P=Applied X=Cancelled |