Penn Computing

University of Pennsylvania
Penn Computing << go backback
GROUP_TRIP_TRAVELER_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home

GROUP_TRIP_TRAVELER_V Table /View

Explanation
Persons traveling as part of a Group Trip, including trip leaders.

Common Uses
Displaying a Group trip traveler's name, contact information, IDs, Group Trip and transportation entry status.

Primary Key Indexed Data Elements Related Tables
None
GROUP_TRIP_TRAVELER_ID
GROUP_TRIP_V, 
GROUP_TRIP_TRAVELER_V

Cautions
  • Accepted will not be ‘T’ for travelers where self_joined = ‘T.’
  • Employee_Home_Org, Faculty_Flag, SRS_Home_Division, SRS_Home_School, and Student_Flag for the travelers are all updated daily.
    The value when the trip was taken may have been different.
  • Prior to Jan 2013, this view did not include trip leaders; their data appeared in Group_Trip_V. Trip leaders are the subset of records in this view where Leader='Y'.
GROUP_TRIP_TRAVELER_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry 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