[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OTA_TEST_SECTIONS |
|---|---|
| Object Type: | TABLE |
| Owner: | OTA |
| FND Design Data: |  OTA.OTA_TEST_SECTIONS
|
| Subobject Name: | |
| Status: | VALID |
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
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OTA_TEST_SECTIONS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TEST_SECTION_ID
|
| OTA_TEST_SECTIONS_FK1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LEARNING_OBJECT_ID
|
| OTA_TEST_SECTIONS_FK2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TEST_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TEST_SECTION_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this test section. |
| TEST_ID | NUMBER | (15) | Yes | Foreign Key to OTA_TESTS. |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS. |
| NAME | VARCHAR2 | (240) | Yes | Name of the Test Section. |
| MANDATORY_FLAG | VARCHAR2 | (1) | Yes | Whether the section is mandatory. If the section is mandatory, the user would not be allowed to submit the test unless all the questions in this section have been answered. For test that have time restrictions and the user has run out of time the user would be allowed to submit the test even though the user maynot have answered all the mandatory sections. |
| DISPLAY_ORDER_FLAG | VARCHAR2 | (1) | Yes | This specifies if the questions within a section 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 |
| TYPE_FLAG | VARCHAR2 | (1) | Yes | Not being used. |
| SEQUENCE | NUMBER | (5) | Yes | Specifies the order of the questions. The questions will be displayed in the order specified if the display_order_flag is set to S |
| DESCRIPTION | VARCHAR2 | (4000) | Section description | |
| 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 | |
| LEARNING_OBJECT_ID | NUMBER | (15) | Foreign key to OTA_LEARNING_OBJECTS | |
| START_DATE_ACTIVE | DATE | The Date when the test section become active. | ||
| END_DATE_ACTIVE | DATE | The Date when the test section become inactive. | ||
| 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 | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment column. | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment column. |
Cut, paste (and edit) the following text to query this object:
SELECT TEST_SECTION_ID
, TEST_ID
, BUSINESS_GROUP_ID
, NAME
, MANDATORY_FLAG
, DISPLAY_ORDER_FLAG
, TYPE_FLAG
, SEQUENCE
, DESCRIPTION
, CORRECT_FEEDBACK
, WRONG_FEEDBACK
, LEARNING_OBJECT_ID
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
FROM OTA.OTA_TEST_SECTIONS;
OTA.OTA_TEST_SECTIONS does not reference any database object
OTA.OTA_TEST_SECTIONS is referenced by following:
OTA
OTA_TEST_SECTIONS#
|
|
|
|