Results for “duration_flag”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OTA_TESTS is the primary metadata table for test-type learning objects within the Oracle E-Business Suite (EBS) Learning Management module (OTA). In Release 12.1.1 and 12.2.2, this table stores the behavioral and configuration attributes that govern how an online test is presented, scored, and navigated by learners. While the parent OTA_LEARNING_OBJECTS table holds the general definition common to all learning objects (courses, offerings, tests, and so on), OTA_TESTS carries the test-specific properties that determine runtime behavior such as timing, grading, attempts, and feedback display.

The table maintains a strict 1:1 relationship with OTA_LEARNING_OBJECTS: every record in OTA_TESTS corresponds to exactly one test learning object, and each test learning object has exactly one OTA_TESTS record. The documented physical schema lists 33 columns, with TEST_ID serving as the surrogate primary key (OTA_TESTS_PK).

From a Data Vault modeling perspective, the metadata classifies OTA_TESTS as hub-leaning. This is a heuristic, mined from the foreign-key structure and the presence of a single-column surrogate key. In practice, TEST_ID behaves as a business key/hub candidate, while the majority of the descriptive columns (flags, durations, feedback text) are attribute-style data that a Data Vault model would typically place in a satellite keyed to that hub.

Key Information Stored

The most functionally significant columns fall into several groups:

The only documented unique index is OTA_TESTS_PK on TEST_ID, making TEST_ID the sole business-key candidate identified in the metadata. TEST_ID is also the column referenced by all child foreign keys.

Common Use Cases and Queries

Typical usage centers on retrieving test configuration for a given learning object, auditing test behavior, and reporting on assessment design. A common join retrieves the test definition alongside its parent learning object:

  • SELECT t.test_id, t.max_attempts, t.duration, t.grade_flag FROM ota_tests t JOIN ota_learning_objects lo ON lo.learning_object_id = t.test_id WHERE t.test_id = :test_id;
  • Reporting tests with unlimited reuse or review enabled: filter on RESUME_FLAG, QUESTION_REVIEW_FLAG, or TYPE_FLAG.
  • Assessing feedback configuration across a catalog: aggregate FEEDBACK_TYPE_FLAG or count records where CORRECT_FEEDBACK is null.
  • Auditing recently modified tests via LAST_UPDATE_DATE and LAST_UPDATED_BY.

Because OTA_TESTS branches into question, section, and section-rule tables, reporting queries frequently aggregate child counts (questions per test, sections per test) grouped by TEST_ID.

Related Objects

OTA_TESTS is referenced by several dependent tables through TEST_ID foreign keys, and it maps 1:1 to its parent learning object table:

  • OTA_LEARNING_OBJECTS — parent table; joined on the shared identifier (LEARNING_OBJECT_ID = TEST_ID).
  • OTA_TEST_QUESTIONS — child table holding individual question rows; FK OTA_TEST_QUESTIONS.TEST_ID references OTA_TESTS.TEST_ID.
  • OTA_TEST_SECTIONS — child table defining test sections; FK OTA_TEST_SECTIONS.TEST_ID references OTA_TESTS.TEST_ID.
  • OTA_SECTION_RULES — child table defining section-level rules; FK OTA_SECTION_RULES.TEST_ID references OTA_TESTS.TEST_ID.

Together these tables form the assessment sub-model within OTA Learning Management, with OTA_TESTS acting as the hub that binds test-level configuration to the question, section, and rule hierarchies.