eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OTA.OTA_DELEGATE_BOOKINGS

Object Details

Object Name:	OTA_DELEGATE_BOOKINGS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_DELEGATE_BOOKINGS
Subobject Name:
Status:	VALID

A student booking, also known as a delegate booking, records
enrollments for one or more places on a scheduled, program or one time
event. The enrollment can be:
1. Internal
2. External
To make an internal enrollment, you must enter the HR
organisation to which the student is assigned, and you must
enter either the student or contact name.
To make an external enrollment, you must enter the customer, and
enter either the student or contact name.
You can also enter the correspondent and their address and telephone
details for internal and external enrollments. You can also specify a
third part customer as the correspondent, along with the address
details.
A student enrollment has one of the following enrollment statuses
(which correspond to one of the system enrollment statuses):
Required
Waitlisted
Placed
Cancelled
Attended

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_DELEGATE_BOOKINGS_PK

BOOKING_ID

Unique Key: OTA_DELEGATE_BOOKINGS_UK1

LINE_ID

Unique Key: OTA_DELEGATE_BOOKINGS_UK2

QUOTE_LINE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_DELEGATE_BOOKINGS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BOOKING_ID
OTA_DELEGATE_BOOKINGS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
OTA_DELEGATE_BOOKINGS_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	QUOTE_LINE_ID
OTA_DELEGATE_BOOKINGS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_STATUS_TYPE_ID
OTA_DELEGATE_BOOKINGS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
OTA_DELEGATE_BOOKINGS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID
OTA_DELEGATE_BOOKINGS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
OTA_DELEGATE_BOOKINGS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_ID
OTA_DELEGATE_BOOKINGS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTACT_ADDRESS_ID
OTA_DELEGATE_BOOKINGS_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELEGATE_PERSON_ID
OTA_DELEGATE_BOOKINGS_N54	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_CUSTOMER_ID
OTA_DELEGATE_BOOKINGS_N55	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_CONTACT_ID
OTA_DELEGATE_BOOKINGS_N56	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THIRD_PARTY_ADDRESS_ID
OTA_DELEGATE_BOOKINGS_N57	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
OTA_DELEGATE_BOOKINGS_N58	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPONSOR_PERSON_ID
OTA_DELEGATE_BOOKINGS_N59	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SPONSOR_ASSIGNMENT_ID
OTA_DELEGATE_BOOKINGS_N60	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ADDRESS_ID
OTA_DELEGATE_BOOKINGS_N61	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELEGATE_ASSIGNMENT_ID
OTA_DELEGATE_BOOKINGS_N62	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DELEGATE_CONTACT_ID
OTA_DELEGATE_BOOKINGS_N64	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DAEMON_FLAG DAEMON_TYPE
OTA_DELEGATE_BOOKINGS_N65	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_JUSTIFICATION_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_DELEGATE_BOOKINGS	OTA_BOOKING_STATUS_TYPES	OTA_DELEGATE_BOOKINGS BOOKING_STATUS_TYPE_ID
OTA_DELEGATE_BOOKINGS	OTA_EVENTS	OTA_DELEGATE_BOOKINGS EVENT_ID
OTA_BOOKING_STATUS_HISTORIES	OTA_DELEGATE_BOOKINGS	OTA_BOOKING_STATUS_HISTORIES BOOKING_ID
OTA_FINANCE_LINES	OTA_DELEGATE_BOOKINGS	OTA_FINANCE_LINES BOOKING_ID
OTA_RESOURCE_ALLOCATIONS	OTA_DELEGATE_BOOKINGS	OTA_RESOURCE_ALLOCATIONS BOOKING_ID
OTA_TRAINING_PLAN_COSTS	OTA_DELEGATE_BOOKINGS	OTA_TRAINING_PLAN_COSTS BOOKING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
BOOKING_ID	NUMBER	(9)	Yes	The system generated surrogate key for this booking
BOOKING_STATUS_TYPE_ID	NUMBER	(9)	Yes	Foreign key to OTA_BOOKING_STATUS_TYPES
DELEGATE_PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F.
CONTACT_ID	NUMBER	(15)		Foreign key to RA_CONTACTS.
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
EVENT_ID	NUMBER	(9)	Yes	Foreign key to OTA_EVENTS
PERSON_ADDRESS_ID	NUMBER	(15)		Foreign key to PER_ADDRESSES or RA_ADDRESSES depending on whether the student is internal or external.
DELEGATE_CONTACT_ID	NUMBER	(15)		Foreign key to RA_CONTACTS which holds the external students ID.
DELEGATE_CONTACT_EMAIL	VARCHAR2	(240)		The external students emailID.
THIRD_PARTY_EMAIL	VARCHAR2	(240)		The emailID of the third party contact.
PERSON_ADDRESS_TYPE	VARCHAR2	(30)		An indication of the type of address held.
DELEGATE_ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ALL_ASSIGNMENTS_F which holds the Students assignment.
ORGANIZATION_ID	NUMBER	(9)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
SPONSOR_PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F which holds the ID of the sponsoring person.
SPONSOR_ASSIGNMENT_ID	NUMBER	(10)		Foreign key to PER_ALL_ASSIGNMENTS_F which holds the assignment ID of the sponsoring person.
CUSTOMER_ID	NUMBER	(15)		Foreign key to RA_CUSTOMERS.
AUTHORIZER_PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F
DATE_BOOKING_PLACED	DATE		Yes	The date on which this booking was placed.
INTERNAL_BOOKING_FLAG	VARCHAR2	(30)	Yes	States whether the booking is internal or not.
NUMBER_OF_PLACES	NUMBER	(9)	Yes	How many places are booking using this delegate booking.
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
ADMINISTRATOR	NUMBER	(9)		The person who took the booking (AOL User)
ATTENDANCE_RESULT	VARCHAR2	(256)		The result associated with this delegates attendance, eg: 80%
BOOKING_PRIORITY	VARCHAR2	(30)		The priority associated with this delegates booking.
COMMENTS	VARCHAR2	(2000)		Any textual details about this delegate booking.
CONTACT_ADDRESS_ID	NUMBER	(15)		The foriegn key to hold contact address details
CORESPONDENT	VARCHAR2	(30)		The person to whom correspondence is sent
DATE_STATUS_CHANGED	DATE			The date on which the status was changed
DELEGATE_CONTACT_FAX	VARCHAR2	(30)		Fax number for the delegate.
DELEGATE_CONTACT_PHONE	VARCHAR2	(30)		Telephone number for the number.
FAILURE_REASON	VARCHAR2	(30)		Reason for delegates unsuccessful attendance
LANGUAGE_ID	NUMBER	(9)		The foreign key to hold the preferred language of the delegate
SOURCE_OF_BOOKING	VARCHAR2	(30)		The source of the booking
SPECIAL_BOOKING_INSTRUCTIONS	VARCHAR2	(2000)		Any special instructions for the delegate. Diet etc.
SUCCESSFUL_ATTENDANCE_FLAG	VARCHAR2	(30)		A flag to show whether the delegate was successful or not
THIRD_PARTY_ADDRESS_ID	NUMBER	(15)		Foeign key to RA_ADDRESSES.
THIRD_PARTY_CONTACT_FAX	VARCHAR2	(30)		Fax number of third party e.g. training agency, liasing between training org. and client.
THIRD_PARTY_CONTACT_ID	NUMBER	(15)		Foreign key to RA_CONTACTS.
THIRD_PARTY_CONTACT_PHONE	VARCHAR2	(30)		Phone number of thrid party.
THIRD_PARTY_CUSTOMER_ID	NUMBER	(15)		Foreign key to RA_CUSTOMERS.
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column
TDB_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TDB_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TDB_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
LINE_ID	NUMBER	(15)		Foriegn key to OE_ORDER_LINES_ALL.
ORG_ID	NUMBER	(15)		The number of the Org ID that is associated to the enrollment through OM or OTA.
DAEMON_FLAG	VARCHAR2	(1)		The flag that indicates if the enrollment status has been cancelled. For OM integration to OTA, the daemon flag has to be equal to 'Y' for a cancellation.
DAEMON_TYPE	VARCHAR2	(1)		The type of cancellation for an enrollment.
OLD_EVENT_ID	NUMBER	(9)		Old Event Id. Foriegn key to OTA_EVENTS.
QUOTE_LINE_ID	NUMBER			Obsolete
INTERFACE_SOURCE	VARCHAR2	(30)		Source of the Enrollment data
TOTAL_TRAINING_TIME	VARCHAR2	(10)		Total training time from iLearning
CONTENT_PLAYER_STATUS	VARCHAR2	(30)		iLearning player status
SCORE	NUMBER			iLearning Test score
COMPLETED_CONTENT	NUMBER			Number of content modules completed from iLearning
TOTAL_CONTENT	NUMBER			Total content modules from iLearning
BOOKING_JUSTIFICATION_ID	NUMBER	(15)		Foreign key to OTA_BKNG_JUSTIFICATIONS_B
IS_HISTORY_FLAG	VARCHAR2	(1)		Determine where to show the class enrollment
IS_MANDATORY_ENROLLMENT	VARCHAR2	(1)		Determines if the enrollment is mandatory.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BOOKING_ID
,      BOOKING_STATUS_TYPE_ID
,      DELEGATE_PERSON_ID
,      CONTACT_ID
,      BUSINESS_GROUP_ID
,      EVENT_ID
,      PERSON_ADDRESS_ID
,      DELEGATE_CONTACT_ID
,      DELEGATE_CONTACT_EMAIL
,      THIRD_PARTY_EMAIL
,      PERSON_ADDRESS_TYPE
,      DELEGATE_ASSIGNMENT_ID
,      ORGANIZATION_ID
,      SPONSOR_PERSON_ID
,      SPONSOR_ASSIGNMENT_ID
,      CUSTOMER_ID
,      AUTHORIZER_PERSON_ID
,      DATE_BOOKING_PLACED
,      INTERNAL_BOOKING_FLAG
,      NUMBER_OF_PLACES
,      OBJECT_VERSION_NUMBER
,      ADMINISTRATOR
,      ATTENDANCE_RESULT
,      BOOKING_PRIORITY
,      COMMENTS
,      CONTACT_ADDRESS_ID
,      CORESPONDENT
,      DATE_STATUS_CHANGED
,      DELEGATE_CONTACT_FAX
,      DELEGATE_CONTACT_PHONE
,      FAILURE_REASON
,      LANGUAGE_ID
,      SOURCE_OF_BOOKING
,      SPECIAL_BOOKING_INSTRUCTIONS
,      SUCCESSFUL_ATTENDANCE_FLAG
,      THIRD_PARTY_ADDRESS_ID
,      THIRD_PARTY_CONTACT_FAX
,      THIRD_PARTY_CONTACT_ID
,      THIRD_PARTY_CONTACT_PHONE
,      THIRD_PARTY_CUSTOMER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TDB_INFORMATION_CATEGORY
,      TDB_INFORMATION1
,      TDB_INFORMATION2
,      TDB_INFORMATION3
,      TDB_INFORMATION4
,      TDB_INFORMATION5
,      TDB_INFORMATION6
,      TDB_INFORMATION7
,      TDB_INFORMATION8
,      TDB_INFORMATION9
,      TDB_INFORMATION10
,      TDB_INFORMATION11
,      TDB_INFORMATION12
,      TDB_INFORMATION13
,      TDB_INFORMATION14
,      TDB_INFORMATION15
,      TDB_INFORMATION16
,      TDB_INFORMATION17
,      TDB_INFORMATION18
,      TDB_INFORMATION19
,      TDB_INFORMATION20
,      LINE_ID
,      ORG_ID
,      DAEMON_FLAG
,      DAEMON_TYPE
,      OLD_EVENT_ID
,      QUOTE_LINE_ID
,      INTERFACE_SOURCE
,      TOTAL_TRAINING_TIME
,      CONTENT_PLAYER_STATUS
,      SCORE
,      COMPLETED_CONTENT
,      TOTAL_CONTENT
,      BOOKING_JUSTIFICATION_ID
,      IS_HISTORY_FLAG
,      IS_MANDATORY_ENROLLMENT
FROM OTA.OTA_DELEGATE_BOOKINGS;

Dependencies

[top of page]

OTA.OTA_DELEGATE_BOOKINGS does not reference any database object

OTA.OTA_DELEGATE_BOOKINGS is referenced by following:

APPS: OTA_DELEGATE_BOOKINGS; OTA_DELEGATE_BOOKINGS_WHO