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 |