[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_QUES_DATA |
---|---|
Object Type: | TABLE |
Owner: | IES |
Subobject Name: | |
Status: | VALID |
stores summary information about survey question freq
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IES_SVY_QUES_DATA_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SURVEY_ID |
IES_SVY_QUES_DATA_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SURVEY_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SURVEY_ID | NUMBER | Unique Identifier for each survey | ||
SURVEY_NAME | VARCHAR2 | (80) | Name of Survey | |
SURVEY_DEPLOYMENT_ID | NUMBER | Unique Identifier for each deployment (foreign key on ies_svy_deplyments_all) | ||
DEPLOYMENT_NAME | VARCHAR2 | (256) | Name of Deployment in a cycle | |
DSCRIPT_ID | NUMBER | Unique Id for Deployed Scripts | ||
DSCRIPT_NAME | VARCHAR2 | (256) | Deployed script name | |
PANEL_ID | NUMBER | Unique identifier for Panel | ||
PANEL_NAME | VARCHAR2 | (256) | Name of Panel | |
QUESTION_ID | NUMBER | Unique Identifier for Question | ||
QUESTION_NAME | VARCHAR2 | (256) | Name of Question | |
LOOKUP_ID | NUMBER | Unique Identifier for lookups | ||
ANSWER_ID | NUMBER | Unique Identifier for Answer | ||
ANSWER_VALUE | VARCHAR2 | (256) | Value of Answer | |
ANSWER_DISPLAY_VALUE | VARCHAR2 | (256) | Displayed Answer Value | |
ANSWER_COUNT | NUMBER | Sum of answers answered | ||
SECURITY_GROUP_ID | NUMBER | (15) | Used for Hosted Environment | |
QUESTION_TYPE | VARCHAR2 | (240) | Type of the question | |
SURVEY_CYCLE_ID | NUMBER | Unique identifier for survey cycle | ||
QUESTION_ORDER | NUMBER | Sequence of question in survey | ||
ANSWER_ORDER | NUMBER | Sequence of the Answer | ||
CYCLE_NAME | VARCHAR2 | (80) | Name of the survey cycle |
Cut, paste (and edit) the following text to query this object:
SELECT SURVEY_ID
, SURVEY_NAME
, SURVEY_DEPLOYMENT_ID
, DEPLOYMENT_NAME
, DSCRIPT_ID
, DSCRIPT_NAME
, PANEL_ID
, PANEL_NAME
, QUESTION_ID
, QUESTION_NAME
, LOOKUP_ID
, ANSWER_ID
, ANSWER_VALUE
, ANSWER_DISPLAY_VALUE
, ANSWER_COUNT
, SECURITY_GROUP_ID
, QUESTION_TYPE
, SURVEY_CYCLE_ID
, QUESTION_ORDER
, ANSWER_ORDER
, CYCLE_NAME
FROM IES.IES_SVY_QUES_DATA;
IES.IES_SVY_QUES_DATA does not reference any database object
IES.IES_SVY_QUES_DATA is referenced by following:
|
|
|