EMPLIDEMPL_RCDGVT_LEAVE_XFR_TYPEEFFSEQEFFDTDefault Value: %date
NATIONAL_IDPrompt Table: GVT_PERSONAL_VW
Prompt Table: COMPANY_TBL
Prompt Table: GVT_SUBAGCY_TBL
Prompt Table: GVT_LV_BELTP_VW
B=Bank
D=Donor
Y/N Table Edit
Default Value: N
GVT_LV_DONOR(SQL Table) |
Index Back |
|---|---|
Federal Leave Donor |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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. |
| 4 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | NATIONAL_ID |
Character(20) | VARCHAR2(20) NOT NULL | National ID |
| 7 | GVT_LV_DON_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
The donating emplid for employee within your agency
Prompt Table: GVT_PERSONAL_VW |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 9 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 10 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL |
Sub-Agency
Prompt Table: GVT_SUBAGCY_TBL |
| 11 | 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 |
| 12 | 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 |
| 13 | PAY_END_DT | Date(10) | DATE | Pay Period End Date |
| 14 | GVT_PAY_PRD_RET_DT | Date(10) | DATE | The pay period which any unused remaining leave was returned to the donor(s), if applicable |
| 15 | GVT_HRS_DON_REMAIN | 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 |
| 16 | GVT_LV_BANKELTP_ID | Character(3) | VARCHAR2(3) NOT NULL |
ID for Various types of leave transfer programs
Prompt Table: GVT_LV_BELTP_VW |
| 17 | GVT_LV_RETURN | Character(1) | VARCHAR2(1) NOT NULL |
Where leave will be returned to. Values are "Donor" and "Bank"
B=Bank D=Donor |
| 18 | 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
Y/N Table Edit Default Value: N |