| Data element |
Definition |
| Ackd_By_Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | email address of person who acknowledged the travel group. |
| Ackd_By_Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Last name of person who acknowledged the travel group. |
| Acknowledged Indexed - no
Format - Varchar2(1)
May be Null? Y | Has the travel group been acknowleged by someone from OIP (T/F)? |
| Acknowledged_On Indexed - no
Format - Date
May be Null? Y | Date the travel group was acknowledged by OIP. |
| Admin_Accepted Indexed - no
Format - Varchar2(1)
May be Null? Y | Did the Group Administrator accept the travel group definition (T/F)? |
| Admin_Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | Email address of the Group Administrator. |
| Admin_Emergency_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Emergency phone # of the Group Administrator. |
| Admin_Emer_Contact_Email Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Administrator - Emergency contact email address. |
| Admin_Emer_Contact_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Administrator - Emergency contact. |
| Admin_Emer_Contact_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Administrator - Emergency contact phone number. |
| Admin_Employeee_Home_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | Group Administrator - 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. |
| Admin_Faculty_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Group Administrator 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. |
| Admin_First_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | First name of the Group Administrator. |
| Admin_Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Last name of the Group Administrator. |
| Admin_Middle_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Middle name of the Group Administrator. |
| Admin_Penn_Id Indexed - no
Format - Varchar2(40)
May be Null? Y | PennID of the Group Administrator. |
| Admin_Person_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier of the Person responsible for Administration of the Travel Group. |
| Admin_Primary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Phone number of the Group Administrator. |
| Admin_Secondary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Secondary phone # of the Group Administrator. |
| Admin_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. |
| Admin_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. |
| Admin_Student_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Group Administrator 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. |
| Created_By_Email_Address Indexed - no
Format - Varchar2(256)
May be Null? Y | Travel Group Creator email address. |
| Created_By_Name Indexed - no
Format - Varchar2(303)
May be Null? Y | UserId of person who created the Travel Group. |
| Created_By_Pennkey Indexed - no
Format - Varchar2(30)
May be Null? Y | Travel Group Creator Pennkey. |
| Created_By_Penn_Id Indexed - no
Format - Varchar2(40)
May be Null? Y | Travel Group Creator PennId. |
| For_Credit Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this Travel group being defined as travel for Academic credit? |
| Group_Administrator Indexed - no
Format - Varchar2(303)
May be Null? Y | Name LFM of the Group Administrator. |
| Group_Created_On Indexed - no
Format - Date
May be Null? Y | Date the Travel Group was created. |
| Group_Description Indexed - no
Format - Varchar2(4000)
May be Null? Y | Description of the Travel Group. |
| Group_Name Indexed - no
Format - Varchar2(500)
May be Null? Y | Name of the Travel Group. |
| Num_Trips_This_Group Indexed - no
Format - Number
May be Null? Y | Number of trips by this Travel Group. |
| Omit_From_Search_Results Indexed - no
Format - Varchar2(1)
May be Null? Y | Omit this record from Search results? |
| Primary_Purpose Indexed - no
Format - Varchar2(1000)
May be Null? Y | Primary purpose of a Group trip. |
| Primary_Purpose_990catg Indexed - no
Format - Varchar2(500)
May be Null? Y | 990 Category for the primary purpose of a Group trip. |
| Primary_Purpose_990subcatg Indexed - no
Format - Varchar2(500)
May be Null? Y | 990 Sub-Category for the primary purpose of a Group trip. |
| Primary_Purpose_Long Indexed - no
Format - Varchar2(1000)
May be Null? Y | Long description of the primary purpose of the Group trip. This will be either the Free-Text entered by the user as "Other primary purpose" or the text from the 990 lookup table. |
| Secondary_Purpose Indexed - no
Format - Varchar2(1000)
May be Null? Y | Secondary purpose of a Group trip. |
| Secondary_Purpose_Long Indexed - no
Format - Varchar2(1000)
May be Null? Y | Long description of the secondary purpose of the Group trip. This will be either the Free-Text entered by the user as "Other secondary purpose" or the text from the 990 lookup table. |
| Travel_Group_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for a Travel Group in Global Activities Registry. |
