[Home] [Help] [Dependency Information]
Object Name: | IES_SVY_QUES_DATA# |
---|---|
Object Type: | VIEW |
Owner: | IES |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SURVEY_ID | NUMBER | |||
SURVEY_NAME | VARCHAR2 | (80) | ||
SURVEY_DEPLOYMENT_ID | NUMBER | |||
DEPLOYMENT_NAME | VARCHAR2 | (256) | ||
DSCRIPT_ID | NUMBER | |||
DSCRIPT_NAME | VARCHAR2 | (256) | ||
PANEL_ID | NUMBER | |||
PANEL_NAME | VARCHAR2 | (256) | ||
QUESTION_ID | NUMBER | |||
QUESTION_NAME | VARCHAR2 | (256) | ||
LOOKUP_ID | NUMBER | |||
ANSWER_ID | NUMBER | |||
ANSWER_VALUE | VARCHAR2 | (256) | ||
ANSWER_DISPLAY_VALUE | VARCHAR2 | (256) | ||
ANSWER_COUNT | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | (15) | ||
QUESTION_TYPE | VARCHAR2 | (240) | ||
SURVEY_CYCLE_ID | NUMBER | |||
QUESTION_ORDER | NUMBER | |||
ANSWER_ORDER | NUMBER | |||
CYCLE_NAME | VARCHAR2 | (80) |
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#;
|
|
|