[Home] [Help] [Dependency Information]
Object Name: | OTA_QUESTIONS |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_QUESTIONS |
Subobject Name: | |
Status: | VALID |
This table contains the question definitions. Questions can be reused in different tests. At present there is support for Five Types of Questions. The data model is designed to support hybrid questions e.g Support Multiple Choice Single Correct and Fill in the Blank type question. The Five types of questions supported are 1. Fill in the Blanks(Text) 2. Fill in the Blanks(Numeric) 3. True/False 4. Single Choice 5. Multiple Choice.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_QUESTIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | QUESTION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUESTION_ID | NUMBER | (15) | Yes | The system generated surrogatekey for this question. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS. |
TEXT | VARCHAR2 | (4000) | Yes | Determine text for the question |
ALLOW_HTML_FLAG | VARCHAR2 | (1) | Yes | Determine whether HTML is allowed for the question. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter. |
START_DATE_ACTIVE | DATE | The Date when the question become active. | ||
END_DATE_ACTIVE | DATE | The Date when the question become inactive. | ||
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 QUESTION_ID
, BUSINESS_GROUP_ID
, TEXT
, ALLOW_HTML_FLAG
, OBJECT_VERSION_NUMBER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, 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_QUESTIONS;
OTA.OTA_QUESTIONS does not reference any database object
OTA.OTA_QUESTIONS is referenced by following:
|
|
|