GROUP_TRIP_LEADER_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home

GROUP_TRIP_LEADER_V Table /View

Explanation
Group Trip Leaders view. Prior to Jan 2013, the leader information was stored with the Group Trip, and only one leader was permitted in the database.

Common Uses
Displaying details about Group trip leaders.

None

GROUP_TRIP_ID

GROUP_TRIP_V
GROUP_TRIP_TRAVELER_V

• Effective Jan 2013, there maybe more than one leader per group trip.
• All Group Trip Leaders also appear in the Group_Trip_Traveler_V. Leaders are a subset of the travelers for any given group trip.
• Employee_Home_Org, Faculty_Flag, SRS_Home_Division, SRS_Home_School, and Student_Flag for the Trip Leader are all updated daily. The value when the trip was taken may have been different.
• This view did not exist before Jan 2013.

GROUP_TRIP_LEADER_V Table - Data Element Index   Tables and Data Elements   Global Activities Registry Home   Data Warehouse Home