GVT_LV_DON_EXT(SQL Table) |
Index Back |
---|---|
Federal Leave Don Ext |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | Character(11) | VARCHAR2(11) NOT NULL | Employee ID | |
2 | Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr | |
3 | Character(3) | VARCHAR2(3) NOT NULL |
Type of leave requested by employee.
Prompt Table: GVT_XFR_TYP_TBL |
|
4 | Number(2,0) | SMALLINT NOT NULL | Sequence Number | |
5 | 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 |