[Home] [Help] [Dependency Information]
Object Name: | OTA_UTEST_QUESTIONS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_UTEST_QUESTIONS |
Subobject Name: | |
Status: | VALID |
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 for the user is updated and the existing test definition is used.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_UTEST_QUESTIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | USER_TEST_QUESTION_ID |
OTA_UTEST_QUESTIONS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ATTEMPT_ID |
OTA_UTEST_QUESTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
OBJECT_TYPE_FLAG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_TEST_QUESTION_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this user test question. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS. |
OBJECT_ID | NUMBER | (15) | Yes | Foreign key to OTA_QUESTIONS or OTA_TEST_SECTIONS depending on the OBJECT_TYPE_FLAG. If the Object Type Flag is S the value would be the OTA_SECTION_ID, if the value is Q, then the OBJECT_ID would be the OTA_QUESTION_ID |
OBJECT_TYPE_FLAG | VARCHAR2 | (1) | Yes | Indicates whether it is a test section or a question, Accepatble values are Q or S |
SKIPPED_FLAG | VARCHAR2 | (1) | Yes | Whether the user has attempted the question or skipped it. Permissible values are Y or N |
ATTEMPT_ID | NUMBER | (15) | Yes | Foreign Key to OTA_ATTEMPTS. |
SUGGESTED_POINTS | NUMBER | (15) | Points that can be awarded for the question. | |
MARKED_FOR_REVIEW_FLAG | VARCHAR2 | (1) | Whether the learner marked the question for review. | |
PARENT_ID | NUMBER | (9) | Specifies the SECTION_ID to which the question belongs. | |
POINTS_AWARDED | NUMBER | (9) | Points that were awarded to the user for this question | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter. |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT USER_TEST_QUESTION_ID
, BUSINESS_GROUP_ID
, OBJECT_ID
, OBJECT_TYPE_FLAG
, SKIPPED_FLAG
, ATTEMPT_ID
, SUGGESTED_POINTS
, MARKED_FOR_REVIEW_FLAG
, PARENT_ID
, POINTS_AWARDED
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OTA.OTA_UTEST_QUESTIONS;
OTA.OTA_UTEST_QUESTIONS does not reference any database object
OTA.OTA_UTEST_QUESTIONS is referenced by following:
|
|
|