OTA Tables (111)
OTA - Learning Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| Table | Columns | Description |
|---|---|---|
OTA_ACTIVITY_DEFINITIONS |
34 | An activity is any educational offering designed to improve a students qualifications, competencies or experience. |
OTA_ACTIVITY_DEFINITIONS_TL |
10 | This table is used for Activity language translations. |
OTA_ACTIVITY_VERSIONS |
62 | A course is the highest level of learning that can be prescribed to a learner.It also contains the objectives and competencies a learner wil |
OTA_ACTIVITY_VERSIONS_TL |
13 | This table is used for Activity Version language translations. |
OTA_ACT_CAT_INCLUSIONS |
35 | A course category inclusion specifies that a course is within a particular type of category. |
OTA_ANNOUNCEMENTS |
32 | Defined by administrators to communicate news or timely information to learners. |
OTA_ANNOUNCEMENTS_TL |
10 | This table is used for Announcement translations. |
OTA_ATTEMPTS |
48 | Every time a learner plays online learning, a row in this table is created for a specific leaner against a learning object. |
OTA_BKNG_JUSTIFICATIONS_B |
11 | This is used by watilist optimization feature to default an enrollment priority level. Admin can define their own justification name with en |
OTA_BKNG_JUSTIFICATIONS_TL |
9 | This table is used for storing the translation definition of enrollment justification. |
OTA_BOOKING_DEALS |
45 | An enrollment agreement (booking deal) is an arrangement about the price or method of paying for an event(s). |
OTA_BOOKING_STATUS_EXCL |
3 | Booking status exclusions prevent users with specific responsibilities from handling enrollments of certain statuses. |
OTA_BOOKING_STATUS_HISTORIES |
11 | A booking status history records status of changes to a student enrollment. |
OTA_BOOKING_STATUS_TYPES |
36 | Booking status types contain a list of user-defined enrollment statuses, along with their corresponding system statuses. |
OTA_BOOKING_STATUS_TYPES_TL |
10 | This table is used for Booking Status language translations. |
OTA_BULK_ENR_REQUESTS |
12 | Bulk Enrollment request consist of any request which is made from the bulk enrollment functionality. |
OTA_BULK_ENR_REQ_MEMBERS |
14 | Bulk Enrollment request member hold the data of the leaner whom is requested to be enrolled into Class, Learning Path or Learning Certificat |
OTA_CATEGORY_USAGES |
39 | Category usages indicate the role in which an activity category is used. |
OTA_CATEGORY_USAGES_TL |
10 | This table is used for Category translations. |
OTA_CERTIFICATIONS_B |
43 | Certification is an object that belong to a category. Certification can consist of one or more courses. Certification can be categorized as |
OTA_CERTIFICATIONS_TL |
16 | This table is used for storing the translation definition of certification |
OTA_CERTIFICATION_MEMBERS |
35 | Certification member is child of certification. It consist of objects that need to be completed by a learner in order for a certification to |
OTA_CERT_CAT_INCLUSIONS |
32 | A certication category inclusion specifies that a certification is within a particular type of category . |
OTA_CERT_ENROLLMENTS |
40 | This record all learner subscriptions into a certification. There is one row for each learner who subcribe to a certification. |
OTA_CERT_MBR_ENROLLMENTS |
33 | This is a child of certification enrollment and certification period enrollment. When a learner enroll into a certification, there will be a |
OTA_CERT_PRD_ENROLLMENTS |
35 | This is a child of certification enrollment. When a learner enroll into certification for for the first time, one row is created that define |
OTA_CHATS_B |
14 | Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and real time. |
OTA_CHATS_TL |
10 | This table is used for storing the translation definition of chat. |
OTA_CHAT_MESSAGES |
14 | This hold the messages which have been posted to the chat by external or internal learner. |
OTA_CHAT_OBJ_INCLUSIONS |
12 | 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 |
OTA_CHAT_USERS |
11 | This hold the information of who has joined to the chat |
OTA_CMI_ADAPTERS |
15 | A CMI adapter is only required for content that uses CMI communication with Oracle iLearning. |
OTA_COMPETENCE_LANGUAGES |
33 | Mapping between Language and Competence |
OTA_CONFERENCES |
45 | A web conference belong to only one class. A class can only have one web conference. this is only used for integration with Oracle Collabora |
OTA_CONFERENCE_SERVERS_B |
35 | This table hold the definition of each conference server. Currently this table will be only used for integration with Oracle Collaboration S |
OTA_CONFERENCE_SERVERS_TL |
10 | This table is used for Conference server language translation |
OTA_CONTENT_SERVERS |
15 | Content servers define web server machines that contain physical content files, that should be accessible from within Oracle iLearning. Admi |
OTA_COURSE_PREREQUISITES |
11 | This hold the information of which courses need to be completed before learners can enroll into a specific course. A course can have one or |
OTA_CROSS_CHARGES |
13 | Details to enable internal Cross Charging by mapping Chart of Account details from Oracle General Ledger to Oracle Human Resources. |
OTA_DELEGATE_BOOKINGS |
82 | An student booking (delegate booking) records an enrollment onto a scheduled, program or one time event. |
OTA_EVALUATIONS |
13 | |
OTA_EVENTS |
73 | An event can be scheduled, one time, developmental, program or session. |
OTA_EVENTS_TL |
9 | This table is used for Event language translations. |
OTA_EVENT_ASSOCIATIONS |
48 | You use event associations to restrict the list of customers and students who can enroll onto an event. |
OTA_FINANCE_HEADERS |
137 | A finance header holds generic financial information about dealings you have with particular customers or suppliers. |
OTA_FINANCE_LINES |
66 | A finance line records each financial transaction with a customer or supplier. |
OTA_FORUMS_B |
15 | Forum can belongs to a category or class. Forum can be used to communicate between one or more user online. |
OTA_FORUMS_TL |
10 | This table is used for Forum language translation |
OTA_FORUM_MESSAGES |
17 | This a child of forum thread. This hold the messages which have been posted to the forum thread by external or internal learner. |
OTA_FORUM_THREADS |
13 | This a child of forum. This hold the topic that make up the forum. |
OTA_FRM_NOTIF_SUBSCRIBERS |
10 | This stores the information of the learner who chose to recieve a notification when someone post a message or reply to a specific forum. |
OTA_FRM_OBJ_INCLUSIONS |
12 | This specifies that a forum belongs to a category or class. Forum can belong to multiple categories, or can only belong to one class. Once t |
OTA_HR_GL_FLEX_MAPS |
13 | Details to enable internal Cross Charging by mapping Chart of Account details from Oracle General Ledger to Oracle Human Resources. |
OTA_ILN_XML_PROCESSES |
10 | iLearning integration data exchange process |
OTA_IMPORT_HISTORIES |
11 | Logs of import and export tasks |
OTA_LEARNING_OBJECTS |
73 | A learning object holds metadata relating to a piece of online content or test, and are created in the Content tree by administrators. |
OTA_LEARNING_PATHS |
43 | A learning path defines a sequence of courses that should be completed in order to obtain specific knowledge. |
OTA_LEARNING_PATHS_TL |
13 | This table is used for Learning Path language translations. |
OTA_LEARNING_PATH_MEMBERS |
36 | Describe each course that belongs to a learning path |
OTA_LO_FOLDERS |
37 | A folder contains learning objects and other folders, and are created in the Content tree by administrators. |
OTA_LO_SCORM_OBJECTIVES |
13 | This table is an intersection table which hold relationship between OTA_SCORM_OBJECTIVES and OTA_LEARNING_OBJECTS. |
OTA_LP_CAT_INCLUSIONS |
32 | A Learning Path category inclusion specifies that a learning path is within a particular type of category. |
OTA_LP_ENROLLMENTS |
50 | |
OTA_LP_MEMBER_ENROLLMENTS |
47 | |
OTA_LP_SECTIONS |
33 | This table hold the info about the section of a Learning path. The section can be all mandatory, some mandatory or all optional. |
OTA_LP_SECTIONS_TL |
10 | This table is used for Learning Path Section language translations. |
OTA_MANDATORY_ENR_REQUESTS |
12 | |
OTA_MANDATORY_ENR_REQUESTS1 |
13 | |
OTA_MANDATORY_ENR_REQ_MEMBERS |
11 | |
OTA_MANDATORY_ENR_REQ_MEMBERS1 |
12 | |
OTA_NOTRNG_HISTORIES |
46 | Records attendance data for external training events initiated outside of OTA. |
OTA_OFFERINGS |
54 | An offering is a child of a course. |
OTA_OFFERINGS_TL |
10 | This table is used for Offering language translations. |
OTA_OPEN_FC_ENROLLMENTS |
12 | This stores the enrollment for all category based chat and forum. |
OTA_PERFORMANCES |
26 | This tables stores the latest status information for a learner against a learning object.There is only ever one row for a learner and learni |
OTA_PREREQUISITES |
11 | Prerequisites are only available for learning objects (online learning). They define in which sequence learning objects must be completed. |
OTA_PRICE_LISTS |
39 | A price list contains entries that identify pricing information for activities. |
OTA_PRICE_LIST_ENTRIES |
38 | A price list entry records the price of an activity between two dates. |
OTA_PROGRAM_MEMBERSHIPS |
35 | Program membership holds a record of which scheduled events are within a program. |
OTA_PVT_FRM_THREAD_USERS |
13 | This stores information of a private message which is posted by a person to another person |
OTA_QBANK_QUESTIONS |
9 | This table acts as a bridge table between OTA_QUESTION_BANKS and OTA_QUESTIONS because of the N:N relation that could be specified between t |
OTA_QUESTIONS |
33 | This table contains the question definitions. Questions can be reused in different tests. At present there is support for Five Types of Ques |
OTA_QUESTION_BANKS |
35 | This table acts as a container for the questions so they can be grouped appropriately. A Question Bank can contain one of more questions. Pr |
OTA_RESOURCE_ALLOCATIONS |
38 | A resource allocation records a supplied resource to a student on an event. |
OTA_RESOURCE_BOOKINGS |
51 | You book a resource (people, equipment or facilities) for a scheduled or development event, or for a session. |
OTA_RESOURCE_DEFINITIONS |
32 | Resource definitions hold the unique key flexfield combinations for supplied resources. |
OTA_RESOURCE_USAGES |
39 | A resource usage holds holds the requirement of an activity version for a specific resource, or for a resource type. |
OTA_RESPONSE_TYPES |
14 | This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TY |
OTA_RESPONSE_VALUES |
14 | This stores the response values for a question. There is a 1:N relation between OTA_RESPONSE_TYPES and OTA_RESPONSE_VALUES. |
OTA_SCORM_OBJECTIVES |
20 | Holds one record for each objective. Objectives are used in both AICCand SCORM. |
OTA_SCORM_OBJ_ATTEMPTS |
24 | Holds the raw lesson status, score, and identifier changes (SCORM only) set by the content during a particular attempt. When the attempt is |
OTA_SCORM_OBJ_PERFS |
22 | Stores a learner's current lesson status and score for a particular objective. |
OTA_SECTION_RULES |
13 | This table is used to hold the Question Bank Information and the number of questions that should be pulled to generate the test when a user |
OTA_SKILL_PROVISIONS |
32 | This table holds any data you specify as other information for an activity version. |
OTA_SUPPLIABLE_RESOURCES |
48 | A resource is any facility, person or equipment that you need to book to run an event. |
OTA_SUPPLIABLE_RESOURCES_TL |
10 | This table is used for Resource language translations. |
OTA_TESTS |
33 | This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this ta |
OTA_TEST_QUESTIONS |
13 | This table stores acts as a bridge table between the OTA_TEST_SECTIONS and OTA_QUESTIONS table for test which have a type_flag set to S( Pr |
OTA_TEST_SECTIONS |
41 | A test can have one or more test sections. For a test to be offered it must have atleast one test section associated with it which contains |
OTA_TITLE_CONVERSIONS |
2 | Currenty not used. |
OTA_TP_MEASUREMENT_TYPES |
46 | A measurement type is a statistic type used to record information about a training plan. |
OTA_TRAINING_PLANS |
53 | A Training Plan is a collection of Activities and Activity Definintions for a person or organization. |
OTA_TRAINING_PLAN_COSTS |
76 | A plan cost is a recorded measure against the training plan. |
OTA_TRAINING_PLAN_MEMBERS |
50 | A Training Plan member is an Activity or Activity version. |
OTA_UPGRADE_LOG |
15 | This table hold the information about data which is failed during upgrade. |
OTA_USER_GROUPS_B |
33 | |
OTA_USER_GROUPS_TL |
10 | |
OTA_USER_GROUP_ELEMENTS |
42 | |
OTA_UTEST_QUESTIONS |
16 | Whenever a user takes a test a new test instance is generated for the user. The test definition (test questions that make up the test) are s |
OTA_UTEST_RESPONSES |
15 | When the test is assembled for the user, each response to all questions are created in this table. The table is updated as per the response |
OTA_VENDOR_SUPPLIES |
31 | Currently not used |