Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - OTA Tables and Views

TABLE - OTA.OTA_ACTIVITY_DEFINITIONS

TABLE - OTA.OTA_ACTIVITY_DEFINITIONS_TL

TABLE - OTA.OTA_ACTIVITY_VERSIONS

TABLE - OTA.OTA_ACTIVITY_VERSIONS_TL

TABLE - OTA.OTA_ACT_CAT_INCLUSIONS

TABLE - OTA.OTA_ANNOUNCEMENTS

TABLE - OTA.OTA_ANNOUNCEMENTS_TL

TABLE - OTA.OTA_ATTEMPTS

TABLE - OTA.OTA_BKNG_JUSTIFICATIONS_B

TABLE - OTA.OTA_BKNG_JUSTIFICATIONS_TL

TABLE - OTA.OTA_BOOKING_DEALS

TABLE - OTA.OTA_BOOKING_STATUS_EXCL

TABLE - OTA.OTA_BOOKING_STATUS_HISTORIES

TABLE - OTA.OTA_BOOKING_STATUS_TYPES

TABLE - OTA.OTA_BOOKING_STATUS_TYPES_TL

TABLE - OTA.OTA_BULK_ENR_REQUESTS

TABLE - OTA.OTA_BULK_ENR_REQ_MEMBERS

TABLE - OTA.OTA_CATEGORY_USAGES

TABLE - OTA.OTA_CATEGORY_USAGES_TL

TABLE - OTA.OTA_CERTIFICATIONS_B

TABLE - OTA.OTA_CERTIFICATIONS_TL

TABLE - OTA.OTA_CERTIFICATION_MEMBERS

TABLE - OTA.OTA_CERT_CAT_INCLUSIONS

TABLE - OTA.OTA_CERT_ENROLLMENTS

TABLE - OTA.OTA_CERT_MBR_ENROLLMENTS

TABLE - OTA.OTA_CERT_PRD_ENROLLMENTS

TABLE - OTA.OTA_CHATS_B

TABLE - OTA.OTA_CHATS_TL

TABLE - OTA.OTA_CHAT_MESSAGES

TABLE - OTA.OTA_CHAT_OBJ_INCLUSIONS

TABLE - OTA.OTA_CHAT_USERS

TABLE - OTA.OTA_CMI_ADAPTERS

TABLE - OTA.OTA_COMPETENCE_LANGUAGES

TABLE - OTA.OTA_CONFERENCES

TABLE - OTA.OTA_CONFERENCE_SERVERS_B

TABLE - OTA.OTA_CONFERENCE_SERVERS_TL

TABLE - OTA.OTA_CONTENT_SERVERS

TABLE - OTA.OTA_COURSE_PREREQUISITES

TABLE - OTA.OTA_CROSS_CHARGES

TABLE - OTA.OTA_DELEGATE_BOOKINGS

TABLE - OTA.OTA_EVALUATIONS

TABLE - OTA.OTA_EVENTS

TABLE - OTA.OTA_EVENTS_TL

TABLE - OTA.OTA_EVENT_ASSOCIATIONS

TABLE - OTA.OTA_FINANCE_HEADERS

TABLE - OTA.OTA_FINANCE_LINES

TABLE - OTA.OTA_FORUMS_B

TABLE - OTA.OTA_FORUMS_TL

TABLE - OTA.OTA_FORUM_MESSAGES

TABLE - OTA.OTA_FORUM_THREADS

TABLE - OTA.OTA_FRM_NOTIF_SUBSCRIBERS

TABLE - OTA.OTA_FRM_OBJ_INCLUSIONS

TABLE - OTA.OTA_HR_GL_FLEX_MAPS

TABLE - OTA.OTA_ILN_XML_PROCESSES

TABLE - OTA.OTA_IMPORT_HISTORIES

TABLE - OTA.OTA_LEARNING_OBJECTS

TABLE - OTA.OTA_LEARNING_PATHS

TABLE - OTA.OTA_LEARNING_PATHS_TL

TABLE - OTA.OTA_LEARNING_PATH_MEMBERS

TABLE - OTA.OTA_LO_FOLDERS

TABLE - OTA.OTA_LO_SCORM_OBJECTIVES

TABLE - OTA.OTA_LP_CAT_INCLUSIONS

TABLE - OTA.OTA_LP_ENROLLMENTS

TABLE - OTA.OTA_LP_MEMBER_ENROLLMENTS

TABLE - OTA.OTA_LP_SECTIONS

TABLE - OTA.OTA_LP_SECTIONS_TL

TABLE - OTA.OTA_MANDATORY_ENR_REQUESTS

TABLE - OTA.OTA_MANDATORY_ENR_REQ_MEMBERS

TABLE - OTA.OTA_NOTRNG_HISTORIES

TABLE - OTA.OTA_OFFERINGS

TABLE - OTA.OTA_OFFERINGS_TL

TABLE - OTA.OTA_OPEN_FC_ENROLLMENTS

TABLE - OTA.OTA_PERFORMANCES

TABLE - OTA.OTA_PREREQUISITES

TABLE - OTA.OTA_PRICE_LISTS

TABLE - OTA.OTA_PRICE_LIST_ENTRIES

TABLE - OTA.OTA_PROGRAM_MEMBERSHIPS

TABLE - OTA.OTA_PVT_FRM_THREAD_USERS

TABLE - OTA.OTA_QBANK_QUESTIONS

TABLE - OTA.OTA_QUESTIONS

TABLE - OTA.OTA_QUESTION_BANKS

TABLE - OTA.OTA_RESOURCE_ALLOCATIONS

TABLE - OTA.OTA_RESOURCE_BOOKINGS

TABLE - OTA.OTA_RESOURCE_DEFINITIONS

TABLE - OTA.OTA_RESOURCE_USAGES

TABLE - OTA.OTA_RESPONSE_TYPES

TABLE - OTA.OTA_RESPONSE_VALUES

TABLE - OTA.OTA_SCORM_OBJECTIVES

TABLE - OTA.OTA_SCORM_OBJ_ATTEMPTS

TABLE - OTA.OTA_SCORM_OBJ_PERFS

TABLE - OTA.OTA_SECTION_RULES

TABLE - OTA.OTA_SKILL_PROVISIONS

TABLE - OTA.OTA_SUPPLIABLE_RESOURCES

TABLE - OTA.OTA_SUPPLIABLE_RESOURCES_TL

TABLE - OTA.OTA_TESTS

TABLE - OTA.OTA_TEST_QUESTIONS

TABLE - OTA.OTA_TEST_SECTIONS

TABLE - OTA.OTA_TITLE_CONVERSIONS

TABLE - OTA.OTA_TP_MEASUREMENT_TYPES

TABLE - OTA.OTA_TRAINING_PLANS

TABLE - OTA.OTA_TRAINING_PLAN_COSTS

TABLE - OTA.OTA_TRAINING_PLAN_MEMBERS

TABLE - OTA.OTA_UPGRADE_LOG

TABLE - OTA.OTA_USER_GROUPS_B

TABLE - OTA.OTA_USER_GROUPS_TL

TABLE - OTA.OTA_USER_GROUP_ELEMENTS

TABLE - OTA.OTA_UTEST_QUESTIONS

TABLE - OTA.OTA_UTEST_RESPONSES

TABLE - OTA.OTA_VENDOR_SUPPLIES

VIEW - APPS.OTA_ACTIVITY_DEFINITIONS_V

VIEW - APPS.OTA_ACTIVITY_DEFINITIONS_VL

VIEW - APPS.OTA_ACTIVITY_VERSIONS_V

VIEW - APPS.OTA_ACTIVITY_VERSIONS_VL

VIEW - APPS.OTA_ACT_CAT_INCLUSIONS_V

VIEW - APPS.OTA_ANNOUNCEMENTS_VL

VIEW - APPS.OTA_BKNG_JUSTIFICATIONS_VL

VIEW - APPS.OTA_BOOKING_DEALS_V

VIEW - APPS.OTA_BOOKING_STATUS_HISTORIES_V

VIEW - APPS.OTA_BOOKING_STATUS_TYPES_VL

VIEW - APPS.OTA_CATEGORY_USAGES_V

VIEW - APPS.OTA_CATEGORY_USAGES_V1

VIEW - APPS.OTA_CATEGORY_USAGES_VL

VIEW - APPS.OTA_CERTIFICATIONS_VL

VIEW - APPS.OTA_CHATS_VL

VIEW - APPS.OTA_COMPETENCE_LANGUAGES_V

VIEW - APPS.OTA_CONFERENCE_SERVERS_VL

VIEW - APPS.OTA_CROSS_CHARGES_V

VIEW - APPS.OTA_CTRNG_HISTORIES_V

VIEW - APPS.OTA_CUSTOMER_ADDRESSES_V

VIEW - APPS.OTA_CUSTOMER_CONTACTS_V

VIEW - APPS.OTA_DELEGATE_BOOKINGS_V

VIEW - APPS.OTA_DISCOUNT_DEALS_V

VIEW - APPS.OTA_EVENTS_V

VIEW - APPS.OTA_EVENTS_VL

VIEW - APPS.OTA_EVENT_ASSOCIATIONS_V

VIEW - APPS.OTA_EVENT_ASSOCIATIONS_V2

VIEW - APPS.OTA_EVENT_ASSOCIAT_BILLING_V

VIEW - APPS.OTA_EVENT_SEARCH_V

VIEW - APPS.OTA_EVENT_SEARCH_V2

VIEW - APPS.OTA_FINANCE_HEADERS_V

VIEW - APPS.OTA_FINANCE_LINES_V

VIEW - APPS.OTA_FORUMS_VL

VIEW - APPS.OTA_LEARNING_PATHS_VL

VIEW - APPS.OTA_LETTER_REQUEST_LINES_V

VIEW - APPS.OTA_LP_SECTIONS_VL

VIEW - APPS.OTA_NOTRNG_HISTORIES_V

VIEW - APPS.OTA_OFFERINGS_VL

VIEW - APPS.OTA_PRE_PURCHASE_DEALS_V

VIEW - APPS.OTA_PRICE_LISTS_V

