eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OTA.OTA_TESTS

Object Details

Object Name:	OTA_TESTS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_TESTS
Subobject Name:
Status:	VALID

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_TESTS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TEST_ID	NUMBER	(15)	Yes	The surrogate key identifying a test.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign Key to HR_ALL_ORGANIZATION_UNITS.
DURATION_FLAG	VARCHAR2	(1)	Yes	Determine wether the test has a fixed duration within which the user is supposed to finish the test or unlimited time is available. The possible values are F: Fixed Duration. U for Unlimited Duration
GRADE_FLAG	VARCHAR2	(1)	Yes	Determine whether the test is scored or not. The possible values are F:Sum of Points Scored P:Percentage Scored. N: Not Scored
DISPLAY_ORDER_FLAG	VARCHAR2	(1)	Yes	Determine if the sections within a test should be displayed in the sequence in which they were created or if there order should be randomized whenever the user takes the test. The acceptable values are 'R' and 'S'.
QUESTIONS_PER_PAGE	NUMBER	(15)		Determine how many questione should be displayed in each page.
MAX_ATTEMPTS	NUMBER	(15)		Maximum Number of attempts that a user can take to finish the test.
DURATION_BETWEEN_ATTEMPT	NUMBER	(3)		Duration that the user has to wait after he has submitted a test.
TYPE_FLAG	VARCHAR2	(1)	Yes	Permissible values are 'D' or 'S'. 'D' is for Rule Based test and 'S' is for Pre Selected. The questions that should be part of the test have to be specified when the test is created.
FEEDBACK_TYPE_FLAG	VARCHAR2	(1)	Yes	The permissible values are 'D' ,'I' or 'N'. 'I' is for immediate feedback. 'D' is for End of test. 'N' is for No Feedback.
DURATION	NUMBER	(15)		Test Duration in Minutes.
WARNING_DURATION	NUMBER	(15)		Duration in Minutes when the time remaining will be shown in red to make the user alert that the test duration is about to expire and they should prepare to submit the test
WARNING_ENABLED_FLAG	VARCHAR2	(1)	Yes	Determines whether or not an alert should be displayed to the user indicating that the time allowed for the test is about to run out.
INHERIT_FEEDBACK_FLAG	VARCHAR2	(1)	Yes	Determines whether the questions would inherit feedback from the Test Section or Test if there is no correct and wrong feedback supplied for the questions.
TEST_TYPE_FLAG	VARCHAR2	(1)	Yes	Determines whether the test is a Test or a Survey. If it is a survey it will not be scored
TEST_INSTRUCTIONS	VARCHAR2	(4000)		Test Instructions that are presented to the user when the user starts to take the test
CORRECT_FEEDBACK	VARCHAR2	(4000)		Correct Feedback for a question.This will be shown to the user if the question does not have a correct feedback of its own and the inherit_feedback_flag is set to Y
WRONG_FEEDBACK	VARCHAR2	(4000)		Wrong Feedback for a question.This will be shown to the user if the question does not have a wrong feedback of its own and the inherit_feedback_flag is set to Y
POST_TEST_FEEDBACK	VARCHAR2	(4000)		Test Feedback that would be shown after the user has submitted the test. Could be used to specify remedial actions
RESUME_FLAG	VARCHAR2	(1)	Yes	Determine whether the test is resumable.
RESUME_INSTRUCTIONS	VARCHAR2	(4000)		Determine the resume instruction.
QUESTION_REVIEW_FLAG	VARCHAR2	(1)	Yes	Whether the user can mark a questions for review and skip it to come back to it later
FEEDBACK_SHOW_ANSWER_FLAG	VARCHAR2	(1)	Yes	Whether the correct answer should be shown in the feedback mode
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
SHOW_SUMMARY_FLAG	VARCHAR2	(1)	Yes	Indicate to show the summary
SHOW_CONFIRMATION_FLAG	VARCHAR2	(1)	Yes	Indicate to show confirmation
SHOW_EXIT_FLAG	VARCHAR2	(1)	Yes	Indicate to show exit
SHOW_SCORE_FLAG	VARCHAR2	(1)	Yes	Indicate to show test score

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TEST_ID
,      BUSINESS_GROUP_ID
,      DURATION_FLAG
,      GRADE_FLAG
,      DISPLAY_ORDER_FLAG
,      QUESTIONS_PER_PAGE
,      MAX_ATTEMPTS
,      DURATION_BETWEEN_ATTEMPT
,      TYPE_FLAG
,      FEEDBACK_TYPE_FLAG
,      DURATION
,      WARNING_DURATION
,      WARNING_ENABLED_FLAG
,      INHERIT_FEEDBACK_FLAG
,      TEST_TYPE_FLAG
,      TEST_INSTRUCTIONS
,      CORRECT_FEEDBACK
,      WRONG_FEEDBACK
,      POST_TEST_FEEDBACK
,      RESUME_FLAG
,      RESUME_INSTRUCTIONS
,      QUESTION_REVIEW_FLAG
,      FEEDBACK_SHOW_ANSWER_FLAG
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SHOW_SUMMARY_FLAG
,      SHOW_CONFIRMATION_FLAG
,      SHOW_EXIT_FLAG
,      SHOW_SCORE_FLAG
FROM OTA.OTA_TESTS;

Dependencies

[top of page]

OTA.OTA_TESTS does not reference any database object

OTA.OTA_TESTS is referenced by following:

APPS: OTA_TESTS; OTA_TESTS_WHO