Penn Computing

University of Pennsylvania
Penn Computing << go backback
PNR Table - Data Element Index   Tables and Data Elements   World Travel Home   Data Warehouse Home

PNR Table

Explanation
Contains travel itinerary header data from the World Travel booking and reservations system.

Common Uses

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

Primary Key Indexed Data Elements Related Tables
LAST_UPDATED_DATE_TIME
PNR_ID
AFFILIATION
COA_ACCOUNT_NUMBER
COA_BC
COA_CNAC
COA_CREF
COA_FUND
COA_OBJECT
COA_ORG
COA_PROGRAM
INTERNATIONAL_FLAG
LAST_UPDATED_DATE_TIME
PNR_ID
TRAVEL_DATE
TRAVEL_END_DATE
TRAVEL_TYPE
AIR_SEGMENT
ARNK_SEGMENT
CAR_SEGMENT
CRUISE_FERRY_SEGMENT
EMAIL_ADDRESSES
EXCHANGE_COUPON
EXCHANGE_INFO
EXCHANGE_TAX
EXPORT_INFO
HOTEL_SEGMENT
INSURANCE_SEGMENT
ITEM
ITEMNAME_LOOKUP
MISC_SEGMENT
PASSENGER
PHONENUMBER
RAIL_SEGMENT
SEAT
STORED_FARE
TICKET
TICKET_TAX
TOUR_SEGMENT

      

Cautions
  • Each itinerary is uniquely identified by the PNR_ID, however, the PNR table contains the change history for each itinerary so there may be multiple PNR records for a given PNR_ID.
  • The most recent record for a given PNR_ID is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current header information for the itinerary.
  • An itinerary may have multiple passengers associated with it. The AFFILIATION field of the PNR record contains the affiliation of passenger number one.
  • Users granted access to the World Travel data collection may see all PNR 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.

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

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania