Results for “display_order_flag”
29 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OTA_RESPONSE_TYPES is a table in the OTA (Learning Management / Oracle Training Administration) schema that stores the response-side configuration of questions used throughout the Oracle E-Business Suite online assessment and certification infrastructure. Where OTA_QUESTIONS captures the question stem and its identifying attributes, OTA_RESPONSE_TYPES holds the additional detail that governs how a learner's answer is presented, scored, and evaluated. The table is documented as having a current 1:1 relationship with OTA_QUESTIONS, while the underlying data model was intentionally designed to permit hybrid question types — that is, a single logical question that combines multiple presentation or grading behaviors. This forward-compatible design explains why response-type data is factored into its own entity rather than being merged into the question record.
Under the heuristic Data Vault classification mined from the foreign-key structure, OTA_RESPONSE_TYPES is hub-leaning. In modeling terms, this suggests the table is best understood as a durable, business-keyed entity of its own rather than as a pure junction (link) or a descriptive attribute set (satellite). Its identity is stable, its descriptive columns drift slowly, and it serves as a reference point that other transactional tables hang off of.
Key Information Stored
The table is documented with 14 physical columns. The most significant are summarized below.
- RESPONSE_TYPE_ID — the surrogate primary key, enforced by the unique index OTA_RESPONSE_TYPES_PK. This is the column commonly referenced in the EBS user's search term "response_type_id" and is the value carried as a foreign key by dependent tables.
- QUESTION_ID — foreign key to OTA_QUESTIONS, establishing the owning question for each response-type definition. In the documented 1:1 model this column effectively acts as a business-key candidate alongside the primary key.
- BUSINESS_GROUP_ID — the multi-tenant discriminator, indicating that response types are partitioned by business group in the standard OTA/HRMS security model.
- TYPE_FLAG — indicates the response type (for example multiple-choice, free-text, or another graded format), driving how the response is rendered and evaluated.
- SUGGESTED_POINTS — the point value proposed for the question or response, used in scoring calculations.
- DISPLAY_ORDER_FLAG — controls whether and how the associated answer options are ordered when presented to the learner.
- CORRECT_FEEDBACK and WRONG_FEEDBACK — the feedback text shown to a learner after a correct or incorrect response, respectively.
- OBJECT_VERSION_NUMBER — the optimistic-locking column used by the OAF/ADF framework to detect concurrent updates.
- CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns providing audit and accountability tracking.
Common Use Cases and Queries
Typical reporting and integration scenarios include retrieving the response configuration for a given question, joining response types to their possible answers, or analyzing scoring points per question. A common query resolves a question to its response type:
SELECT q.question_id, r.response_type_id, r.type_flag, r.suggested_points FROM ota_questions q, ota_response_types r WHERE q.question_id = r.question_id AND q.question_id = :question_id;- Enumerating the answer options for a response type by joining OTA_RESPONSE_VALUES on RESPONSE_TYPE_ID.
- Auditing scoring distribution across a certification or assessment using SUGGESTED_POINTS grouped by TYPE_FLAG.
- Identifying learner responses tied to a response type via OTA_UTEST_RESPONSES for test-result analysis.
Related Objects
The foreign-key and primary-key relationship data identifies the following as the most significant related objects:
- OTA_QUESTIONS — the parent question table; joined via OTA_RESPONSE_TYPES.QUESTION_ID = OTA_QUESTIONS.QUESTION_ID.
- OTA_RESPONSE_VALUES — child table holding selectable answers; references OTA_RESPONSE_TYPES via RESPONSE_VALUES.RESPONSE_TYPE_ID.
- OTA_UTEST_RESPONSES — child table recording learner answers; references OTA_RESPONSE_TYPES via UTEST_RESPONSES.RESPONSE_TYPE_ID.
These three tables, together with the response-type hub itself, form the practical core of the OTA assessment data model and should be the focus of any query or integration touching RESPONSE_TYPE_ID.
-
This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TYPES. The data model however is designed so that we can support hybrid question types. That functiona
-
Program Type View Academic History Configuration
-
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 atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS
-
This table holds additional details regarding the question. At present there is a 1:1 relation between the OTA_QUESTIONS and OTA_RESPONSE_TYPES. The data model however is designed so that we can support hybrid question types. That functiona
-
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.
-
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 atleast one question. There is a 1:N relation between the OTA_TESTS and OTA_TEST_SECTIONS
-
VIEW: OTA.OTA_TESTS# 12.2.2
-
VIEW: OTA.OTA_TEST_SECTIONS# 12.2.2
-
VIEW: OTA.OTA_TESTS# 12.2.2
-
VIEW: OTA.OTA_TEST_SECTIONS# 12.2.2
-
TABLE: OTA.OTA_TEST_SECTIONS 12.1.1
-
TABLE: OTA.OTA_TEST_SECTIONS 12.2.2
-
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( Pre Selected)test. This stores which questions will be displayed under which test sections.
-
TABLE: IGS.IGS_AS_VAH_CONF 12.1.1
-
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( Pre Selected)test. This stores which questions will be displayed under which test sections.
-
TABLE: OTA.OTA_TESTS 12.2.2
-
TABLE: OTA.OTA_TESTS 12.1.1
-
eTRM - OTA Tables and Views 12.2.2
Currently not used
-
eTRM - OTA Tables and Views 12.1.1
Currently not used
-
eTRM - IGS Tables and Views 12.1.1
Holds applicant whose records are wrongly available . It is recommended that such applicant records are deleted from the system . It synchronizes with UCAS view 'ivStarW'.