| Data element |
Definition |
ACTIVITY_COUNTRY
Format VARCHAR2(1000)
Indexed? No
May be Null? No |
The two character country code associated with this travel activity.
For expense reports, this includes any country specified on an expense report entry.
For World Travel itineraries, this includes any country specified on any of the following travel segments, air, car, hotel, rail, tour, cruise/ferry. |
ACTIVITY_COUNTRY_CODE
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The country name associated with this travel activity.
For expense reports, this includes any country specified on an expense report entry.
For World Travel itineraries, this includes any country specified on any of the following travel segments, air, car, hotel, rail, tour, cruise/ferry.
|
ACTIVITY_ID
Format VARCHAR2(50)
Indexed? No
May be Null? No |
The unique identifier of the WT_TRAVEL_ACTIVITY_MV record. It is the concatenation of a source identifier and the expense report key (if the activity is an expense report) or the itinerary PNR ID (if the activity is a World Travel itinerary). |
ACTIVITY_ID_DATE
Format DATE
Indexed? No
May be Null? Yes |
The last updated date of the activity.
ACTIVITY_ID_DATE is not populated for expense report activity records. |
SOURCE
Format VARCHAR2(15)
Indexed? No
May be Null? No |
The source of this travel activity.
Values: Concur TEM, World Travel |
