Contains a list of countries referenced by each World Travel itinerary and Travel and Expense Management expense report.
- To allow for combined reporting of travel itineraries and expense reports
||Indexed Data Elements
- ACTIVITY_ID is 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 is not populated for expense report activity records.
- There may be multiple countries associated with a travel ACTIVITY_ID.
- Users granted access to the World Travel data collection may see all WT_TRAVEL_COUNTRIES_MV records.
Internally generated by a Warehouse database script.
Questions about this page? Email us at firstname.lastname@example.org
|Information Systems and Computing|
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania