Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

 
  UPDATES
Current Load Status
Regular Availability
 
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
 
  DATA COLLECTIONS
Advancement
Assets
BBR
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Student
Travel Expense Management
Tuition Distribution
World Travel
Cross-Collection

World Travel Collection Tables & 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.

AIR_SEGMENT
Table   Elements

ARNK_SEGMENT
Table   Elements

CAR_SEGMENT
Table   Elements

CRUISE_FERRY_SEGMENT
Table   Elements

EMAIL_ADDRESSES
Table   Elements

EXCHANGE_COUPON
Table   Elements

EXCHANGE_INFO
Table   Elements

EXCHANGE_TAX
Table   Elements

EXPORT_INFO
Table   Elements

HOTEL_SEGMENT
Table   Elements

INSURANCE_SEGMENT
Table   Elements

ITEM
Table   Elements

Materialized views included in the World Travel universe:

WT_DATES_MV
Table   Elements

WT_TRAVEL_ACTIVITY_MV
Table   Elements

WT_TRAVEL_COUNTRIES_MV
Table   Elements

 

ITEMNAME_LOOKUP
Table   Elements

MISC_SEGMENT
Table   Elements

PASSENGER
Table   Elements

PHONE_NUMBER
Table   Elements

PNR
Table   Elements

RAIL_SEGMENT
Table   Elements

SEAT
Table   Elements

STORED_FARE
Table   Elements

STORED_FARE_SEGMENT
Table   Elements

TICKET
Table   Elements

TICKET_TAX
Table   Elements

TOUR_SEGMENT
Table   Elements

 

 

 

 


  Collection Information:

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


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