The Global Activities Registry (GAR) was in use from 2010 through 2019 as Penn’s central resource for collecting information about the travel plans and activities of faculty, staff, and students preparing to travel abroad for academic, educational, clinical, research, or University business purposes. The data collection remains in the Warehouse for historical analysis purposes. (The system currently in use is available from Penn Global's website.)
The Registry has two sections, one for Group Coordinators and one for Travelers.
Group Coordinators: In this section, those responsible for organizing and coordinating group travel enter general information about their program or activity.
Travelers: In this section, individual travelers and participants in an organized group enter their travel details, including personal and emergency contact information, passport information, itinerary, and transportation details. International SOS, the organization that provides Penn students, faculty, and staff with international medical, security, and travel assistance, including emergency evacuation, is notified automatically of travel plans.
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).
| Group Trips | ||
| GROUP_TRIP_DESTINATION_V Table Elements |
GROUP_TRIP_LEADER_V Table Elements |
GROUP_TRIP_V Table Elements |
| GROUP_TRIP_HOSTPARTNER_INST_V Table Elements |
GROUP_TRIP_TRAVELER_V Table Elements |
|
| Individual Trips | ||
| INDIVIDUAL_TRIP_DESTINATION_V Table Elements |
TRANSPORTATION_V Table Elements |
INDIVIDUAL_TRIP_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 |
FOREIGN_VISA_TYPE Table Elements |
REGION Table Elements |
| ACTIVITY_TO_990 Table Elements |
IATA_CODE Table Elements |
SCHOOL Table Elements |
| ACTIVITY_TYPE Table Elements |
ORGANIZATION Table Elements |
TRAVEL_MODE Table Elements |
| AIRLINE Table Elements |
PERSON Table Elements |
UNIVERSITY (Host/Partner Institution) Table Elements |
| COUNTRY Table Elements |
||
The Global Activities Data Collection is refreshed continuously, every 5 minutes, seven days a week. The refresh affects all tables in the collection (Groups, Trips, Individual Trips, and all lookup tables).
Source of the Data
The data that is accessible via the BusinessObjects Global Activites Registry universe comes from the Global Activities Registry (GAR) application, which can be accessed here.
In addition, the collection uses Penn Community to determine a user's Penn affiliation(s) and Penn Organization(s), storing the information internally within the Global Activities collection. These internal user tables are refreshed once a day, seven days a week, at night around 23:00 EST.
Time Span Covered
The Global Activities Registry was piloted in Summer of 2010 and went live in the Fall, and was retired in Fall 2019. The warehouse contains GAR data from 2010-2019.
The diagram illustrates the architecture of the Global Activities Registry BusinessObjects Universe, and identifies joins. While viewing the diagram, you can also display its table documentation by clicking anywhere in the box. If you need to print the diagram, print it in landscape orientation.
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.
Users gain access to Global Activities Registry data by submitting the e-Form for the DW Global Activities Registry. The form is routed for electronic signatures by the requestor's Supervisor, the school access administrator (or senior business officer), and the Penn Global.
Releasing Data Outside the University
Be cautious about releasing Global Activities Registry data outside the University. If you receive a request for data to be sent outside the University, contact Penn Global.
Releasing Data Within the University
Within the University, Global Activities Registry 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 Global Activities Registry data, call Penn Global.
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.
Help is available through GLOBALACT-WH@LISTS.UPENN.EDU. When you are granted access to the data collection in the warehouse, you are automatically subscribed to participate in an email listserv named GLOBALACT-WH@LISTS.UPENN.EDU. (Those with subscriptions to the list are called list members. If any member sends an E-mail note to the list, every member of the list receives a copy.
When you have a question. If you have a question about the Global Activities data, please send E-mail to the list -- and if you have the answer to a list members question, please E-mail your reply to the list so all the members can benefit from the discussion.
If you notice that some documentation needs updating. The list is also the place to send E-mail if you notice that some documentation needs updating. 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.