| Data element |
Definition |
| City Indexed - no
Format - Varchar2(500)
May be Null? Y | Destination City for a person on an Individual trip. |
| Compute_Lat_And_Long Indexed - no
Format - Varchar2(1)
May be Null? Y | Compute the Latitude and Longitude for Google Map? (T/F) |
| Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Destination Country for a person on an Individual trip. |
| Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Destination Country code for a person on an Individual trip. |
| Country_Id Indexed - no
Format - Number
May be Null? Y | Destination Country ID for a person on an Individual trip. |
| Destination_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Phone number for the Individual Trip destination. |
| Entered_By_Uid Indexed - no
Format - Number
May be Null? Y | User ID of the person who created the record. |
| Entered_On Indexed - no
Format - Date
May be Null? Y | Date the record was created. |
| Group_Trip_Destination_Id Indexed - no
Format - Number
May be Null? Y | Group Destination ID (if applicable) of the related Group destination.
(Group_Destination.ID) |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? Y | Group Trip ID (if applicable) of the related Group destination.
(Group_Trip.ID) |
| Individual_Trip_Destination_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for an "Individual" destination.
(Individual_Destination.ID) |
| Individual_Trip_Id Indexed - no
Format - Number
May be Null? Y | Individual Trip Id unique identfier. |
| Individual_Trip_Traveler_Id Indexed - no
Format - Number
May be Null? Y | Person identifier for an Individual trip traveler.
(Person.ID) |
| Last_Edited_By_Uid Indexed - no
Format - Number
May be Null? Y | User ID of the person who last edited the record. |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | Date the record was last edited. |
| Latitude Indexed - no
Format - Varchar2(30)
May be Null? Y | Latitude co-ordinate used to map the destination using Google Map. |
| Longitude Indexed - no
Format - Varchar2(30)
May be Null? Y | Longitude co-ordinate used to map the destination using Google Map. |
| Notes Indexed - no
Format - Varchar2(4000)
May be Null? Y | Notes for the Individual Trip destination. |
| On_Site_From Indexed - no
Format - Date
May be Null? Y | Starting date for the Individual Trip destination. |
| On_Site_From_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the start date for the individual trip destination. (Jan,Feb,Mar, etc.) |
| On_Site_From_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the start date for the individual trip destination. |
| On_Site_To Indexed - no
Format - Date
May be Null? Y | Ending date for the Individual Trip destination. |
| On_Site_To_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the end date for the individual trip destination. (Jan,Feb,Mar, etc.) |
| On_Site_To_Year Indexed - no
Format - Varchar2(4)
May be Null? Y | Year portion of the end date for the individual trip destination. |
| Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Destination Country Region for a person on an Individual trip. |
| Street Indexed - no
Format - Varchar2(500)
May be Null? Y | Destination Street for a person on an Individual trip. |
| Street_Additional Indexed - no
Format - Varchar2(500)
May be Null? Y | Destination Street2 for a person on an Individual trip. |
