| Data element |
Definition |
| Approx_Number_Penn_Employees Indexed - no
Format - Number
May be Null? Y | Approximate number of Penn Employees on a Group Trip. |
| Approx_Number_Travelers Indexed - no
Format - Number
May be Null? Y | Approximate number of travelers on a Group Trip. |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for a Group Trip |
| Hiring_Foreign_Workers Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the hiring of foreign workers expected as part of this Group trip? |
| Leader_Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | Group Trip Leader - email address. |
| Leader_Emergency_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - emergency phone. |
| Leader_Emer_Contact_Email Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - Emergency contact email address. |
| Leader_Emer_Contact_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - emergency contact. |
| Leader_Emer_Contact_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - Emergency contact phone number. |
| Leader_Employeee_Home_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | Group Trip Leader - 4 digit Home ORG code if an active employee.
CAUTION: This value is updated daily to reflect current status. The value when the trip was taken may have been different. |
| Leader_Faculty_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Group Trip Leader currently an active Faculty member (Y/N)?
Set to ''Y'' if the individual has one of the following active Affiliation codes in Penn Community:
ADJF, FAC, SFAC, VFAC, WFAC
CAUTION: This value is updated daily to reflect current status. The value when the trip was taken may have been different. |
| Leader_First_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - first name. |
| Leader_Has_Accepted Indexed - no
Format - Varchar2(1)
May be Null? Y | Has the Group Trip Leader accepted the Group Trip? |
| Leader_Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - last name. |
| Leader_Middle_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - middle name. |
| Leader_Name Indexed - no
Format - Varchar2(303)
May be Null? Y | Name of the Group Leader - Last Name, First Name Middle Name. |
| Leader_Penn_Id Indexed - no
Format - Varchar2(40)
May be Null? Y | Group Trip Leader - PennID. |
| Leader_Person_Id Indexed - no
Format - Number
May be Null? Y | Unique ID for the Group Trip Leader.
(Person.ID) |
| Leader_Primary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - primary phone. |
| Leader_Secondary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Leader - secondary phone. |
| Leader_SRS_Home_Division
Indexed - no
Format - Varchar2(3)
May be Null? Y | If a student, the SRS Division for the current academic term and degree order of 1.
Examples "ASP", "BMP","CGS","COL", ... "WHP"
CAUTION: This value is updated daily to reflect current status. The value when the trip was taken may have been different. |
| Leader_SRS_Home_School
Indexed - no
Format - Varchar2(40)
May be Null? Y | If a student, the SRS School for the current academic term and degree order of 1.
CAUTION: This value is updated daily to reflect current status. The value when the trip was taken may have been different. |
| Leader_Student_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Group Trip Leader currently an active Student(Y/N)? Set to ''Y'' if the individual is an has active student affiliation in Penn Community.
CAUTION: This value is updated daily to reflect current status. The value when the trip was taken may have been different. |
| Num_Travelers_Accepted Indexed - no
Format - Number
May be Null? Y | Number of travelers who have accepted participation in the Group Trip. |
| Num_Travelers_Confirmed Indexed - no
Format - Number
May be Null? Y | Number of travelers who have confirmed participation in the Group Trip.
This will include Accepted travelers + Self-joined travelers. |
| Num_Travelers_Self_Joined Indexed - no
Format - Number
May be Null? Y | The number of travelers who self-joined a Group trip. |
| Num_Travelers_Unconfirmed Indexed - no
Format - Number
May be Null? Y | The number of persons who have not confirmed participation in a Group Trip.
ie.) Someone added to the Group trip by the administrator, but not accepted by the traveler. |
| Num_Travelers_W_Trnsprtn_Entry Indexed - no
Format - Number
May be Null? Y | The number of persons who have entered individual transportation record(s) related to a Group Trip. |
| Num_Trip_Travelers Indexed - no
Format - Number
May be Null? Y | Count of persons traveling in Group Trips. All travelers regardless; either self-joined or added by the Group administrator. |
| Travel_Group_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier for a GAR Travel Group |
| Trip_Created Indexed - no
Format - Date
May be Null? Y | Date the Group trip was created. |
| Trip_End_Date Indexed - no
Format - Date
May be Null? Y | Date the Group trip ends, based on the latest destination for the Group trip. |
| Trip_End_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the group trip end date. (Jan,Feb,Mar, etc.) |
| Trip_End_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the group trip end date. |
| Trip_Name Indexed - no
Format - Varchar2(500)
May be Null? Y | Name of a Group Trip. |
| Trip_Notes Indexed - no
Format - Varchar2(4000)
May be Null? Y | Group trip notes. |
| Trip_Start_Date Indexed - no
Format - Date
May be Null? Y | Date the Group trip starts. Based on the earliest destination for the Group trip. |
| Trip_Start_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the group trip start date. (Jan,Feb,Mar, etc.) |
| Trip_Start_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the group trip start date. |
