FND Design Data [Home] [Help]

Table: OTA_BOOKING_STATUS_TYPES

Product: OTA - Learning Management
Description: Booking status types contain a list of user-defined enrollment statuses, along with their corresponding system statuses.
Implementation/DBA Data: TableOTA.OTA_BOOKING_STATUS_TYPES
Primary Key: OTA_BOOKING_STATUS_TYPES_PK
  1. ColumnBOOKING_STATUS_TYPE_ID
Primary Key: OTA_BOOKING_STATUS_TYPES_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
TableOTA_BOOKING_STATUS_EXCL FK Joins to OTA_BOOKING_STATUS_TYPES OTA_BOOKING_STATUS_EXCL.BOOKING_STATUS_TYPE_ID
TableOTA_BOOKING_STATUS_HISTORIES FK Joins to OTA_BOOKING_STATUS_TYPES OTA_BOOKING_STATUS_HISTORIES.BOOKING_STATUS_TYPE_ID
TableOTA_DELEGATE_BOOKINGS FK Joins to OTA_BOOKING_STATUS_TYPES OTA_DELEGATE_BOOKINGS.BOOKING_STATUS_TYPE_ID