| Data element |
Definition |
| Email_Address Indexed - no
Format - Varchar2(200)
May be Null? Y | Individual TripTraveler - email address. |
| Emergency_Contact_Email Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual Trip Traveler - Email address of Emergency contact. |
| Emergency_Contact_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Name of Emergency contact. |
| Emergency_Contact_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Phone # of Emergency contact. |
| Emergency_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Emergency phone number. |
| Employeee_Home_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | Individual TripTraveler - 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. |
| Entered_By_Penn_Id Indexed - no
Format - Number
May be Null? Y | Penn ID of the person who created the Individual Trip. |
| Exported_To_Isos Indexed - no
Format - Varchar2(1)
May be Null? Y | Has the Individual trip been exported to ISOS? |
| Exported_To_Isos_On Indexed - no
Format - Date
May be Null? Y | Date that the Individual trip was exported to ISOS. |
| Faculty_Flag Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Individual TripTraveler 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 | Individual TripTraveler - First name. |
| Foreign_Visa_Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Foreign Visa Issuing Country for a person on an Individual trip. |
| Foreign_Visa_Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Foreign Visa Issuing Country code for a person on an Individual trip. |
| Foreign_Visa_Expiration_Date Indexed - no
Format - Date
May be Null? Y | Foreign Visa Expiration Date for a person on an Individual trip. |
| Foreign_Visa_Number Indexed - no
Format - Varchar2(100)
May be Null? Y | Foreign Visa Number for a person on an Individual trip. |
| Foreign_Visa_Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Foreign Visa Issuing Region for a person on an Individual trip. |
| Foreign_Visa_Type Indexed - no
Format - Varchar2(1000)
May be Null? Y | Foreign Visa type for a person on an Individual trip. |
| Foreign_Visa_Type_Code Indexed - no
Format - Varchar2(10)
May be Null? Y | Foreign Visa type code for a person on an Individual trip. |
| Foreign_Visa_Type_Long_Desc Indexed - no
Format - Varchar2(1000)
May be Null? Y | Detailed description of the foreign visa type for a person on an Individual trip. |
| For_Credit Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Individual trip for Academic credit? |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? Y | Associated Group Trip ID. A trip can stored in both the "Group Trip" and "Individual Trip" data tables. This column provides a way to cross-reference. |
| Individual_Trip_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for an Individual Trip.
(Individual_Trip.ID) |
| Individual_Trip_Traveler_Id Indexed - no
Format - Number
May be Null? Y | Person identifier for the Individual trip traveler.
(Person.ID) |
| Indiv_Trip_Create_Date Indexed - no
Format - Date
May be Null? Y | Date the Individual trip was created. |
| Indiv_Trip_End_Date Indexed - no
Format - Date
May be Null? Y | Date the Individual trip ends. Based on the latest destination date for the Individual trip. |
| Indiv_Trip_End_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the individual trip end date. (Jan,Feb,Mar, etc.) |
| Indiv_Trip_End_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the individual trip end date. |
| Indiv_Trip_Name Indexed - no
Format - Varchar2(500)
May be Null? Y | Individual trip name. |
| Indiv_Trip_Notes Indexed - no
Format - Varchar2(4000)
May be Null? Y | Notes from the Individual trip. |
| Indiv_Trip_Start_Date Indexed - no
Format - Date
May be Null? Y | Date the Individual trip starts. Based on the earliest destination date for the Individual trip. |
| Indiv_Trip_Start_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the individual trip start date. (Jan,Feb,Mar, etc.) |
| Indiv_Trip_Start_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the individual trip start date. |
| Last_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Last name. |
| Middle_Name Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Middle Name. |
| Need_More_Data_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Need more data alert for an Individual trip. |
| Passport_Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Passport Country for a person on an Individual trip. |
| Passport_Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Passport Country code for a person on an Individual trip. |
| Passport_Expiration_Date Indexed - no
Format - Date
May be Null? Y | Passport exipration date for a person on an Individual trip. |
| Passport_Number Indexed - no
Format - Varchar2(100)
May be Null? Y | Passport # for a person on an Individual trip. |
| Passport_Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Passport Region for a person on an Individual trip. |
| Penn_Id Indexed - no
Format - Varchar2(40)
May be Null? Y | Individual TripTraveler - PennID. |
| Primary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Primary phone number. |
| Primary_Purpose Indexed - no
Format - Varchar2(1000)
May be Null? Y | Primary purpose for the Individual trip. |
| Primary_Purpose_990catg Indexed - no
Format - Varchar2(500)
May be Null? Y | 990 Category for the primary purpose for the Individual trip. |
| Primary_Purpose_990subcatg Indexed - no
Format - Varchar2(500)
May be Null? Y | 990 Sub-Category for the primary purpose for the Individual trip. |
| Primary_Purpose_Long Indexed - no
Format - Varchar2(1000)
May be Null? Y | Long description of the primary purpose for the Individual trip. This will be either the Free-Text entered by the user as "Other Primary purpose" or the text from the 990 lookup table. |
| Proxied_Trip Indexed - no
Format - Varchar2(1)
May be Null? Y | Is the Individual trip a Proxied Trip ? |
| School Indexed - no
Format - Varchar2(1000)
May be Null? Y | Name of the School/Center associated with the Individual Trip. |
| School_Code Indexed - no
Format - Varchar2(3)
May be Null? Y | 2 digit code for the School/Center associated with the Individual Trip.
eg) 02, 61, etc... |
| Secondary_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Individual TripTraveler - Secondary phone number. |
| Secondary_Purpose Indexed - no
Format - Varchar2(1000)
May be Null? Y | Secondary purpose for the Individual trip. |
| Secondary_Purpose_Long Indexed - no
Format - Varchar2(1000)
May be Null? Y | Long description of the secondary purpose for the Individual trip. This will be either the Free-Text entered by the user as "Other secondary purpose" or the text from the 990 lookup table. |
| 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 the Individual TripTraveler 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. |
| Subject_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Traveler alert for an individual trip. |
| Subject_Has_Accepted Indexed - no
Format - Varchar2(1)
May be Null? Y | Has the Individual accepted the trip, if it was created by a proxy? ("T" or blank) |
| Transportation_Entry_Exists Indexed - no
Format - Char
May be Null? Y | Did the Individual trip traveler enter ANY transportation information related to the Individual trip?
Note: Transportation info is entered as an Individual Trip Travel Leg record with an optional matching GroupTrip Id. |
| Transportation_Missing_Alert Indexed - no
Format - Varchar2(20)
May be Null? Y | Transportation Missing alert for an Individual trip. |
| Transportation_Missing_Alert2 Indexed - no
Format - Varchar2(20)
May be Null? Y | Transportation Missing alert2 for an Individual trip. |
| Traveler_Lfm Indexed - no
Format - Varchar2(303)
May be Null? Y | Name of a person traveling on an Individual Trip - Last Name, First Name Middle Name. |