VIEW - APPS.OTA_PRICE_LIST_ENTRIES_V

VIEW - APPS.OTA_PROGRAM_MEMBERSHIPS_V

VIEW - APPS.OTA_RESOURCE_BOOKINGS_V

VIEW - APPS.OTA_RESOURCE_USAGES_V

VIEW - APPS.OTA_SKILLS_V

VIEW - APPS.OTA_SKILL_PROVISIONS_V

VIEW - APPS.OTA_STUDENTS_V

VIEW - APPS.OTA_STUDENT_TITLES_V

VIEW - APPS.OTA_SUPPLIABLE_RESOURCES_V

VIEW - APPS.OTA_SUPPLIABLE_RESOURCES_VL

VIEW - APPS.OTA_TEST_SECTIONS_V

VIEW - APPS.OTA_TP_MEASUREMENT_TYPES_V

VIEW - APPS.OTA_TRAINING_COST_LEVELS_V

VIEW - APPS.OTA_TRAINING_PLANS_V

VIEW - APPS.OTA_TRAINING_PLAN_BUDGETS_V

VIEW - APPS.OTA_TRAINING_PLAN_COSTS_V

VIEW - APPS.OTA_TRAINING_PLAN_MEMBERS_V

VIEW - APPS.OTA_UTEST_QUESTIONS_V

VIEW - APPS.OTA_VENDORS_V

VIEW - APPS.OTA_VENDOR_ADDRESSES_V

VIEW - APPS.OTA_VENDOR_CONTACTS_V

VIEW - APPS.OTFV_ACTIVITY_CATEGORIES

VIEW - APPS.OTFV_COMBINED_TRAINING_HISTORY

VIEW - APPS.OTFV_COST_TRANSFER

VIEW - APPS.OTFV_CUST_RESTRICTED_EVENTS

VIEW - APPS.OTFV_DELIVERED_COMPETENCES

VIEW - APPS.OTFV_ENROLLED_EVENTS

VIEW - APPS.OTFV_ENROLLMENT_AGREEMENTS

VIEW - APPS.OTFV_ENROLLMENT_STATUSES

VIEW - APPS.OTFV_ENROLLMENT_STATUS_HISTORY

VIEW - APPS.OTFV_EVENTS_WITHOUT_TRAINER

VIEW - APPS.OTFV_EVENTS_WITHOUT_VENUE

VIEW - APPS.OTFV_EVENTS_WITH_TRAINER

VIEW - APPS.OTFV_EVENTS_WITH_VENUE

VIEW - APPS.OTFV_EVENT_COMPETENCES

VIEW - APPS.OTFV_EXT_TRAINING_EVENT_ENROLS

VIEW - APPS.OTFV_FINANCE_HEADERS

VIEW - APPS.OTFV_FINANCE_LINES

VIEW - APPS.OTFV_HR_RESTRICTED_EVENTS

VIEW - APPS.OTFV_INT_TRAINING_EVENT_ENROLS

VIEW - APPS.OTFV_MISSING_REQ_RESOURCES

VIEW - APPS.OTFV_ONE_TIME_TRAINING_EVENTS

VIEW - APPS.OTFV_OVERBOOKED_RESOURCES

VIEW - APPS.OTFV_PRICE_LISTS

VIEW - APPS.OTFV_PRICE_LIST_ENTRIES

VIEW - APPS.OTFV_RESOURCES

VIEW - APPS.OTFV_RESOURCES_BOOKED

VIEW - APPS.OTFV_RESOURCE_CHECKLIST

VIEW - APPS.OTFV_SCHEDULED_TRAINING_EVENTS

VIEW - APPS.OTFV_SKILL_PROVISIONS

VIEW - APPS.OTFV_TOTAL_ENROLLMENTS

VIEW - APPS.OTFV_TRAINING_ACTIVITIES

VIEW - APPS.OTFV_TRAINING_AMOUNT

VIEW - APPS.OTFV_TRAINING_EVENTS

VIEW - APPS.OTFV_TRAINING_EVENT_CATEGORIES

VIEW - APPS.OTFV_TRAINING_EVENT_SESSIONS

VIEW - APPS.OTV_ACTIVITIES

VIEW - APPS.OTV_EVENT_ASSOCIATIONS

VIEW - APPS.OTV_ONE_TIME_EVENTS

VIEW - APPS.OTV_SCHEDULED_EVENTS

VIEW - APPS.OTV_SESSIONS

VIEW - APPS.OTV_TRAINING_COMPETENCE

Table: OTA_ACTIVITY_DEFINITIONS

Primary Key: OTA_ACTIVITY_DEFINITIONS_PK

1. ACTIVITY_ID

Primary Key: OTA_ACTIVITY_DEFINITIONS_UK2

1. NAME
2. BUSINESS_GROUP_ID

Foreign Keys to this table:

Comments

An activity is any educational offering that is designed to improve a
students qualification, competencies, or experience. Examples: a
training cource, on-job-training, structured work experience. An
activity definition is made up of a number of versions, each of which
defines the nature of the educational offering. The activity
definition determines whether the version may run concurrently or not.

Primary Key: OTA_ACTIVITY_DEFINITIONS_PK

