| Data element |
Definition |
| Accepted Indexed - no
Format - Varchar2(1)
May be Null? Y | Has the Group Trip traveler accepted? |
| Accepted_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Accepted_alert for a Group Trip Traveler. |
| Added_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Added_alert for a Group Trip Traveler. |
| Confirmed Indexed - no
Format - Varchar2(1)
May be Null? Y | Group trip traveler has "confirmed" participation for the trip. If a traveler was added to the trip by an administrator, he/or she must manually confirm the trip. Confirmation is automatic if self-joined. |
| Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | Group Trip Traveler - email address. |
| Emergency_Contact_Email Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - Email address for emergency contact. |
| Emergency_Contact_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - Name of emergency contact. |
| Emergency_Contact_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - Phone number for emergency contact. |
| Emergency_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - emergency phone #. |
| Employeee_Home_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | Group Trip Traveler - 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. |
| Faculty_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this Group Trip Traveler 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. |
| First_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - first name. |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier for a Group Trip |
| Group_Trip_Traveler_Id Indexed - no
Format - Number
May be Null? N | Unique Identifier for the person while traveling on the Group Trip. |
| Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - last name. |
| Middle_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - middle name. |
| Need_More_Data_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Need more data alert for a Group Trip Traveler. |
| Penn_Id Indexed - no
Format - Varchar2(40)
May be Null? Y | Group Trip Traveler - Penn_ID. |
| Person_Id Indexed - no
Format - Number
May be Null? Y | Unique Identifier for a person |
| Primary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - primary phone. |
| Secondary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Group Trip Traveler - secondary phone #. |
| Self_Joined Indexed - no
Format - Varchar2(1)
May be Null? Y | Group trip traveler - self joined the group trip? |
| Self_Joined_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Self_joined_alert for a Group Trip Traveler.a |
| 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. |
| 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. |
| Student_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this Group Trip Traveler 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. |
| Transportation_Entry_Exists Indexed - no
Format - Char
May be Null? Y | Did the Group trip traveler enter ANY transportation information related to the Group trip?
Note: Transportation info is entered as Individual Trip Travel Leg record with matching GroupTrip_Id. |
| Traveler_Lfm Indexed - no
Format - Varchar2(303)
May be Null? Y | Name of a Group Trip Traveler - Last Name, First Name Middle Name |
