EXM_TRAVEL_ITINERARIES
This table contains summary information about imported travel itineraries from travel partners.
Details
-
Schema: FUSION
-
Object owner: EXM
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
EXM_TRAVEL_ITINERARIES_PK |
TRAVEL_ITINERARY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRAVEL_ITINERARY_ID | NUMBER | 18 | Yes | Unique Identifier of a travel itinerary. | |
| TRAVEL_PARTNER_TRIP_NUMBER | VARCHAR2 | 32 | Yes | Trip in the travel partner's system with which travel itinerary is associated with. | |
| 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. | |
| ITINERARY_RECORD_LOCATOR | VARCHAR2 | 32 | Yes | Travel itinerary in the travel partner's system, which is passenger name record for itineraries booked from global distribution system or rail confirmation number for rail itineraries. | |
| TRIP_ID | NUMBER | 18 | Business trip for which itinerary belongs to. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| TRAVEL_INTEGRATION_ID | NUMBER | 18 | Yes | Travel Partner Integration from which itinerary is imported. | |
| BOOKING_SITE_ID | NUMBER | 18 | Booking site from which itinerary was booked. | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status of imported travel itinerary, such as Active for itineraries that do not contain AIR or RAIL reservations, Ticketed for itineraries that contain AIR or RAIL itineraries, and Cancelled for itineraries that are cancelled. | |
| INITIAL_DESTINATION | VARCHAR2 | 240 | Initial destination city name for itinerary, which is set to the first departure location for reservation items belonging to this itinerary. This column is used to populat the trip location. For multiple destination trips, first and last destination locations are displayed. | ||
| FINAL_DESTINATION | VARCHAR2 | 240 | Final destination city name for itinerary, which is set to last destination location for reservation items belonging to this itinerary. This column is used to populate the trip location. For multiple destination trips, first and last destination locations are displayed. | ||
| START_DATE | DATE | Start date of this itinerary will be set to the earliest date among the reservation items belonging to this itinerary in local timezone. | |||
| END_DATE | DATE | End date of this itinerary will be set to the latest date among the reservation items belonging to this itinerary in local timezone. | |||
| FIRST_NAME | VARCHAR2 | 120 | Yes | First name of the traveler in this reservation. | |
| LAST_NAME | VARCHAR2 | 120 | Yes | Last name of the traveler in this reservation. | |
| PERSON_ID | NUMBER | 18 | Traveler as a person in Oracle Fusion Human Resources. | ||
| EMPLOYEE_NUMBER | VARCHAR2 | 64 | Employee number of traveler for reservation. | ||
| BOOKING_DATE_TIME | TIMESTAMP | Date and time in UTC when this Itinerary was created or modified in the global distribution system or travel partner system. | |||
| AIR_UPDATED_FLAG | VARCHAR2 | 1 | Indicates whether air reservation in itinerary has changed from initial import. | ||
| HOTEL_UPDATED_FLAG | VARCHAR2 | 1 | Indicates whether hotel reservation in itinerary has changed from initial import. | ||
| RAIL_UPDATED_FLAG | VARCHAR2 | 1 | Indicates whether rail reservation in itinerary has changed from initial import. | ||
| VEHICLE_UPDATED_FLAG | VARCHAR2 | 1 | Indicates whether vehicle rental reservation in itinerary has changed from initial import. | ||
| 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 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATETIME2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| 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. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| EXM_TRAVEL_ITINERARIES_PK | Unique | Default | TRAVEL_ITINERARY_ID |
| EXM_TRAVEL_ITINERARIES_U1 | Unique | Default | TRAVEL_PARTNER_TRIP_NUMBER |