Search Results ota_booking_status_types

Overview

The OTA_BOOKING_STATUS_TYPES table is a core reference table within the Oracle E-Business Suite Learning Management (OTA) module. It serves as the master repository for all enrollment statuses used in the system. Its primary role is to define the mapping between user-defined, business-meaningful statuses (e.g., "Applied," "Confirmed," "Cancelled") and the underlying system statuses that control process logic and workflow. This decoupling allows organizations to customize the enrollment lifecycle terminology to match their internal processes while maintaining a consistent system-level framework for application behavior.

Key Information Stored

The table's structure centers on defining and classifying each booking status. The primary identifier is the BOOKING_STATUS_TYPE_ID, a unique system-generated key. The NAME column stores the user-defined status name, which is unique within a BUSINESS_GROUP_ID as enforced by the OTA_BOOKING_STATUS_TYPES_UK2 unique key. This design supports multi-org implementations where different business units may have distinct status naming conventions. A critical column is the one storing the corresponding SYSTEM_STATUS (implied by the description, though not explicitly listed in the provided metadata), which categorizes the user status into a system-controlled type such as 'ATTENDED', 'CANCELLED', 'PENDING', or 'WAITLISTED'. This system status drives core module functionality, including reporting, resource allocation, and financial implications.

Common Use Cases and Queries

This table is essential for any process involving enrollment status tracking, reporting, and validation. A common use case is generating a list of all active booking statuses for a specific business group to populate an LOV in a custom form or report. For reporting, a typical query joins this table to enrollment history or booking tables to translate system IDs into meaningful status names. For instance, to analyze enrollment trends, one might query the count of bookings per user-defined status.

• Sample Query: List all statuses for a business group:
  SELECT name, system_status FROM ota_booking_status_types WHERE business_group_id = &business_group ORDER BY name;
• Sample Query: Find bookings with a specific system status (e.g., CANCELLED):
  SELECT d.booking_number, bst.name FROM ota_delegate_bookings d, ota_booking_status_types bst WHERE d.booking_status_type_id = bst.booking_status_type_id AND bst.system_status = 'CANCELLED';

Related Objects

The OTA_BOOKING_STATUS_TYPES table is referenced by several key transactional and historical tables, as indicated by its foreign key relationships. The OTA_DELEGATE_BOOKINGS table holds the current enrollment status for a learner, directly referencing a row in this table. The OTA_BOOKING_STATUS_HISTORIES table maintains an audit trail of status changes for a booking, with each history record pointing to a status type. Additionally, the OTA_BOOKING_STATUS_EXCL table likely defines rules for invalid status transitions, ensuring data integrity in the enrollment lifecycle. These relationships underscore the table's central role in managing the complete enrollment status framework.