1. ACTIVITY_ID

Indexes

Columns

[top of page]

OTA.OTA_ACTIVITY_DEFINITIONS does not reference any database object

OTA.OTA_ACTIVITY_DEFINITIONS is referenced by following:

APPS

SYNONYM - OTA_ACTIVITY_DEFINITIONS

TRIGGER - OTA_ACTIVITY_DEFINITIONS_WHO

[top of page]

Table: OTA_ACTIVITY_DEFINITIONS_TL

Primary Key: OTA_ACTIVITY_DEFINITIONS_TL_PK

1. ACTIVITY_ID
2. LANGUAGE

Comments

This table only contains a subset of the columns from the base table.
Contains translated Name and description of Activity Definition.

Primary Key: OTA_ACTIVITY_DEFINITIONS_TL_PK

1. ACTIVITY_ID
2. LANGUAGE

Indexes

Columns

[top of page]

OTA.OTA_ACTIVITY_DEFINITIONS_TL does not reference any database object

OTA.OTA_ACTIVITY_DEFINITIONS_TL is referenced by following:

APPS

TRIGGER - OTA_ACTIVITY_DEFINIT041313_WHO

SYNONYM - OTA_ACTIVITY_DEFINITIONS_TL

[top of page]

Table: OTA_ACTIVITY_VERSIONS

Primary Key: OTA_ACTIVITY_VERSIONS_PK

1. ACTIVITY_VERSION_ID

Primary Key: OTA_ACTIVITY_VERSIONS_UK2

1. ACTIVITY_ID
2. VERSION_NAME

Primary Key: OTA_ACTIVITY_VERSIONS_UK5

1. RCO_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This contains metadata of courses, such as objectives, intended
audience , numbers of students that may attend any class based on the
course, and actual and budgeted costs.
A Course may be superseded by another version or it may
supersede one itself. The validity dates on the course is
available for scheduling as a class.
A course may belong to one or more categories.
A course can therefore be classified for searching
elsewhere in the system, it can be identified as being part of a
program of courses, or it can be identified as part of a package of
course that are to have price discounts applied.
A course can also be part of a learning path.

Primary Key: OTA_ACTIVITY_VERSIONS_PK

1. ACTIVITY_VERSION_ID

Unique Key: OTA_ACTIVITY_VERSIONS_UK5

1. RCO_ID

Indexes

Columns

[top of page]

OTA.OTA_ACTIVITY_VERSIONS does not reference any database object

OTA.OTA_ACTIVITY_VERSIONS is referenced by following:

APPS

SYNONYM - OTA_ACTIVITY_VERSIONS

TRIGGER - OTA_ACTIVITY_VERSIONS_WHO

[top of page]

Table: OTA_ACTIVITY_VERSIONS_TL

Primary Key: OTA_ACTIVITY_VERSIONS_TL_PK

1. ACTIVITY_VERSION_ID
2. LANGUAGE

Comments

This table only contains a subset of the columns from the base table.
Contains translated name, description objective and intended audience of courses.

Primary Key: OTA_ACTIVITY_VERSIONS_TL_PK

1. ACTIVITY_VERSION_ID
2. LANGUAGE

Indexes

Columns

[top of page]

OTA.OTA_ACTIVITY_VERSIONS_TL does not reference any database object

OTA.OTA_ACTIVITY_VERSIONS_TL is referenced by following:

APPS

TRIGGER - OTA_ACTIVITY_VERSION041318_WHO

SYNONYM - OTA_ACTIVITY_VERSIONS_TL

[top of page]

Table: OTA_ACT_CAT_INCLUSIONS

Primary Key: OTA_ACT_CAT_INCLUSIONS_UK2

1. ACTIVITY_VERSION_ID
2. EVENT_ID
3. ACTIVITY_CATEGORY

Primary Key: OTA_ACT_CAT_INCLUSIONS_UK3

1. ACTIVITY_VERSION_ID
2. EVENT_ID
3. CATEGORY_USAGE_ID

Foreign Keys from this table:

Comments

A course category inclusion specifies that a course is within a particular type of category.

Unique Key: OTA_ACT_CAT_INCLUSIONS_UK3

1. ACTIVITY_VERSION_ID
2. EVENT_ID
3. CATEGORY_USAGE_ID

Indexes

Columns

[top of page]

OTA.OTA_ACT_CAT_INCLUSIONS does not reference any database object

OTA.OTA_ACT_CAT_INCLUSIONS is referenced by following:

APPS

SYNONYM - OTA_ACT_CAT_INCLUSIONS

TRIGGER - OTA_ACT_CAT_INCLUSIONS_WHO

[top of page]

Table: OTA_ANNOUNCEMENTS

Primary Key: OTA_ANNOUNCEMENTS_PK

1. ANNOUNCEMENT_ID

Comments

Announcements can contain text or HTML to deliver timely information to learners.
They are only displayed to learners during the start and end dates specified by the administrator.
The text is displayed to all learners in the business group after logging into Oracle iLearning.

Indexes

Columns

[top of page]

OTA.OTA_ANNOUNCEMENTS does not reference any database object

