TRAVEL_TYPEEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
Y/N Table Edit
Default Value: N
TRAVEL_TYPE_TBL(SQL Table) |
Index Back |
|---|---|
Travel Type CodesUse TRAVEL_TYPE_TBL to record codes and descriptions for types of travel such as Home Leave or Rest and Recreation. This functionality is part of the International Assignment application. You can create multiple TRAVEL_TYPE_TBL records for a travel code, each with a unique effective date. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TRAVEL_TYPE |
Character(3) | VARCHAR2(3) NOT NULL | Type of Travel |
| 2 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 5 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 6 | HOME_LEAVE | Character(1) | VARCHAR2(1) NOT NULL |
Home Leave
Y/N Table Edit Default Value: N |