Results for “suggested_points”
14 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
-
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
-
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 stored in this table. If the test is resumable and the user has resumed an old test, the attempt_id f
-
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 stored in this table. If the test is resumable and the user has resumed an old test, the attempt_id f
-
eTRM - OTA Tables and Views 12.2.2
Currently not used
-
eTRM - OTA Tables and Views 12.1.1
Currently not used