OTA.OTA_ANNOUNCEMENTS is referenced by following:

APPS

SYNONYM - OTA_ANNOUNCEMENTS

TRIGGER - OTA_ANNOUNCEMENTS_WHO

[top of page]

Table: OTA_ANNOUNCEMENTS_TL

Comments

This table only contains a subset of the columns from the base table.
Contains translated title and body of the announcement.

Indexes

Columns

[top of page]

OTA.OTA_ANNOUNCEMENTS_TL does not reference any database object

OTA.OTA_ANNOUNCEMENTS_TL is referenced by following:

APPS

SYNONYM - OTA_ANNOUNCEMENTS_TL

TRIGGER - OTA_ANNOUNCEMENTS_TL041320_WHO

[top of page]

Table: OTA_ATTEMPTS

Primary Key: OTA_ATTEMPTS_PK

1. ATTEMPT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This table is only used for online learning against learning objects and tests.
It contains status, score, time, and other system information that describes what a learner achieved when playing a particular learning object or test.
There is one row created for each leraning object/test a learner plays from within the Oracle iLearning player.
The last attempt is sometimes used to calculate the most recent status for the performance record.
It is also used to determine when a learner can take a test (after their last failed attempt) when an administrator has defined maximum number of attempts against a test.
An internal_state of 'A' indicates not all information was written to the attempt.

Indexes

Columns

[top of page]

OTA.OTA_ATTEMPTS does not reference any database object

OTA.OTA_ATTEMPTS is referenced by following:

APPS

SYNONYM - OTA_ATTEMPTS

TRIGGER - OTA_ATTEMPTS_WHO

[top of page]

Table: OTA_BKNG_JUSTIFICATIONS_B

Primary Key: OTA_BKNG_JUSTIFICATIONS_B_PK

1. BOOKING_JUSTIFICATION_ID

Comments

This is used by watilist optimization feature to default an enrollment priority level. Admin can define their own justification name with enrollment priority level attached to it. Learners can select a value when enrolling into class.

Indexes

Columns

[top of page]

OTA.OTA_BKNG_JUSTIFICATIONS_B does not reference any database object

OTA.OTA_BKNG_JUSTIFICATIONS_B is referenced by following:

APPS

SYNONYM - OTA_BKNG_JUSTIFICATIONS_B

TRIGGER - OTA_BKNG_JUSTIFICATIONS_B_WHO

[top of page]

Table: OTA_BKNG_JUSTIFICATIONS_TL

Primary Key: OTA_BKNG_JUSTIFICATIONS_TL_PK

1. BOOKING_JUSTIFICATION_ID
2. LANGUAGE

Comments

This table is used for storing the translation definition of enrollment justification.

Indexes

Columns

[top of page]

OTA.OTA_BKNG_JUSTIFICATIONS_TL does not reference any database object

OTA.OTA_BKNG_JUSTIFICATIONS_TL is referenced by following:

APPS

TRIGGER - OTA_BKNG_JUSTIFICATI041310_WHO

SYNONYM - OTA_BKNG_JUSTIFICATIONS_TL

[top of page]

Table: OTA_BOOKING_DEALS

Primary Key: OTA_BOOKING_DEALS_PK

1. BOOKING_DEAL_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

An enrollment agreement (booking deal) is an arrangement about the
price or method of payment for one or more events. There are two types
of enrollment agreement: discount and prepurchase.
A discount agreement is an arrangement to supply student places
on one or more events at a reduced price. It offers
a percentage discount on the price ofone
event, all events on a price list, all events in a training package,
or all events scheduled for one activity. The agreement may be open to
all customers or restricted to one customer. It may be limited to a
maximum number of places per customer for each event, or for all
events to which the agreement applies.
A prepurchase agreement is always an arrangement with one customer,
based on a price list. The customer agrees to spend a certain sum of
money (or training units) on events listed on the price list. The
agreement can include a percentage discount on the prices on the price
list.

Primary Key: OTA_BOOKING_DEALS_PK

1. BOOKING_DEAL_ID

Indexes

Columns

[top of page]

OTA.OTA_BOOKING_DEALS does not reference any database object

OTA.OTA_BOOKING_DEALS is referenced by following:

APPS

SYNONYM - OTA_BOOKING_DEALS

TRIGGER - OTA_BOOKING_DEALS_WHO

[top of page]

Table: OTA_BOOKING_STATUS_EXCL

Primary Key: OTA_BOOKING_STATUS_EXCL_PK

1. APPLICATION_ID
2. RESPONSIBILITY_ID
3. BOOKING_STATUS_TYPE_ID

Foreign Keys from this table:

Comments

Booking status exclusions enable you to prevent users with specific
responsibilities from entering, updating or deleting enrollments of a
certain status(es). For example, you can prevent everyone apart from
course administrators from placing an enrollment.

Primary Key: OTA_BOOKING_STATUS_EXCL_PK

1. APPLICATION_ID
2. RESPONSIBILITY_ID
3. BOOKING_STATUS_TYPE_ID

Indexes

Columns

[top of page]

OTA.OTA_BOOKING_STATUS_EXCL does not reference any database object

