GVT_LV_DON_EXT

(SQL Table)
Index Back

Federal Leave Don Ext

# 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.

Prompt Table: GVT_XFR_TYP_TBL

4 SEQUENCE_NBR Number(2,0) SMALLINT NOT NULL Sequence Number
5 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

6 NAME Character(50) VARCHAR2(50) NOT NULL Name
7 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
8 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

9 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

Prompt Table: GVT_SUBAGCY_TBL

10 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
11 PAY_END_DT Date(10) DATE Pay Period End Date