| Data element |
Definition |
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? No |
The last updated date of the activity.
ACTIVITY_ID_DATE is not populated for expense report activity records. |
ACTIVITY_PENN_ID
Format VARCHAR2(50)
Indexed? No
May be Null? Yes |
The Penn ID of the person associated with this travel activity.
ACTIVITY_PENN_ID is not populated for World Travel itinerary activity records if passenger number one on the itinerary is not a University employee.
|
ACTIVITY_START_DATE
Format DATE
Indexed? No
May be Null? No |
The earliest date referenced in the related expense report or intinerary, even if the activity is not continuous (for example, a single expense report submitted for two separate trips).
For expense reports, this is the earliest expense report entry transaction date.
For World Travel itineraries, this is the earliest date found in any of the following travel segments, air, car, hotel, rail, tour, cruise/ferry.
|
ACTIVITY_END_DATE
Format DATE
Indexed? No
May be Null? No |
The latest date referenced in the related expense report or intinerary, even if the activity is not continuous (for example, a single expense report submitted for two separate trips).
For expense reports, this is the latest expense report entry transaction date.
For World Travel itineraries, this is the latest date found in any of the following travel segments, air, car, hotel, rail, tour, cruise/ferry.
|
SOURCE
Format VARCHAR2(15)
Indexed? No
May be Null? No |
The source of this travel activity.
Values: Concur TEM, World Travel |