OTA.OTA_BOOKING_STATUS_EXCL is referenced by following:

APPS

SYNONYM - OTA_BOOKING_STATUS_EXCL

[top of page]

Table: OTA_BOOKING_STATUS_HISTORIES

Primary Key: OTA_BOOKING_STATUS_HISTORY_PK

1. BOOKING_ID
2. BOOKING_STATUS_TYPE_ID
3. START_DATE

Foreign Keys from this table:

Comments

A booking status history holds a record of the enrollment status
changes for a student enrollment. It also holds the reason for the
change.

Primary Key: OTA_BOOKING_STATUS_HISTORY_PK

1. BOOKING_ID
2. BOOKING_STATUS_TYPE_ID
3. START_DATE

Indexes

Columns

[top of page]

OTA.OTA_BOOKING_STATUS_HISTORIES does not reference any database object

OTA.OTA_BOOKING_STATUS_HISTORIES is referenced by following:

APPS

SYNONYM - OTA_BOOKING_STATUS_HISTORIES

TRIGGER - OTA_BOOKING_STATUS_HISTORI_WHO

[top of page]

Table: OTA_BOOKING_STATUS_TYPES

Primary Key: OTA_BOOKING_STATUS_TYPES_PK

1. BOOKING_STATUS_TYPE_ID

Primary Key: OTA_BOOKING_STATUS_TYPES_UK2

1. NAME
2. BUSINESS_GROUP_ID

Foreign Keys to this table:

Comments

The Oracle Training Administration product provides a seeded list of
system enrollment statuses. These system enrollment statuses are what
the application uses to determine the condition of a student
enrollment. These enrollment status records, also known as booking
status records, hold user-definitions of the system statuses. For
example, the system status Cancelled can be set up as Cancelled by
Administrator, Cancelled by Student, and so on. For each system
enrollment status type, there is one default user status which is
used to create new enrollments and throughout the enrollment life
cycle.

Primary Key: OTA_BOOKING_STATUS_TYPES_PK

1. BOOKING_STATUS_TYPE_ID

Unique Key: OTA_BOOKING_STATUS_TYPES_UK2

1. NAME
2. BUSINESS_GROUP_ID

Indexes

Columns

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES is referenced by following:

APPS

SYNONYM - OTA_BOOKING_STATUS_TYPES

TRIGGER - OTA_BOOKING_STATUS_TYPES_WHO

[top of page]

Table: OTA_BOOKING_STATUS_TYPES_TL

Primary Key: OTA_BOOKING_STATUS_TYPES_TL

1. BOOKING_STATUS_TYPE_ID
2. LANGUAGE

Comments

This table only contains a subset of the columns from the base table.
Contains translated name and description of Booking Status.

Primary Key: OTA_BOOKING_STATUS_TYPES_TL

1. BOOKING_STATUS_TYPE_ID
2. LANGUAGE

Indexes

Columns

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES_TL does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES_TL is referenced by following:

APPS

TRIGGER - OTA_BOOKING_STATUS_T041317_WHO

SYNONYM - OTA_BOOKING_STATUS_TYPES_TL

[top of page]

Table: OTA_BULK_ENR_REQUESTS

Primary Key: OTA_BULK_ENR_REQUESTS_PK

1. BULK_ENR_REQUEST_ID

Comments

Bulk Enrollment request consist of any request which is made from the bulk enrollment functionality. The request can be a request which will be execute immidiately or via concurrent program.

Indexes

Columns

[top of page]

OTA.OTA_BULK_ENR_REQUESTS does not reference any database object

OTA.OTA_BULK_ENR_REQUESTS is referenced by following:

APPS

SYNONYM - OTA_BULK_ENR_REQUESTS

TRIGGER - OTA_BULK_ENR_REQUESTS_WHO

[top of page]

Table: OTA_BULK_ENR_REQ_MEMBERS

Primary Key: OTA_BULK_ENR_REQ_MEMBERS_UK

1. BULK_ENR_REQUEST_ID
2. PERSON_ID

Comments

Bulk Enrollment request member hold the data of the leaner whom is requested to be enrolled into Class, Learning Path or Learning Certification via Bulk Enrollment.

Indexes

Columns

[top of page]

OTA.OTA_BULK_ENR_REQ_MEMBERS does not reference any database object

OTA.OTA_BULK_ENR_REQ_MEMBERS is referenced by following:

APPS

SYNONYM - OTA_BULK_ENR_REQ_MEMBERS

TRIGGER - OTA_BULK_ENR_REQ_MEMBERS_WHO

[top of page]

Table: OTA_CATEGORY_USAGES

Primary Key: OTA_CATEGORY_USAGES_PK

1. CATEGORY_USAGE_ID

Primary Key: OTA_CATEGORY_USAGES_UK2

1. TYPE
2. CATEGORY
3. BUSINESS_GROUP_ID

Comments

Categories are entities that allow administrative users to organize their course catalog. Categories are containers for courses and learning paths, and have few attributes. The administrative user can define start and end dates for categories, select which courses appear in which categories in the course catalog, and define learner access based on the category level allowing access to be inherited by all the courses the category contains (though learner access doesnot need to be defined here, it can be defined at the levels of Course, Offering, and Class as well).

