Results for “feedback_show_answer_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:
- Identity and context: TEST_ID (surrogate primary key), BUSINESS_GROUP_ID (multi-tenant/operating-unit scoping), and OBJECT_VERSION_NUMBER (optimistic locking for concurrent updates).
- Attempt and timing control: MAX_ATTEMPTS, DURATION, WARNING_DURATION, WARNING_ENABLED_FLAG, DURATION_BETWEEN_ATTEMPT, and DURATION_FLAG, which together govern how many times a learner may sit the test and how time limits and warnings behave.
- Grading and feedback: GRADE_FLAG, FEEDBACK_TYPE_FLAG, INHERIT_FEEDBACK_FLAG, CORRECT_FEEDBACK, WRONG_FEEDBACK, POST_TEST_FEEDBACK, and FEEDBACK_SHOW_ANSWER_FLAG, which determine scoring and the feedback presented to learners.
- Presentation and navigation: DISPLAY_ORDER_FLAG, QUESTIONS_PER_PAGE, QUESTION_REVIEW_FLAG, RESUME_FLAG, RESUME_INSTRUCTIONS, TYPE_FLAG, TEST_TYPE_FLAG, and TEST_INSTRUCTIONS.
- Summary/screen toggles: SHOW_SUMMARY_FLAG, SHOW_CONFIRMATION_FLAG, SHOW_EXIT_FLAG, and SHOW_SCORE_FLAG.
- Audit columns: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
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.
-
This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this table. There exists a 1:1 relation between the OTA_TESTS and OTA_LEARNING_OBJECTS table.
-
This table contains additional meta data about the test. The behavior of test test is determined using some of the properties set in this table. There exists a 1:1 relation between the OTA_TESTS and OTA_LEARNING_OBJECTS table.
-
VIEW: OTA.OTA_TESTS# 12.2.2
-
VIEW: OTA.OTA_TESTS# 12.2.2
-
TABLE: OTA.OTA_TESTS 12.1.1
-
TABLE: OTA.OTA_TESTS 12.2.2
-
eTRM - OTA Tables and Views 12.1.1
Currently not used
-
eTRM - OTA Tables and Views 12.2.2
Currently not used