WT_TRAVEL_COUNTRIES_MV Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home

WT_TRAVEL_COUNTRIES_MV Table

Explanation
Contains a list of countries referenced by each World Travel itinerary and Travel and Expense Management expense report.

Common Uses

• To allow for combined reporting of travel itineraries and expense reports
  
  

WT_DATES_MV
WT_TRAVEL_ACTIVITY_MV
      

• 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.

Source

Internally generated by a Warehouse database script.

WT_TRAVEL_COUNTRIES_MV Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home