You can use a category to define:
1. Searching criteria
2. Program specifications
3. Packaged discounts
Each category can be used for all or none of the above. A category
usage record indicates which of these usages is valid for a particular
activity category.

Primary Key: OTA_CATEGORY_USAGES_PK

1. CATEGORY_USAGE_ID

Indexes

Columns

[top of page]

OTA.OTA_CATEGORY_USAGES does not reference any database object

OTA.OTA_CATEGORY_USAGES is referenced by following:

APPS

SYNONYM - OTA_CATEGORY_USAGES

TRIGGER - OTA_CATEGORY_USAGES_WHO

[top of page]

Table: OTA_CATEGORY_USAGES_TL

Primary Key: OTA_CATEGORY_USAGES_TL_PK

1. CATEGORY_USAGE_ID
2. LANGUAGE

Comments

This table only contains a subset of the columns from the base table.
Contains translated category and description of Category.

Primary Key: OTA_CATEGORY_USAGES_TL_PK

1. LANGUAGE
2. CATEGORY_USAGE_ID

Indexes

Columns

[top of page]

OTA.OTA_CATEGORY_USAGES_TL does not reference any database object

OTA.OTA_CATEGORY_USAGES_TL is referenced by following:

APPS

TRIGGER - OTA_CATEGORY_USAGES_041312_WHO

SYNONYM - OTA_CATEGORY_USAGES_TL

[top of page]

Table: OTA_CERTIFICATIONS_B

Primary Key: OTA_CERTIFICATIONS_B_PK

1. CERTIFICATION_ID

Foreign Keys to this table:

Comments

Certification is an object that belong to a category. Certification can consist of one or more courses. Certification can be categorized as one time or renewable. Certifications usually need to be completed by learner in a specific time period.

Indexes

Columns

[top of page]

OTA.OTA_CERTIFICATIONS_B does not reference any database object

OTA.OTA_CERTIFICATIONS_B is referenced by following:

APPS

SYNONYM - OTA_CERTIFICATIONS_B

TRIGGER - OTA_CERTIFICATIONS_B_WHO

[top of page]

Table: OTA_CERTIFICATIONS_TL

Primary Key: OTA_CERTIFICATIONS_TL_PK

1. CERTIFICATION_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table is used for storing the translation definition of certification

Indexes

Columns

[top of page]

OTA.OTA_CERTIFICATIONS_TL does not reference any database object

OTA.OTA_CERTIFICATIONS_TL is referenced by following:

APPS

TRIGGER - OTA_CERTIFICATIONS_T041252_WHO

SYNONYM - OTA_CERTIFICATIONS_TL

[top of page]

Table: OTA_CERTIFICATION_MEMBERS

Primary Key: OTA_CERTIFICATION_MEMBERS_PK

1. CERTIFICATION_MEMBER_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

Certification member is child of certification. It consist of objects that need to be completed by a learner in order for a certification to be completed. The only object currently supported is course.

Indexes

Columns

[top of page]

OTA.OTA_CERTIFICATION_MEMBERS does not reference any database object

OTA.OTA_CERTIFICATION_MEMBERS is referenced by following:

APPS

SYNONYM - OTA_CERTIFICATION_MEMBERS

TRIGGER - OTA_CERTIFICATION_MEMBERS_WHO

[top of page]

Table: OTA_CERT_CAT_INCLUSIONS

Primary Key: OTA_CERT_CAT_INCLUSIONS_UK1

1. CERTIFICATION_ID
2. CATEGORY_USAGE_ID

Comments

A certication category inclusion specifies that a certification is within a particular type of category .

Indexes

Columns

[top of page]

OTA.OTA_CERT_CAT_INCLUSIONS does not reference any database object

OTA.OTA_CERT_CAT_INCLUSIONS is referenced by following:

APPS

SYNONYM - OTA_CERT_CAT_INCLUSIONS

TRIGGER - OTA_CERT_CAT_INCLUSIONS_WHO

[top of page]

Table: OTA_CERT_ENROLLMENTS

Primary Key: OTA_CERT_ENROLLMENTS_PK

1. CERT_ENROLLMENT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This record all learner subscriptions into a certification. There is one row for each learner who subcribe to a certification.

Indexes

Columns

[top of page]

OTA.OTA_CERT_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_ENROLLMENTS is referenced by following:

APPS

SYNONYM - OTA_CERT_ENROLLMENTS

TRIGGER - OTA_CERT_ENROLLMENTS_WHO

[top of page]

Table: OTA_CERT_MBR_ENROLLMENTS

Primary Key: OTA_CERT_MBR_ENROLLMENTS_PK

1. CERT_MBR_ENROLLMENT_ID

Foreign Keys from this table:

Comments

This is a child of certification enrollment and certification period enrollment. When a learner enroll into a certification, there will be a row created for each member that belongs to the certifications. The purpose is to keep track of the progress of each member status or completion for each certification period.

Indexes

Columns

[top of page]

OTA.OTA_CERT_MBR_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_MBR_ENROLLMENTS is referenced by following:

APPS

