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

PASSENGER Table

Explanation
Contains itinerary passenger 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
PASSENGER_NUMBER

      

AFFILIATION
HOME_DEPT_ORG
HOME_SCHOOL_CTR
PASSENGER_NUMBER
PENN_ID
PNR_ID
PNR_LAST_UPDATED_DATE
PRIMARY_APPT_JOB_CLASS

      

PNR
      

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

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

• The most recent record for a given PASSENGER is the one with the most recent LAST_UPDATED_DATE_TIME. This record contains the current detail information for that passenger.

• AFFILIATION, EMPLOYEE_ID, HOME_DEPT_ORG, HOME_SCHOOL_CTR, PENN_ID, PRIMARY_APPT_JOB_CLASS, PRIMARY_DEPT_ORG and PRIMARY_SCHOOL_CTR are only populated for passenger number one.

• Users granted access to the World Travel data collection may see all PASSENGER 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.

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