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

ITEM Table

Explanation
Contains itinerary custom data details from the World Travel booking and reservations system.

Common Uses

• Reporting on travel itinerary details as well as aggregated travel itinerary data.
  
  

PNR_ID
PNR_LAST_UPDATED_DATE
ITEM_NAME

      

PNR_ID
PNR_LAST_UPDATED_DATE
ITEM_NAME


      

PNR
ITEMNAME_LOOKUP
      

• There may be multiple ITEM records for a given itinierary.

• The ITEM table contains the change history for each itinerary so there may be multiple ITEM records for a given PNR_ID and ITEM_NAME.

• The most recent record for a given ITEM is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current custom data for that itinerary.

• Users granted access to the World Travel data collection may see all ITEM records.

Source

From the World Travel reservation and booking system (aka Concur) administered by the Travel Office.

World Travel reservation and booking system (aka Concur) is used to book travel reimbured by the University.

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