SYNONYM - OTA_CERT_MBR_ENROLLMENTS

TRIGGER - OTA_CERT_MBR_ENROLLMENTS_WHO

[top of page]

Table: OTA_CERT_PRD_ENROLLMENTS

Primary Key: OTA_CERT_PRD_ENROLLMENTS_PK

1. CERT_PRD_ENROLLMENT_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

This is a child of certification enrollment. When a learner enroll into certification for for the first time, one row is created that defines the first period. Each time the learner renew to the certification, another record will be created for the new period. Purpose of this is to keep the history of the certain period completion for the certification.

Indexes

Columns

[top of page]

OTA.OTA_CERT_PRD_ENROLLMENTS does not reference any database object

OTA.OTA_CERT_PRD_ENROLLMENTS is referenced by following:

APPS

SYNONYM - OTA_CERT_PRD_ENROLLMENTS

TRIGGER - OTA_CERT_PRD_ENROLLMENTS_WHO

[top of page]

Table: OTA_CHATS_B

Primary Key: OTA_CHATS_B_PK

1. CHAT_ID

Foreign Keys to this table:

Comments

Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and real time.

Indexes

Columns

[top of page]

OTA.OTA_CHATS_B does not reference any database object

OTA.OTA_CHATS_B is referenced by following:

APPS

SYNONYM - OTA_CHATS_B

TRIGGER - OTA_CHATS_B_WHO

[top of page]

Table: OTA_CHATS_TL

Primary Key: OTA_CHATS_TL_PK

1. CHAT_ID
2. LANGUAGE

Foreign Keys from this table:

Comments

This table is used for storing the translation definition of chat.

Indexes

Columns

[top of page]

OTA.OTA_CHATS_TL does not reference any database object

OTA.OTA_CHATS_TL is referenced by following:

APPS

SYNONYM - OTA_CHATS_TL

TRIGGER - OTA_CHATS_TL041305_WHO

[top of page]

Table: OTA_CHAT_MESSAGES

Primary Key: OTA_CHAT_MESSAGES_PK

1. CHAT_MESSAGE_ID

Foreign Keys from this table:

Comments

This hold the messages which have been posted to the chat by external or internal learner.

Indexes

Columns

[top of page]

OTA.OTA_CHAT_MESSAGES does not reference any database object

OTA.OTA_CHAT_MESSAGES is referenced by following:

APPS

SYNONYM - OTA_CHAT_MESSAGES

TRIGGER - OTA_CHAT_MESSAGES_WHO

[top of page]

Table: OTA_CHAT_OBJ_INCLUSIONS

Primary Key: OTA_CHAT_OBJ_INCLUSIONS_UK1

1. CHAT_ID
2. OBJECT_TYPE
3. OBJECT_ID

Comments

This specifies that a chat belongs to a category or class. Chat can belong to multiple categories, or can only belong to one class. Once the chat belongs to a class, it cannot be defined under a category and vice versa.

Indexes

Columns

[top of page]

OTA.OTA_CHAT_OBJ_INCLUSIONS does not reference any database object

OTA.OTA_CHAT_OBJ_INCLUSIONS is referenced by following:

APPS

SYNONYM - OTA_CHAT_OBJ_INCLUSIONS

TRIGGER - OTA_CHAT_OBJ_INCLUSIONS_WHO

[top of page]

Table: OTA_CHAT_USERS

Primary Key: OTA_CHAT_USERS_UK1

1. CHAT_ID
2. PERSON_ID
3. CONTACT_ID

Comments

This hold the information of who has joined to the chat

Indexes

Columns

[top of page]

OTA.OTA_CHAT_USERS does not reference any database object

OTA.OTA_CHAT_USERS is referenced by following:

APPS

SYNONYM - OTA_CHAT_USERS

TRIGGER - OTA_CHAT_USERS_WHO

[top of page]

Table: OTA_CMI_ADAPTERS

Comments

When content communicates with Oracle iLearning using CMI, adapter files are required on the same machine as the content. The CMI adapter then points to these files so that Oracle iLearning knows how to communicate with the content.

Indexes

Columns

[top of page]

OTA.OTA_CMI_ADAPTERS does not reference any database object

OTA.OTA_CMI_ADAPTERS is referenced by following:

APPS

SYNONYM - OTA_CMI_ADAPTERS

TRIGGER - OTA_CMI_ADAPTERS_WHO

[top of page]

Table: OTA_COMPETENCE_LANGUAGES

Primary Key: OTA_COMPETENCE_LANGUAGES_PK

1. COMPETENCE_LANGUAGE_ID

Primary Key: OTA_COMPETENCE_LANGUAGES_UK

1. BUSINESS_GROUP_ID
2. COMPETENCE_ID
3. LANGUAGE_ID

Comments

You can use this to define mapping between language and competence. This mapping will be used
to find a right trainer based on his language's competence.

Primary Key: OTA_COMPETENCE_LANGUAGES_PK

1. COMPETENCE_LANGUAGE_ID

Unique Key: OTA_COMPETENCE_LANGUAGES_UK

1. BUSINESS_GROUP_ID
2. COMPETENCE_ID
3. LANGUAGE_ID

Indexes