EXM_TRAVEL_INTEGRATIONS
This table contains configuration information of travel partner integrations, such as single sign on, booking site and travel itinerary import connection information.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
EXM_TRAVEL_INTEGRATIONS_PK |
TRAVEL_INTEGRATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRAVEL_INTEGRATION_ID | NUMBER | 18 | Yes | Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. Unique identifier of travel partner integration. | |
| TRAVEL_PARTNER_CODE | VARCHAR2 | 30 | Yes | Travel partner with which integration is associated. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CUSTOMER_ACCOUNT | VARCHAR2 | 60 | Customer account identifier assigned by travel partner. | ||
| CONTACT_PERSON | VARCHAR2 | 60 | Yes | Travel partner contact person for integration. | |
| CONTACT_PHONE | VARCHAR2 | 60 | Phone number of travel partner contact person for integration. | ||
| SUPER_SITE_NAME | VARCHAR2 | 60 | Name of super site, representing our company, used to connect to travel partner itinerary web service. | ||
| VALIDATION_RULE_SET_ID | NUMBER | 18 | Itinerary validation rule set used by the travel itinerary import validation process for travel partner integration. | ||
| BOOKING_LINK_OPTION_CODE | VARCHAR2 | 30 | Code that indicates whether booking link is a global single sign on link for the travel partner integration or a booking link at the travel partner site. | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATETIME1 | TIMESTAMP | ATTRIBUTE_DATETIME1 | |||
| ATTRIBUTE_DATETIME2 | TIMESTAMP | ATTRIBUTE_DATETIME2 | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| TRAVEL_PARTNER_NAME | VARCHAR2 | 120 | Name of the travel partner with which the integration is associated. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_TRAVEL_INTEGRATIONS_PK | Unique | FUSION_TS_TX_DATA | TRAVEL_INTEGRATION_ID |
| EXM_TRAVEL_INTEGRATIONS_U1 | Unique | FUSION_TS_TX_DATA | TRAVEL_PARTNER_CODE, TRAVEL_PARTNER_NAME |