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_EVENTS

Object Details

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

There are several different types of event:
1. A scheduled event is a specific instance of an activity version on
which you can enroll students and customers, and for which you can
book resources.
2. A session is a unit of time within a scheduled event for which you
can independently book resources.
3. A development event is a mechanism for scheduling employee time and
other resources required to develop new training activities or to
enhance existing ones.
4. A program is a group of events that are scheduled together.
Students enroll on the program which may require that they enroll on
some or all of the events within the program.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_EVENTS_PK

EVENT_ID

Unique Key: OTA_EVENTS_UK3

LINE_ID

Unique Key: OTA_EVENTS_UK4

OFFERING_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_EVENTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID
OTA_EVENTS_UK3	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_ID
OTA_EVENTS_UK4	NORMAL	UNIQUE	APPS_TS_TX_IDX	OFFERING_ID
OTA_EVENTS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_VERSION_ID
OTA_EVENTS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
OTA_EVENTS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
OTA_EVENTS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_EVENT_ID
OTA_EVENTS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PROJECT_ID
OTA_EVENTS_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRAINING_CENTER_ID
OTA_EVENTS_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_ID
OTA_EVENTS_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_OFFERING_ID
OTA_EVENTS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
OTA_EVENTS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE_ID
OTA_EVENTS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_EVENTS	OTA_ACTIVITY_VERSIONS	OTA_EVENTS ACTIVITY_VERSION_ID
OTA_EVENTS	OTA_EVENTS	OTA_EVENTS PARENT_EVENT_ID
OTA_ACT_CAT_INCLUSIONS	OTA_EVENTS	OTA_ACT_CAT_INCLUSIONS EVENT_ID
OTA_BOOKING_DEALS	OTA_EVENTS	OTA_BOOKING_DEALS EVENT_ID
OTA_DELEGATE_BOOKINGS	OTA_EVENTS	OTA_DELEGATE_BOOKINGS EVENT_ID
OTA_EVENTS	OTA_EVENTS	OTA_EVENTS PARENT_EVENT_ID
OTA_EVENT_ASSOCIATIONS	OTA_EVENTS	OTA_EVENT_ASSOCIATIONS EVENT_ID
OTA_PROGRAM_MEMBERSHIPS	OTA_EVENTS	OTA_PROGRAM_MEMBERSHIPS EVENT_ID
OTA_PROGRAM_MEMBERSHIPS	OTA_EVENTS	OTA_PROGRAM_MEMBERSHIPS PROGRAM_EVENT_ID
OTA_RESOURCE_BOOKINGS	OTA_EVENTS	OTA_RESOURCE_BOOKINGS EVENT_ID
OTA_TRAINING_PLAN_COSTS	OTA_EVENTS	OTA_TRAINING_PLAN_COSTS EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(9)	Yes	The system generated surrogatekey for this entry.
VENDOR_ID	NUMBER	(15)		Foreign key to PO_VENDORS.
ACTIVITY_VERSION_ID	NUMBER	(9)		Foreign key to OTA_ACTIVITY_VERSIONS
BUSINESS_GROUP_ID	NUMBER	(9)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS
ORGANIZATION_ID	NUMBER	(9)		Foreign key to HR_ALL_ORGANIZATION_UNITS
PARENT_EVENT_ID	NUMBER	(9)		Foreign key to OTA_EVENTS
EVENT_TYPE	VARCHAR2	(30)	Yes	The type of module activity.
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
TITLE	VARCHAR2	(80)	Yes	The name or title associated with this event.
ACTUAL_COST	NUMBER			The actual cost of the Event
BUDGET_COST	NUMBER			The Budgetted Cost for the Event
BUDGET_CURRENCY_CODE	VARCHAR2	(30)		The Currency of the Budgetted and Actual Cost
CENTRE	VARCHAR2	(30)		The centre at which this event is to take place.
COMMENTS	VARCHAR2	(2000)		Any special comments or notes for this entry. Descriptive only.
COURSE_END_DATE	DATE			The Date on which the Event Ends
COURSE_END_TIME	VARCHAR2	(5)		The end time of the event
COURSE_START_DATE	DATE			The Date on which the Event Starts
COURSE_START_TIME	VARCHAR2	(5)		The start time of the event
DURATION	NUMBER			The duration of the event measured in units specified in UNIT
DURATION_UNITS	VARCHAR2	(30)		The units in which the duration is measured
ENROLMENT_END_DATE	DATE			The closing date for bookings of this entry.
ENROLMENT_START_DATE	DATE			The earliest date on which bookings may be taken for this entry.
LANGUAGE_ID	NUMBER	(9)		The language in which the course is taught.
PUBLIC_EVENT_FLAG	VARCHAR2	(30)		An indication of whether an Event can have associations
USER_STATUS	VARCHAR2	(80)		User Definition of the Event Status
DEVELOPMENT_EVENT_TYPE	VARCHAR2	(30)		The user description of the developement type defined.
EVENT_STATUS	VARCHAR2	(30)		The status of this schedule entry.
PRICE_BASIS	VARCHAR2	(30)		Price basis of the Event : Student or Customer
SECURE_EVENT_FLAG	VARCHAR2	(30)		An indication of whether an event can be maintained by employees of the administering organization only.
BOOK_INDEPENDENT_FLAG	VARCHAR2	(30)		Whether the Scheduled can be indepepndent of a program
CURRENCY_CODE	VARCHAR2	(30)		The currency in which the standard price is defined.
MAXIMUM_ATTENDEES	NUMBER	(9)		The maximum number of students who may attend
MAXIMUM_INTERNAL_ATTENDEES	NUMBER	(9)		The maximum number of internal students
MINIMUM_ATTENDEES	NUMBER	(9)		The minimum number of students for this entry to be viable.
STANDARD_PRICE	NUMBER			The standard price per (price basis) booking for this entry
CATEGORY_CODE	VARCHAR2	(30)		Identifies the programme of activities for the event group
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
EVT_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
EVT_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
EVT_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
PROJECT_ID	NUMBER	(15)		Foreign Key to PA_PROJECTS_ALL.
OWNER_ID	NUMBER	(10)		Foriegn key to PER_ALL_PEOPLE_F.
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.
TRAINING_CENTER_ID	NUMBER	(15)		Foriegn key to HR_ALL_ORGANIZATION_UNITS.
LOCATION_ID	NUMBER	(15)		Foriegn key to HR_LOCATIONS.
OFFERING_ID	NUMBER			No longer being used
TIMEZONE	VARCHAR2	(30)		Timezone of the Class.
PARENT_OFFERING_ID	NUMBER	(9)		Foreign key to OTA_OFFERINGS
DATA_SOURCE	VARCHAR2	(30)		The module that Class originated in.

