[Home] [Help] [Dependency Information]
Object Name: | OTA_RESPONSE_VALUES |
---|---|
Object Type: | TABLE |
Owner: | OTA |
FND Design Data: | OTA.OTA_RESPONSE_VALUES |
Subobject Name: | |
Status: | VALID |
This stores the response values for a question. There is a 1:N relation between OTA_RESPONSE_TYPES and OTA_RESPONSE_VALUES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
OTA_RESPONSE_VALUES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | RESPONSE_VALUE_ID |
OTA_RESPONSE_VALUES_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RESPONSE_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESPONSE_VALUE_ID | NUMBER | (15) | Yes | The system generated surrogatekey for thi sresponse value |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign Key to HR_ALL_ORGANIZATION_UNITS |
RESPONSE_TYPE_ID | NUMBER | (15) | Yes | Foreign Key to OTA_RESPONSE_TYPES. |
CORRECT_FLAG | VARCHAR2 | (1) | Yes | Whether the specified response is correct. For Fill in the Blank Text and Numeric you can specify multiple correct values. If the user enters one of the supplied values the points for the questions will be awarded. For Fill in the blanks all responses will be marked with Y. The allowed values are Y for Correct and N for Incorrect. This field is not exposed on the UI for the Fill in the Blank type questions. |
SEQUENCE | NUMBER | (3) | Yes | Specifies the order in which the responses will be displayed. If the Question has a Display Order Flag set to R(Random) this col will not be used when the response values are specified. If however it is set to S(Fixed) then the order in which the responses are displayed will be based on the sequence specified by the user. |
TEXT | VARCHAR2 | (4000) | Yes | The response value text. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Version control parameter. |
START_DATE_ACTIVE | DATE | The Date when the response value become active. | ||
END_DATE_ACTIVE | DATE | The Date when the response value 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 |
Cut, paste (and edit) the following text to query this object:
SELECT RESPONSE_VALUE_ID
, BUSINESS_GROUP_ID
, RESPONSE_TYPE_ID
, CORRECT_FLAG
, SEQUENCE
, TEXT
, OBJECT_VERSION_NUMBER
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM OTA.OTA_RESPONSE_VALUES;
OTA.OTA_RESPONSE_VALUES does not reference any database object
OTA.OTA_RESPONSE_VALUES is referenced by following:
|
|
|