World Travel Data Collection

The World Travel Data Collection is a subset of the University Data Warehouse containing travel itinerary detail information from July 2015 through the current fiscal year.

Tables and Data Elements

Tables are listed in alphabetical order. Select Table to obtain the explantion, common uses, primary keys, indexed data elements, and related tables for a table. Select Elements to obtain the definition, list of values, formats, and not null values for each data element in the table. A description of table and data element terminology is in the document What the Warehouse Contains.

Looking for a specific element or caution? Try the searching the collection documentation for particular keywords (search page will open in a new tab).

 

AIR_SEGMENT
Table   Elements		 ITEMNAME_LOOKUP
Table   Elements
ARNK_SEGMENT
Table   Elements		 MISC_SEGMENT
Table   Elements
CAR_SEGMENT
Table   Elements		 PASSENGER 
Table   Elements
CRUISE_FERRY_SEGMENT
Table   Elements		 PHONE_NUMBER 
Table   Elements
EMAIL_ADDRESSES
Table   Elements		 PNR
Table   Elements
EXCHANGE_COUPON
Table   Elements		 RAIL_SEGMENT
Table   Elements
EXCHANGE_INFO
Table   Elements		 SEAT
Table   Elements
EXCHANGE_TAX
Table   Elements		 STORED_FARE
Table   Elements
EXPORT_INFO
Table   Elements		 STORED_FARE_SEGMENT
Table   Elements
HOTEL_SEGMENT
Table   Elements		 TICKET
Table   Elements
INSURANCE_SEGMENT
Table   Elements		 TICKET_TAX
Table   Elements
ITEM 
Table   Elements		 TOUR_SEGMENT
Table   Elements
Materialized views included in the World Travel universe: 
WT_DATES_MV
Table   Elements		 WT_TRAVEL_COUNTRIES_MV
Table   Elements
WT_TRAVEL_ACTIVITY_MV
Table   Elements		  

The World Travel collection is refreshed nightly, Monday through Saturday.

World Travel details tables are refreshed following the completion of BEN Financials batch processing around midnight (updates should usually be completed by start of business).

Source of the Data
The data in the Data Warehouse that is accessible via the Business Objects Global Travel Universe comes from the World Travel system. The World Travel system (aka Concur) is used to book travel that is reimbused by the University and is administered by Penn Travel Services.

Time Span Covered
The World Travel data collection includes data for travel itineraries created after July 1, 2014.

Data training for this collection is offered on an ad hoc basis -- please contact Enterprise Information & Analytics for assistance with specific training questions. You can also refer to the table and element documentation for information and cautions about specific data.

Individuals must be authorized to use the World Travel data collection in the Data Warehouse before they can be granted access to the World Travel data collection. Individuals granted access to view World Travel data in the Warehouse can view this data for the entire University.

To request access to the World Travel data collection please contact Enterprise Information and Analytics.

Releasing Data Outside the University 
The only office that may disclose travel data outside the University is Penn Travel Services. If you do not work for that office and you receive a request for data to be sent outside the University, refer the requester to Penn Travel Services.

Releasing Data Within the University
Within the University, World Travel data may be disclosed only if it is needed to do the business of the University, and only to those who need to know the information in order to do their jobs. If you are not sure whether to fulfill a request for World Travel data, contact Penn Travel Services.

Query Results
If you save your query results in Excel, pdf, or any other local file type, you must see to it that any sensitive data stored on your peronal computer is safeguarded through physical security, access control software, or encryption. When a computer is left signed to an account, it is easy for someone to gain unauthorized access. Either sign off from your account before you leave your computer or restrict access by some other means (physical security or access control software).

For more information on security and privacy, contact the Office of Information Security.

If you have a question about the World Travel data, or if you notice some documentation that needs updating, please contact Enterprise Information & Analytics. For documentation published on the Web, please specify the URL for the documentation that needs to be updated. For BusinessObjects documentation (help for Objects), please specify the Universe, Class, and Object.