GVT_LV_BANK_APP

(SQL Table)
Index Back

Federal Leave Bank App

# 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

Default Value: 0

3 GVT_LEAVE_XFR_TYPE Character(3) VARCHAR2(3) NOT NULL Type of leave requested by employee.
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 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
6 GVT_DENIAL_REASON1 Character(3) VARCHAR2(3) NOT NULL Reason to deny a leave recipient's application

Prompt Table: GVT_DENL_CD_TBL

7 GVT_DENIAL_REASON2 Character(3) VARCHAR2(3) NOT NULL Reason to deny a leave recipient's application

Prompt Table: GVT_DENL_CD_TBL

8 GVT_LV_ANNL_CONT Number(6,2) DECIMAL(5,2) NOT NULL Annual leave contribution
9 SERVICE_DT Date(10) DATE Service Date