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_EVENT_ASSOCIATIONS

Object Details

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

You use event associations to restrict the list of customers and
students who can enroll onto an event. When an event is flagged as
restricted, you must enter who is eligible to attend the event before
you can make enrollments. You can enter internal or external
associations, but not both.
An internal association restricts which Oracle Human Resources people
you can enroll as students onto events. You do this by specifying
assignment criteria, such as:
1. Organisation
2. Job
3. Position
An external association restricts which external customers, and
subsequently students, you can enroll onto events.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_EVENT_ASSOCIATIONS_PK

EVENT_ASSOCIATION_ID

Unique Key: OTA_EVENT_ASSOCIATIONS_UK2

EVENT_ID
CUSTOMER_ID
ORGANIZATION_ID
JOB_ID
POSITION_ID
LEARNING_PATH_ID
CATEGORY_USAGE_ID
ACTIVITY_VERSION_ID
OFFERING_ID
PERSON_ID
PARTY_ID
FORUM_ID
CHAT_ID
CERTIFICATION_ID
USER_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_EVENT_ASSOCIATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ASSOCIATION_ID
OTA_EVENT_ASSOCIATIONS_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_ID CUSTOMER_ID ORGANIZATION_ID JOB_ID POSITION_ID LEARNING_PATH_ID CATEGORY_USAGE_ID ACTIVITY_VERSION_ID OFFERING_ID PERSON_ID PARTY_ID FORUM_ID CHAT_ID CERTIFICATION_ID USER_GROUP_ID
OTA_EVENT_ASSOCIATIONS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_ID
OTA_EVENT_ASSOCIATIONS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID
OTA_EVENT_ASSOCIATIONS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	JOB_ID
OTA_EVENT_ASSOCIATIONS_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POSITION_ID
OTA_EVENT_ASSOCIATIONS_N54	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID
OTA_EVENT_ASSOCIATIONS_N55	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEARNING_PATH_ID
OTA_EVENT_ASSOCIATIONS_N56	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_ID
OTA_EVENT_ASSOCIATIONS_N57	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_USAGE_ID
OTA_EVENT_ASSOCIATIONS_N58	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_VERSION_ID
OTA_EVENT_ASSOCIATIONS_N59	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FORUM_ID
OTA_EVENT_ASSOCIATIONS_N60	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHAT_ID
OTA_EVENT_ASSOCIATIONS_N61	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERTIFICATION_ID
OTA_EVENT_ASSOCIATIONS_N62	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFERING_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_EVENT_ASSOCIATIONS		OTA_EVENTS	OTA_EVENT_ASSOCIATIONS EVENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEA_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column
EVENT_ASSOCIATION_ID	NUMBER		Yes	The primary key of the event association
EVENT_ID	NUMBER	(9)		Foreign key to OTA_EVENTS
ORGANIZATION_ID	NUMBER	(9)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
JOB_ID	NUMBER	(15)		Foreign key to PER_JOBS.
POSITION_ID	VARCHAR2	(15)		Foreign key to PER_POSITIONS.
CUSTOMER_ID	NUMBER	(15)		Foreign key to RA_CUSTOMERS.
COMMENTS	VARCHAR2	(2000)		Comments
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
TEA_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
TEA_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column
TEA_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column
CATEGORY_USAGE_ID	NUMBER	(15)		Foreign Key to OTA_CATEGORY_USAGES
ACTIVITY_VERSION_ID	NUMBER	(15)		Foreign Key to OTA_ACTIVITY_VERSIONS
OFFERING_ID	NUMBER	(15)		Foreign Key to OTA_OFFERINGS
SELF_ENROLLMENT_FLAG	VARCHAR2	(1)		Determine whether the enrollment is self-enroll or standard approval is required.
MATCH_TYPE	VARCHAR2	(30)		Determine the Type of Match for the Learner Access.
PERSON_ID	NUMBER	(15)		Foreign Key to PER_ALL_PEOPLE_F
PARTY_ID	NUMBER	(15)		Foreign Key to HZ_PARTY
LEARNING_PATH_ID	NUMBER	(15)		Foreign Key to OTA_LEARNING_PATHS.
FORUM_ID	NUMBER	(15)		Foreign Key to OTA_FORUMS_B
CHAT_ID	NUMBER	(15)		Foreign Key to OTA_CHATS_B
CERTIFICATION_ID	NUMBER	(15)		Foreign key to OTA_CERTIFICATIONS_B
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)		Foreign Key to PER_ORG_STRUCTURE_VERSIONS
MANDATORY_ENROLLMENT_FLAG	VARCHAR2	(1)		Determines if the enrollment is a mandatory enrollment.
MANDATORY_ENROLLMENT_PREREQ	VARCHAR2	(1)		Indicates the prerequisite, if the enrollment is mandatory, else null.
USER_GROUP_ID	NUMBER			Foreign Key to OTA_USER_GROUPS_B

Query Text

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


SELECT TEA_INFORMATION1
,      EVENT_ASSOCIATION_ID
,      EVENT_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      CUSTOMER_ID
,      COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TEA_INFORMATION_CATEGORY
,      TEA_INFORMATION2
,      TEA_INFORMATION3
,      TEA_INFORMATION4
,      TEA_INFORMATION5
,      TEA_INFORMATION6
,      TEA_INFORMATION7
,      TEA_INFORMATION8
,      TEA_INFORMATION9
,      TEA_INFORMATION10
,      TEA_INFORMATION11
,      TEA_INFORMATION12
,      TEA_INFORMATION13
,      TEA_INFORMATION14
,      TEA_INFORMATION15
,      TEA_INFORMATION16
,      TEA_INFORMATION17
,      TEA_INFORMATION18
,      TEA_INFORMATION19
,      TEA_INFORMATION20
,      CATEGORY_USAGE_ID
,      ACTIVITY_VERSION_ID
,      OFFERING_ID
,      SELF_ENROLLMENT_FLAG
,      MATCH_TYPE
,      PERSON_ID
,      PARTY_ID
,      LEARNING_PATH_ID
,      FORUM_ID
,      CHAT_ID
,      CERTIFICATION_ID
,      ORG_STRUCTURE_VERSION_ID
,      MANDATORY_ENROLLMENT_FLAG
,      MANDATORY_ENROLLMENT_PREREQ
,      USER_GROUP_ID
FROM OTA.OTA_EVENT_ASSOCIATIONS;

Dependencies

[top of page]

OTA.OTA_EVENT_ASSOCIATIONS does not reference any database object

OTA.OTA_EVENT_ASSOCIATIONS is referenced by following:

APPS: OTA_EVENT_ASSOCIATIONS; OTA_EVENT_ASSOCIATIONS_WHO