Global Activities Registry Collection Tables & Data Elements

Tables are listed in alphabetical order by type: Group Trips, Individual Trips, Travel Group/Program, and Lookup tables. 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.

Group Trips GROUP_TRIP_DESTINATION_V Table    Elements GROUP_TRIP_HOSTPARTNER_INST_V Table    Elements GROUP_TRIP_LEADER_V Table    Elements GROUP_TRIP_TRAVELER_V Table    Elements GROUP_TRIP_V Table    Elements Individual Trips INDIVIDUAL_TRIP_DESTINATION_V Table    Elements INDIVIDUAL_TRIP_V Table    Elements TRANSPORTATION_V Table    Elements Travel Group/Programs GAR_GROUP_PROGRAM_ORGANIZATN_V Table    Elements GAR_GROUP_PROGRAM_SCHOOL_V Table    Elements GAR_GROUP_PROGRAM_V Table    Elements

Lookup Tables ACTIVITY_SUB_TYPE Table    Elements ACTIVITY_TO_990 Table    Elements ACTIVITY_TYPE Table    Elements AIRLINE Table    Elements COUNTRY Table    Elements FOREIGN_VISA_TYPE Table    Elements IATA_CODE Table    Elements ORGANIZATION Table    Elements PERSON Table    Elements REGION Table    Elements SCHOOL Table    Elements TRAVEL_MODE Table    Elements UNIVERSITY (Host/Partner Institution) Table    Elements