Query Text

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


SELECT EVENT_ID
,      VENDOR_ID
,      ACTIVITY_VERSION_ID
,      BUSINESS_GROUP_ID
,      ORGANIZATION_ID
,      PARENT_EVENT_ID
,      EVENT_TYPE
,      OBJECT_VERSION_NUMBER
,      TITLE
,      ACTUAL_COST
,      BUDGET_COST
,      BUDGET_CURRENCY_CODE
,      CENTRE
,      COMMENTS
,      COURSE_END_DATE
,      COURSE_END_TIME
,      COURSE_START_DATE
,      COURSE_START_TIME
,      DURATION
,      DURATION_UNITS
,      ENROLMENT_END_DATE
,      ENROLMENT_START_DATE
,      LANGUAGE_ID
,      PUBLIC_EVENT_FLAG
,      USER_STATUS
,      DEVELOPMENT_EVENT_TYPE
,      EVENT_STATUS
,      PRICE_BASIS
,      SECURE_EVENT_FLAG
,      BOOK_INDEPENDENT_FLAG
,      CURRENCY_CODE
,      MAXIMUM_ATTENDEES
,      MAXIMUM_INTERNAL_ATTENDEES
,      MINIMUM_ATTENDEES
,      STANDARD_PRICE
,      CATEGORY_CODE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      EVT_INFORMATION_CATEGORY
,      EVT_INFORMATION1
,      EVT_INFORMATION2
,      EVT_INFORMATION3
,      EVT_INFORMATION4
,      EVT_INFORMATION5
,      EVT_INFORMATION6
,      EVT_INFORMATION7
,      EVT_INFORMATION8
,      EVT_INFORMATION9
,      EVT_INFORMATION10
,      EVT_INFORMATION11
,      EVT_INFORMATION12
,      EVT_INFORMATION13
,      EVT_INFORMATION14
,      EVT_INFORMATION15
,      EVT_INFORMATION16
,      EVT_INFORMATION17
,      EVT_INFORMATION18
,      EVT_INFORMATION19
,      EVT_INFORMATION20
,      PROJECT_ID
,      OWNER_ID
,      LINE_ID
,      ORG_ID
,      TRAINING_CENTER_ID
,      LOCATION_ID
,      OFFERING_ID
,      TIMEZONE
,      PARENT_OFFERING_ID
,      DATA_SOURCE
FROM OTA.OTA_EVENTS;

Dependencies

[top of page]

OTA.OTA_EVENTS does not reference any database object

OTA.OTA_EVENTS is referenced by following:

APPS: OTA_EVENTS; OTA_EVENTS_WHO