| Data element |
Definition |
| City Indexed - no
Format - Varchar2(500)
May be Null? Y | City for the GroupTrip destination. |
| Country Indexed - no
Format - Varchar2(1000)
May be Null? Y | Country of the GroupTrip destination. |
| Country_Code Indexed - no
Format - Varchar2(2)
May be Null? Y | Country of the GroupTrip destination. |
| Destination_Phone Indexed - no
Format - Varchar2(100)
May be Null? Y | Phone number to use while at the Group Trip destination. |
| Group_Trip_Destination_Id Indexed - no
Format - Number
May be Null? N | Unique identifier for a destination on a specfic Group trip. |
| Group_Trip_Id Indexed - no
Format - Number
May be Null? Y | Unique identifier for a Group Trip |
| Notes Indexed - no
Format - Varchar2(4000)
May be Null? Y | Group Trip destination notes. |
| On_Site_From Indexed - no
Format - Date
May be Null? Y | Starting date for the Group Trip destination. |
| On_Site_From_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the start date for the group 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 group trip destination. |
| On_Site_To Indexed - no
Format - Date
May be Null? Y | Ending date for the Group Trip destination. |
| On_Site_To_Month Indexed - no
Format - Varchar2(3)
May be Null? Y | Month portion of the end date for the group 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 group trip destination. |
| Primary_Destination Indexed - no
Format - Varchar2(1)
May be Null? Y | Is this the primary destination for this Group Trip T/F ? |
| Region Indexed - no
Format - Varchar2(1000)
May be Null? Y | Region of the GroupTrip destination. |
| Street Indexed - no
Format - Varchar2(500)
May be Null? Y | Street1 portion of the GroupTrip destination. |
| Street_Additional Indexed - no
Format - Varchar2(500)
May be Null? Y | Street2 portion of the Group Trip destination. |
