[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
---|
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. |
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;
OTA.OTA_EVENTS does not reference any database object
OTA.OTA_EVENTS is referenced by following:
|
|
|